Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Pass Thru and Properties
Message
 
 
To
21/07/2010 12:45:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01473308
Message ID:
01473309
Views:
69
My guess is that oApp is a global variable and as such is always available. The 'ThisForm' is only available to the code executed in the context of a form.

>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?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform