Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Pass Thru and Properties
Message
De
21/07/2010 12:45:02
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Pass Thru and Properties
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01473308
Message ID:
01473308
Vues:
115
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform