如何将edit框里输入的实数（如1112.52）插入到oracle 数据库类型为number的字段中？(20分)

J

johnnywong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-02

• #1

如何将edit框里输入的实数（如1112.52）插入到oracle 数据库类型为number的字段中？

 

X

xianguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-02

• #2

'insert into table(field)values(' + edit1.text +')';

 

J

johnnywong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-02

• #3

为何我使用 adoquery.sql.add('select * from tab where lc='''+edit1.text+'''');
却不能查到需要的值？

lc字段为number类型

 

X

xianguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-02

• #4

adoquery.sql.add('select * from tab where lc='+edit1.text);

 

Y

yang_9999_520

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-02

• #5

adoquery.sql.add('select * from tab where lc='+''''+strtofloat(edit1.text)+'''');