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();
}