From: Andy Kramek
Hot Springs Village
Arkansas - United States
Visual FoxPro 6
Databases, Tables and SQL Server
Monday, August 14, 2006 6:35:22 PM
This message was rated by:
# Ratings: 1
> I use VFP database views.
> These views are able to send update to SQL Server.
> After changing some values in one view I used command
> It gave the error message:
> Line is too long (Error 18).
> The maximum length for a command line (2048 bytes) has been exceeded.
> Macro substitution might have caused the line to expand beyond the 2048 byte limit.
> What should I do to solve this problem ?
> I've changed only two fields which types were char(230).
Check the WHERETYPE setting, you may have it set to be using "Key and Modified" in which case the original values are probably being sent along with your changes - change to KEY ONLY and you should not have this problem.
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA
Posted by Bronny @ 8/14/2006 5:38:33 PM
Posted by Andy Kramek @ 8/14/2006 6:35:22 PM
Posted by Bronny @ 8/15/2006 6:07:29 AM