![]() |
#5 |
Участник
|
X++: cmdText = " CREATE TABLE " + filenameTmp + " ("; cmdTextInsertTemplate = " INSERT INTO " + filenameTmp + " ("; while select usrExpImpField order by usrExpImpField.Sequence where usrExpImpField.GroupId == groupId { if (usrExpImpField.Enabled) { fieldName = usrExpImpField.ExFieldName ? usrExpImpField.ExFieldName : usrExpImpField.fieldName(false, ""); cmdText += strfmt("%1 %2%3,", fieldName, this.BaseTypeToADOType(usrExpImpField.baseType()), usrExpImpField.baseType() == Types::String ? strfmt("(%1)",usrExpImpField.FieldSize()) : ""); cmdTextInsertTemplate += fieldName + ","; } } cmdText = strdel(cmdText,strlen(cmdText),1); cmdText += ")"; cmdTextInsertTemplate = strdel(cmdTextInsertTemplate,strlen(cmdTextInsertTemplate),1); cmdTextInsertTemplate += ") values ("; dBF_Con = new CCADOConnection(); aDO = new CCADOCommand(); aDR = new CCADORecordset(); dBF_Con.open("Driver={Microsoft dBase Driver (*.dbf)};"); ADO.activeConnection(dBF_Con); if (dBF_Con) { ADO.commandText(cmdText); ADR = ADO.execute(); } |
|