Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate() of a view. Is there a limit on number of field
Message
From
12/04/2001 15:44:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
TableUpdate() of a view. Is there a limit on number of field
Miscellaneous
Thread ID:
00495027
Message ID:
00495027
Views:
69
Help!!!

Is there any limit to the number of fields that may be updated.
I have a table with 44 fields.
I have a view with all these fields, plus several calculated fields (e.g. name, etc. used for display only).
I do a scatter memvar, change some values, then gather memvar,
TABLEUPDATE(1,.F.) returns .f.
TABLEUPDATE(1,.T.) returns .t.
I am the only one using this file.

adding a new record
INSERT INTO FROM MEMVAR
TABLEUPDATE(1,.F.) returns .t.

If I do the above to a Table rather than a View
I do a scatter memvar, change some values, then gather memvar,
TABLEUPDATE(1,.F.) returns .t.

********************************************************
If I do gather memvar fields
GATHER MEMVAR MEMO FIELDS ;
CACCTNUM,CPERSEQ,CSCHYEAR,CSCHTERM,CSCHSEQ,CSCHCODE,CCLASS,CPERIOD,;
TENTERED,DREGIST,DSTART,DSTOP,LWAITLIST,;
C01,C02,C03,C04,C05,C06,C07,C08,C09,C10,CCOMMENT
IF !TABLEUPDATE(1,.F.,ThisForm.cFileMain)
EXIT
ENDIF

GATHER MEMVAR MEMO FIELDS ;
CBILLTO,CBILLED,CFEECODE,NFEEAMT,NDISCNT1,NDISCNT2,;
CMARKS1,CMARKS2,CREFER,CADDRCODE,CBILLSTAT,DLASTBILL,;
DCANCDATE,LNOAUTO,CBUS1NUM,CBUS1STOP,CBUS1TIME,CBUS2NUM,CBUS2STOP,CBUS2TIME
IF !TABLEUPDATE(1,.F.,ThisForm.cFileMain)
EXIT
ENDIF
there is no error.
********************************************************

Am I missing somthing, or is there a limit of number of fields?
If there is there a limit of number of fields, is there a general way to work around?
I use this code for various forms/files.

Thanks for any help,
Shlomo
Next
Reply
Map
View

Click here to load this message in the networking platform