Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning a date
Message
 
To
03/05/2001 10:23:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00503012
Message ID:
00503017
Views:
22
>I am trying to create a cursor by using an sql statement. One of my fields is a function. It sends four dates as parameters to the function. The function analizes the dates to find the lateest date. I need to return this value back to the cursor as a value for this field. Right now I get data mismatch. Please help.

If this is not run via SPT, why not just use the MAX() function?
SELECT MAX(date1, date2, date3, date4) AS MaxDate,...;
  FROM tablealias...;
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform