Hi
If you view doesn't have a keyfield so that VFP can identify exactly which
row to update then it has to compare all fields till it finds the one to
update. The default is now 40 fields. If there are more than 40 fields that
it nneds to look at you have to allocate more memory for this operation. No
keyfield and more than 40 columns in a table also makes one suspect that the
table needs normalizing to a higher Normal Form level.
-Anders
----- Original Message -----
From: "Jean MAURICE" <jmaurice .AT. alpiga DOT com>
To: <profox@leafe.com>
Sent: Monday, March 31, 2003 2:05 PM
Subject: about SYS(3055)
> As I am playing with tableupadte(), I got an error about a SQL command
being
> too complicated. I did what it is said and write =SYS(3055,600). All is
now
> fine.
>
> What is the use of SYS(3055) ? In the help, it is said that the clause
WHERE
> used to REACH the correct record is too complicated. But, I have only 3
key
> fields, a candidate index on those 3 fields, ...
>
> I would have written : "is too complicated to look if the record has been
> modified ". Am I right ?
>
> J. MAURICE .AT. Grenoble DOT France.Europe UFPRC - Foxil
> unable to forget {^2001.09.11}
>
>
[excessive quoting removed by server]
©2003 Anders Altberg |
