Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL statement too long on TableUpdate()
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
SQL statement too long on TableUpdate()
Miscellaneous
Thread ID:
00144440
Message ID:
00144440
Views:
57
I get a 'SQL Statement too long error' when I try to update a view with TableUpdate().

My view is really simple:
SELECT * FROM mytable WHERE primarykey='fixedvalue'
however, mytable has a lot of fields (about 120).

The view is updatable.

The problem only occurs when I modify MOST OF THE FIELDS in the view and then I try to update the view. The problem does not occur when I change only a few fields.

Any ideas?
Hector Correa
Next
Reply
Map
View

Click here to load this message in the networking platform