Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot Append to database from remote view
Message
 
To
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:
00198294
Views:
17
>>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

Barry,

Glad I could help. If Duke continues their winning ways I'll be in St. Pete next weekend, but I won't hold you to the dinner offer. You'd have to buy dinner for my wife and her family, too which could get a bit pricey :)

Actually, if you knew of a hotel or B&B in the area with a few free rooms next weekend I'd be eternally grateful (fat chance, I know, but I had to ask).
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform