Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot Append to database from remote view
Message
 
To
16/03/1999 11:15:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00198025
Message ID:
00198123
Views:
18
>>Barry,
>>
>>After you append the data, does TABLEUPDATE() return .F.? If so, use AERROR() to find out what error the ODBC driver returned. That will help diagnose the problem.
>>
>
>HI Josh,
>
>I included the Aerror() routine, however the tablupdate() returned true. Records requiring updating for existing mdb data updated just fine. I just can't APPEND new records. Could this be something to do with the way the Access mdb is configured? Is there a property or something that inhibits additions? Sure could use some help...

So you append the records, then use TABLEUPDATE() and it returns .T., but the records aren't added? That's strange. If you're using table buffering make sure you use the all rows parameter in TABLEUPDATE() (i.e. TABLEUPDATE(1)).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform