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
©2003 Bill Anderson |
