Bill,
What kind of wheretype are you using? Would suggest DB_KeyandModified.
Greg
-----Original Message-----
From: profox-admin /AT/ leafe .DOT com [mailto:profox-admin@leafe.com] On Behalf
Of Bill Anderson
Sent: Wednesday, April 30, 2003 8:47 PM
To: profox /AT/ leafe .DOT com
Subject: TableUpdate() error
Folks,
I have a technical question for you...
I have a denormalized table (it ain't my design, folks) that has 245
fields. Record Size is approaching 4800 bytes. VFP 7, SP1.
There's a view against this table that is in essence "Select * from
bigtable where key = ?vp_key". Straightforward stuff.
Only three fields are required. If I fill in values for these three
fields and TableUpdate(), I'll get back a false. No RI code is being
run. I've bumped the SYS(3055) function to 2040, so that's not a
problem. I've tried SetFldState()ing all the other fields back to 3 and
TableUpdate()ing, no go. ?TableUpdate(2, .t., Alias(), gaerrors)
returns nothing useful. Occasionally I can get a data type mismatch
error out of the message() function. The data types look fine.
I have a feeling I'm bumping up against some sort of internal buffer
limitation for the record size of the view.
Any ideas?
Bill Anderson
[excessive quoting removed by server]
©2003 Greg Gum |
