string error_syntaxfromSQL, error_create
string new_sql, new_syntax
int hd1 ,hd2
//创建文件夹
if DirectoryExists (trim(sle_1.text)) then
hd1=messagebox('','此文件夹存在,请重新命名!',information!,yesno!)
end if
if hd1=2 then return
hd2=CreateDirectory (trim(sle_1.text))
if hd2= -1 then
messagebox('','对不起不能创建这个文件夹,请重新给文件夹命名!')
return
else
messagebox("警告!",'系统将会需要一段时间备份数据,~n' &
+' 请耐心等候!')
end if
new_sql = 'SELECT * from 表名'
new_syntax = SQLCA.SyntaxFromSQL(new_sql, 'Style(Type=Form)', error_syntaxfromSQL)
IF Len(error_syntaxfromSQL) > 0 THEN
MessageBox("Caution", "SyntaxFromSQL caused these errors: " + error_syntaxfromSQL)
ELSE
dw_1.Create(new_syntax, error_create)
IF Len(error_create) > 0 THEN
MessageBox("Caution", "Create cause these errors: " + error_syntaxfromSQL)
END IF
END IF
dw_1.settransobject(sqlca)
dw_1.retrieve()
string error_syntaxfromSQL, error_create
string new_sql, new_syntax
int hd1 ,hd2
//创建文件夹
if DirectoryExists (trim(sle_1.text)) then
hd1=messagebox('','此文件夹存在,请重新命名!',information!,yesno!)
end if
if hd1=2 then return
hd2=CreateDirectory (trim(sle_1.text))
if hd2= -1 then
messagebox('','对不起不能创建这个文件夹,请重新给文件夹命名!')
return
else
messagebox("警告!",'系统将会需要一段时间备份数据,~n' &
+' 请耐心等候!')
end if
IF Len(error_syntaxfromSQL) > 0 THEN
MessageBox("Caution", "SyntaxFromSQL caused these errors: " + error_syntaxfromSQL)
ELSE
dw_1.Create(new_syntax, error_create)
IF Len(error_create) > 0 THEN
MessageBox("Caution", "Create cause these errors: " + error_syntaxfromSQL)
END IF
END IF