Sql Insert Into

[kizildag]

Hi,

i m trying to insert datas into a table with SQL.

TQuery *InsertQuery;
InsertQuery= new TQuery (this);

InsertQuery->DatabaseName = "TEMP";
InsertQuery->SQL->Add ("INSERT INTO [dbo].["+tname+"] (openvalue,closevalue,high,low,average) VALUES ("+FloatToStr(open)+","+FloatToStr(close)+","+FloatToStr(highestarr,ffFixed,18,8)+","+FloatToStr(lowest)+","+FloatToStr(average)+")");
InsertQuery->ExecSQL();

Number of columns and their data types are same but it gives error message ( there are fewer columns in the INSERT statement than values specified in the VALUES clause )

please help me




there are fewer columns in the INSERT statement than values specified in the VALUES clause

[olivthill]

Maybe, in your system, the decimal point is a comma, and you'll get things like
...VALUES (100, 200, 300, 400, 500, 3,14)
instead of
...VALUES (100, 200, 300, 400, 500, 3.14)

[Siddhartha]

[ redirected ]

Regards,
Siddhartha