Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
=SQLEXEC
Message
From
27/03/2000 13:16:15
 
 
To
27/03/2000 10:58:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00350752
Message ID:
00350847
Views:
22
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform