dt.excute "create table mytable56 (ID counter,name text(8),age single)'单精度型别加长度限制。 SQL数据类型: BINARY N/A—for queries on attached tables that define a BIANRY data type BIT YES/NO BYTE Numeric—Byte COUNTER Counter CURRENCY Currency DATETIME Data/Time SINGLE Numeric—Single DOUBLE Numeric—Double SHORT Numeric—Integer LONG Numeric—Long LONGTEXT Memo LONGBINARY Ole objects TEXT text
SQL数据类型:
BINARY N/A—for queries on attached tables that define a BIANRY data type
BIT YES/NO
BYTE Numeric—Byte
COUNTER Counter
CURRENCY Currency
DATETIME Data/Time
SINGLE Numeric—Single
DOUBLE Numeric—Double
SHORT Numeric—Integer
LONG Numeric—Long
LONGTEXT Memo
LONGBINARY Ole objects
TEXT text
楼上讲了 呵呵 开发文当里面有vb的sql讲座(dao) 可以去看看,不错,一般操作够了