Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Working with ODBC
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00563222
Message ID:
00563786
Views:
18
>I've done all that you mentioned, however, what do you do when tableupdate(.t.)
>returns a false. What could be the cause of this. I have defined the keys, made all the necessaty fields "updatable" have checked the send SQL UPDATES checkbox.
>
>Do I need to use the Insert-SQL command? Or with the append blank statement work?
>
>Sandy

Open the MS Access database. On the Tables tab, click on the table in question and open the Table Designer. Make sure there is an ID field that is the unique record identifier.

You are doing everything right that I can see. I had to do this just yesterday and it is just as easy as we have described.

When you get False returned for TableUpdate, issue at the command window:

? aerror(laError)
disp memo like laError*

This will give you more detailed error info.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform