Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Line is too long
Message
From
09/02/2010 07:51:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Line is too long
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01448316
Message ID:
01448316
Views:
146
Hi,
I have a special database stored procedure which make a mirroring between databases using OnInsert event.
The way what I use
1) Generate local view for Database1
2) Scatter
3) Generate local view for Database2
4) Gather
5) Tableupdate()

It seems to work long time, (its 2006 software) and now I have an error - "Line is too long" during TABLEUPDATE,

I thinking it depends from "SQL Where clause includes" - but default it was "Key and modified fields" - in this case I'v got an error - Line is too long, if I change it to "key fields only" - then error is "Too much fields in update"

For Information .The source table has 207 columns.

The error happens in exe.. when I try to reporoduce it in VFP using debugger - it seems to work. No error during tableupdate.

Any help
Thanks
Denis
Next
Reply
Map
View

Click here to load this message in the networking platform