Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot Append to database from remote view
Message
From
16/03/1999 14:31:09
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00198025
Message ID:
00198267
Views:
19
>This is very strange. And you're SURE that TABLEUPDATE() is returning .T.? One think you should do is make sure that any dates aren't empty. If you have an empty date you need to replace it with NULL because Access doesn't understand blank dates. Still, if this were the problem I would expect TABLEUPDATE() to return .F.


Halleujah!!! Thanks to you the Append problem appears to be solved. I would have never known that empty dates would cause this condition. I removed the date replacements from the code to test and it appended just fine. If you're ever down in the Sarasota area, look me up and I'll buy you a dinner.

Thanks again.

Barry
If at first you don't succeed......SET STEP ON!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform