Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
=SQLEXEC
Message
De
27/03/2000 13:16:15
 
 
À
27/03/2000 10:58:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00350752
Message ID:
00350847
Vues:
23
Edgar,

You can always modify your SQL statement to add the fields you require. For example, let's say your SQL statement is:

SELECT * FROM Customers

and you want a logical (.T./.F.) field named "changed" to say if a user modified the record, you can change your SQL statement to:

SELECT *, CAST(0 AS BIT) AS changed FROM Customers

CAST is used to make "0" a logical field. All there is left now is for you to set .T. into the "changed" field as you need to.

Hope this helps!



>The cursor comes back with 2 fields (cause that's how many I called) but I want to add one more field to that cursor to keep track of user's changes to it.
>If I create a cursor beforehand with the same name (tempCursor) that will be replaced with my =SQLEXEC
>How do I add another field ?
Sylvain Demers
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform