Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate() of a view. Is there a limit on number of field
Message
De
12/04/2001 15:44:32
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
TableUpdate() of a view. Is there a limit on number of field
Divers
Thread ID:
00495027
Message ID:
00495027
Vues:
68
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform