>> Would suggest DB_KeyandModified. <<
That's the setting being used...
Bill
Greg Gum wrote:
>Bill,
>
>What kind of wheretype are you using? Would suggest DB_KeyandModified.
>
>Greg
>
>-----Original Message-----
>From: profox-admin (at) leafe .D.OT com [mailto:profox-admin@leafe.com] On Behalf
>Of Bill Anderson
>Sent: Wednesday, April 30, 2003 8:47 PM
>To: profox (at) leafe .D.OT 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 Bill Anderson |
