Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass Thru and Properties
Message
From
21/07/2010 12:45:02
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Pass Thru and Properties
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01473308
Message ID:
01473308
Views:
116
I've been doing this by trial and error but there must be some logic here

This works:

"EXEC sp_Update_Atmservice ?ln_transid, ?lc_orderstatus, ?lc_notes, ?oApp.gc_user"

This does not work:

"EXEC sp_Update_Atmservice ?ln_transid, ?thisform.lc_orderstatus, ?lc_notes, ?oApp.gc_user"

I'm wondering why the property oApp.gc_user is OK and the property thisform.lc_orderstatus is not.Both are character properties with character values in them.

In order to get the second line to work, I have to move thisform.lc_orderstatus into a memory variable and pass that thru.

What is the logic here?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Next
Reply
Map
View

Click here to load this message in the networking platform