Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I write records to an MS Access table?
Message
From
15/03/2000 12:15:39
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00345161
Message ID:
00345924
Views:
16
How do you deal with VFP adding trailing spaces to the Access field values?

>I use ODBC and remote views to MS Access tables. Works great.
>
>>I can do this much, which gets me a list of the tables in a chosen .MDB file stuck into the ACCTABLES cursor.
>>My goal is to be able to add records to the customer table in the open database, but I guess my SQLEXEC function isn't the way to go about it...
>>How far off am I?
>>
>>sh = SQLCONNECT() && Will ask me what I want to connect to
>>retval = SQLSETPROP(sh, 'Asynchronous', .F.)
>>retval = SQLTABLES(sh, "TABLE", "ACCTABLES")
>>retval = SQLEXEC(sh, [INSERT INTO Customer (firstname, lastname) VALUES ("first_name", "last_name")] )
>>
>>retval = SQLEXEC(sh, "SELECT * FROM Customer", "custcopy")
>>
>>SELECT custcopy
>>BROW && And it's still empty!
>>
>>What should I be doing?
>>
>>Thanx!
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform