Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorAdapter Class & Fox Tables
Message
De
20/04/2010 11:47:12
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01461068
Message ID:
01461134
Vues:
70
You have test4 as .Tables, .Alias and as Alias in the UpdateNameList.
Such an approach (for instance when replacing table based acces with dozens of implemented rules and screens) is possible with more "footwork" in the base clases, but not recommended when you are new to CA. for new projects use a special prefix for the cursors, for instance crsTablename or T_ Tablename (for Temp).

HTH

thomas
>The same class with a table with 5 fields doesn't present the problem.....So the problem is in the number of fields ? What do you think ?
>
>>There are too many fields. Can you try with just a few fields in CursorSchema and UpdateList?

>>>>By the quick glance it looks like you have multiple aliases in the UpdateNameList. You can not update more than one table a time. Use one primary table for your updates and don't include fields from other tables into update list.

>>>>>
>>>>>DEFINE CLASS clifor AS cursoradapter
>>>>>
>>>>>
>>>>>	Tag = ['Provider=VFPOLEDB.1;Data Source=C:\Programmi\ApprodoGlobe\Aziende\Acut;Mode=ReadWrite;Password="";Collating Sequence=MACHINE;']
>>>>>	Height = 22
>>>>>	Width = 23
>>>>>	SelectCmd = "select * from test4"
>>>>>	Alias = "test4"
>>>>>	Tables = "test4"
>>>>>	UpdateNameList = "CODE test2.code, RAS1 test2.ras1, INDI test2.indi, LOCA test2.loca, CAP test4.CAP, PROV test4.PROV, "+;
>>>>>	"STAT test4.STAT, PCON test4.PCON, CFIS test4.CFIS, PIVA test4.PIVA, TEL1 test4.TEL1, TEL2 test4.TEL2, CELL test4.CELL, "+;
>>>>>	"TFAX test4.TFAX, MAIL test4.MAIL, ABI test4.ABI, CAB test4.CAB, CTCO test4.CTCO, CPAG test4.CPAG, NSPE test4.NSPE, "+;
>>>>>	"ZONA test4.ZONA, DIKM test4.DIKM, DIHO test4.DIHO, CTVE test4.CTVE, CTRI test4.CTRI, CIVA test4.CIVA, LETT test4.LETT, "+;
>>>>>	"DLET test4.DLET, PROT test4.PROT, DPRO test4.DPRO, CAGE test4.CAGE, DIVI test4.DIVI, TRAS test4.TRAS, VETT test4.VETT, "+;
>>>>>	"CDES test4.CDES, PORT test4.PORT, SETT test4.SETT, CATE test4.CATE, LIST test4.LIST, PLIS test4.PLIS, SCO1 test4.SCO1, "+;
>>>>>	"SCO2 test4.SCO2, PAGE test4.PAGE, MES1 test4.MES1, MES2 test4.MES2, SDAY test4.SDAY, ALARM test4.ALARM, LBLO test4.LBLO, "+;
>>>>>	"LMOV test4.LMOV, TFATT test4.TFATT, TRAT test4.TRAT, INTE test4.INTE, DAT1 test4.DAT1, DAT2 test4.DAT2, FIDO test4.FIDO, "+;
>>>>>	"CONF test4.CONF, COMM test4.COMM, ASS test4.ASS, RICO test4.RICO, RICS test4.RICS, RICA test4.RICA, RICM test4.RICM, "+;
>>>>>	"FIL2 test4.FIL2, FIL3 test4.FIL3, FIL4 test4.FIL4, FIL5 test4.FIL5, FIL6 test4.FIL6, PPR test4.PPR, CEE test4.CEE, "+;
>>>>>	"FOL test4.FOL, CIN test4.CIN, CBIC test4.CBIC, CCP test4.CCP, CIFA test4.CIFA, CINT test4.CINT, COR test4.COR, "+;
>>>>>	"IBAN test4.IBAN, IWEB test4.IWEB, LFA test4.LFA, NAL test4.NAL, NAP test4.NAP, NOP test4.NOP, NTE test4.NTE, "+;
>>>>>	"PPG test4.PPG, PR1 test4.PR1, PR2 test4.PR2, PR3 test4.PR3, RCP test4.RCP, GCRI "+;
>>>>>	"test4.GCRI, SOSP test4.SOSP, NLIN "+;
>>>>>	"test4.NLIN, NOFT test4.NOFT, EAN test4.EAN, ACTI test4.ACTI, CEVE test4.CEVE, CORA test4.CORA, DAAZ test4.DAAZ, "+;
>>>>>	"DEAL test4.DEAL, PROM test4.PROM, SCAT test4.SCAT, TEL3 test4.TEL3, TIPO test4.TIPO, CCLA test4.CCLA, EVID test4.EVID, "+;
>>>>>	"UEID test4.UEID, FOLDER test4.FOLDER, IMP test4.IMP, LDA test4.LDA, NAT test4.NAT, STI test4.STI, LUP test4.LUP, "+;
>>>>>	"ARS test4.ARS, PWD test4.PWD, TIPP test4.TIPP, UML test4.UML, UPD test4.UPD, USR test4.USR, DAT5 test4.DAT5, "+;
>>>>>	"SITU test4.SITU, DNAS test4.DNAS, LNAS test4.LNAS, SES test4.SES, RSR test4.RSR, REGI test4.REGI, CLAS test4.CLAS, "+;
>>>>>	"RIV test4.RIV, CCAP test4.CCAP"
>>>>>	
>>>>>	ConversionFunc = ""
>>>>>	Name = "clifor"
>>>>>
>>>>>
>>>>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform