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

>

>

>

>

>----------------------------------------

>To unsubscribe, send a message to: macjordomo@leafe.com, and include the

line

> UNSUBSCRIBE profox

>in the message body. Or go to http://leafe.com/mailListMaint.html and follow

>the instructions there.

>----------------------------------------

>

>

>