Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: Bronny
  Where is Bronny?
Subject: RE: Requering
Thread ID: 104287 Message ID: 104294 # Views: 1 # Ratings: 1
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Monday, August 14, 2006 6:35:22 PM         

> 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
> Requery(ViewName)
> 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.

Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA


Requering Posted by Bronny @ 8/14/2006 5:38:33 PM
RE: Requering Posted by Andy Kramek @ 8/14/2006 6:35:22 PM
RE: Requering Posted by Bronny @ 8/15/2006 6:07:29 AM