Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate() of a view. Is there a limit on number of f
Message
From
16/04/2001 13:15:10
 
 
To
12/04/2001 15:50:49
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00495027
Message ID:
00495849
Views:
13
Dear Brad,

FCOUNT() = 53
I entered:
SYS(3055, 8 * MIN(40, FCOUNT())) as help suggests,
?TABLEUPDATE(1,.F.)
I get same error.
AERROR() gives me: 1812 - SQL: Statement Too Long

SYS(3055, 8 * MIN(40, FCOUNT())) didn't make sense,
so I tried:
SYS(3055, 8 * MAX(40, FCOUNT())) as help suggests
?TABLEUPDATE(1,.F.)

It Worked!!!

Thanks alot,
Shlomo

Please note,
FP Help states:
Note Calling TABLEUPDATE( ) for a local table or view that doesn’t use key fields generates a long WHERE clause to find the update row.

I get an error even though I assign key fields.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform