Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 5, SQLEXEC into Oracle Problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00137462
Message ID:
00137537
Views:
17
That's exactly what I needed!!! Thanks! I still haven't gotten used to that little question mark guy.

Laurisa

>The easiest way to do it is to assign the datetime value to a vfp variable, then use the ? to tell VFP to evaluate the variable and send its contents to the ODBC driver. Like this:
>
>m.ltDateTime={08/08/1998 10:00 AM}
>ntest=sqlexec(nconnect, "insert into pmwrkord ;
>	(pmwrkord_code, its_current_date) ;
>	values (9200007),?m.ltDateTime)")
Previous
Reply
Map
View

Click here to load this message in the networking platform