Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate not updating
Message
From
15/04/1999 16:20:43
 
 
To
15/04/1999 16:18:53
Sonny Chouinard
CHCA Computer Systems Inc.
Lachenaie, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00208740
Message ID:
00208772
Views:
23
They had a really obscure KB article that I think related to the problem but they didn't mention any specific products, just advised caution with databases and windows. When I went to re-find that KB recently I couldn't.


>Thanks for your response. It is indeed a really strange situation. Does Microsoft issue a statement on that? I will test the getnextmodified() to update individual row. I was using TABLEUPDATE(.t.,.t.,'MyTable').
>
>Thanks a lot again?
>
>>I've seen that one. Try, if possible, to switch to row buffering -or- you can use table buffering but use a save routine which uses GETNEXTMODIFIED() to commit each individual row.
>>
>>PITA, isn't it? :-)
>>
>>>I have a really weird problem. I'm using remote views with SQL Server. I have a form using several remote views. When I try tou update it. When I save my views, all is ok. But If I save and immediatly after, do a requery, I have a "table buffer for alias..." error. Even though the tableupdates succeed. If I do the same thing but wait a little before requerying, I don't have the error!!!
>>>
>>>Does this happened to someone???
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform