Dan:

Thanks for the reply ! Get_Time() is a function that I wrote the

changes from/to 12/24 hr. time. It works fine everywhere except on this

networked system, so I am sure that the network changes how the SQL

works?! I hate am/pm too, but my customers insist that they can't

understand the 24 hr. clock !?

On Mon, 10 Jan 2000, Dan Covill wrote:

> Les:

>

> What is Get_Time()? It's not a native VFP procedure, at least not

> according to the help I have. Is it from some network library?

>

> My guess is that it expects its input time in 12-hour am/pm, and your times

> are in 24-hour. (I absolutely HATE am/pm!)

>

> Dan Covill

> Middleton Consulting, San Diego

>

> At 04:18 PM 1/8/2000 -0500, you wrote:

> >Hi All:

> > I have had an app working for some time without problems. One

> >client has just installed a Novell Personal Netware network. They now get

> >the following error:

> > error - 1811

> > - SQL Aggregate on non-numeric expression

> >

> >The line of code that produces this error is:

> > Select get_time("F", SUBSTR(unap.ut,1,5), " ") + ;

> > ALLTRIM(STR(unap.uvmv)) AS ut2 From unap ;

> > Into Cursor unap2 Order By ut2

> >

> >The unap cursor looks like this:

> > ut uvmv

> > 13:30 PM 1

> > 13:30 PM 2

> >

> >The result of the SQL should look like this:

> > ut2

> > 1:30 p 1

> > 1:30 p 2

> >

> >Can anyone suggest why this works if the network is NOT switched on, but

> >breaks if the network IS switched on ???

> >

> >All suggestions greatfully accepted !

> >

> >TIA

Les Roberts

voice: (519) 886-5832

surface:

1A-57 Bridgeport Rd. E. E_mail:

Waterloo, Ont., Canada 00tack@mach1.wlu.ca

N2J 2J8