前后台数据对应问题,谢谢(50分)

  • 主题发起人 主题发起人 风子
  • 开始时间 开始时间

风子

Unregistered / Unconfirmed
GUEST, unregistred user!
后台sql7数据timu和anwser是varchar;
前台 with query do
close;
sql.clear;
sql.add('update tiku');
sql.add('insert into tiku(kmfl,tx,ndxs,fenzi,timu,answer)');
sql.add('values(:kmfl,:tx,:ndxs,:fenzi,:timu,:anwser)');
...................................
...................................
parameters.parambyname('timu').value:=memoTimu.Text;
parameters.parambyname('anwser').value:=memoAnswer.text;
其中query的parameter属性中timu和anwser的类型应是?
 
ftUnknown Unknown or undetermined
ftString Character or string field
ftSmallint 16-bit integer field
ftInteger 32-bit integer field
ftWord 16-bit unsigned integer field
ftBoolean Boolean field
ftFloat Floating-point numeric field
ftCurrency Money field
ftBCD Binary-Coded Decimal field
ftDate Date field
ftTime Time field
ftDateTime Date and time field
ftBytes Fixed number of bytes (binary storage)
ftVarBytes Variable number of bytes (binary storage)

ftAutoInc Auto-incrementing 32-bit integer counter field
ftBlob Binary Large OBject field
ftMemo Text memo field
ftGraphic Bitmap field
ftFmtMemo Formatted text memo field
ftParadoxOle Paradox OLE field
ftDBaseOle dBASE OLE field
ftTypedBinary Typed binary field
ftCursor Output cursor from an Oracle stored procedure (TParam only)
ftFixedChar Fixed character field
ftWideString Wide string field
ftLargeInt Large integer field
ftADT Abstract Data Type field

ftArray Array field
ftReference REF field
ftDataSet DataSet field
ftOraBlob BLOB fields in Oracle 8 tables
ftOraClob CLOB fields in Oracle 8 tables
ftVariant Data of unknown or undetermined type
ftInterface References to interfaces (IUnknown)
ftIDispatch References to IDispatch interfaces
ftGuid globally unique identifier (GUID) values
 
多人接受答案了。
 
后退
顶部