insert a float (SQL 7.0)

hi,

This may be a dumb question, but i have the following problem:

i have a table with 5 fields. When i do the following: insert into table1 values('String','string',99,99,'string', 'string') i get the error saying that i have to much values. This because he counts the 99,99 for two. How to fix this??

Thanx

Assign 99,99 to var and insert this var

dim MyValue as double

SQL = "insert into table1 values('String','string'," & MyValue & ",'string', 'string')"

Iouri Boutchkine
[email protected]