Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning a date
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00503012
Message ID:
00503040
Views:
17
>>>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...;
>It's not going to work. See my other post.

Saw it and you're right. However, this does work
SELECT MaxDate(date1, date2, date3, date4) AS Latest;
  FROM TableAlias;
  ORDER BY 1;
  INTO CURSOR Foo

FUNCTION MaxDate

  LPARAMETERS date1, date2, date3, date4
  RETURN MAX(date1, date2, date3, date4)
ENDFUNC
George

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

Click here to load this message in the networking platform