![]() |
#3 |
Участник
|
Да нет, вроде все инициализируем. Сами посудите:
X++: static void CCADOConnect1(Args _args) { CCADOConnection dbcon; CCADOCommand cmd; CCADORecordset rs; CCADOFields f; str cs; COM comrs; CustTable custTable; ; cs = "trusted_connection=yes;server=ADM; database=Interface; driver={SQL Server}"; dbcon = new CCADOConnection(); dbcon.open(cs); cmd = new ccadocommand(); cmd.activeConnection(dbcon); cmd.commandText('select * from CustTable order by AccountNum'); rs = cmd.execute(); comrs = rs.recordSet(); while (!rs.EOF()) { f=rs.fields(); ttsbegin; custTable.initValue(); custTable.AccountNum = f.itemIdx(0).value(); custTable.CustGroup = f.itemIdx(1).value(); custTable.Name = f.itemIdx(2).value() + ' ' + f.itemIdx(3).value(); custTable.Street = f.itemIdx(4).value(); custTable.City = f.itemIdx(5).value(); custTable.ZipCode = f.itemIdx(6).value(); custTable.CountryRegionId = f.itemIdx(7).value(); custTable.PartyType = DirPartyType::Organization; custTable.Currency = 'EUR'; custTable.LanguageId = 'EN'; if(custTable.validateWrite()) custTable.insert(); else ttsabort; ttscommit; comrs.moveNext(); } rs.close(); dbcon.close(); } |
|