Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized View of an Oracle Date Field
Message
From
03/04/1999 01:04:17
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00204813
Message ID:
00204893
Views:
17
>Has any successfully created a remote view of an Oracle table using a parameter on a date field? I have tried putting where Oracle_Table_Name.Begin_Date > ?lcBgnDate and get a return error of "No Result Set has been returned by the server."
>
>But if I actually put ...Begin_Date > '10/01/1995', I get a result set.
>
>Any success with this out there?

Just a shot in the dark, but is there any chance that something is getting lost in the translation of the date? Are you using DTOC() to get your character date, and if so, are you sure that DTOC is returning the date in the format you expect?
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform