D DelphiCQ6 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-14 #1 动态创建Access表，其中有一个字段为Real型，想在创建时指定它的小数位数为2位 比如 Create Table ClientTotal(Total Real); 请问SQL语句怎么写？
C comfan2001 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-14 #2 Digits : Integer ; //小数位数 TotalLength : Integer ; //总长度 begin Digits := 2 ; Sql := 'create Table ClientTotal(Total'+' Number('+IntToStr(TotalLength)+','+IntToStr(Digits)+'))'
Digits : Integer ; //小数位数 TotalLength : Integer ; //总长度 begin Digits := 2 ; Sql := 'create Table ClientTotal(Total'+' Number('+IntToStr(TotalLength)+','+IntToStr(Digits)+'))'
D DelphiCQ6 Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-14 #3 编译报错 Create_Table_String:='Create Table ClientTotal( Total Number(8,2) ) ADOQuery.SQL,Clear; ADOQuery.SQL.ADD(Create_Table_String); ADOQuery.SQL.Prepared; ADOQuery.SQL.ExecSQL; 提示说定义数据表结构出错
编译报错 Create_Table_String:='Create Table ClientTotal( Total Number(8,2) ) ADOQuery.SQL,Clear; ADOQuery.SQL.ADD(Create_Table_String); ADOQuery.SQL.Prepared; ADOQuery.SQL.ExecSQL; 提示说定义数据表结构出错
A ankery Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-14 #4 commandstr := 'CREATE TABLE total ( total numeric(8,2) )'; adocommand1.CommandText := commandstr; adocommand1.Execute;
commandstr := 'CREATE TABLE total ( total numeric(8,2) )'; adocommand1.CommandText := commandstr; adocommand1.Execute;
