🚀 go-pugleaf

SQLDataSet1->Params->Items[0]->Value = 1;

OR

SQLDataSet1->Params->Items[0]->AsBCD = 1;


"Changsong Bu" <changsong.bu@ps.ge.com> wrote in message
news:4083d7d1$1@newsgroups.borland.com...
>
> I'm a newbie here frustrated with a puzzled (and simple) problem.
> I use Oracle 8.1.7. My table "TestPro" has 10 fields
> a, b, c, d, e, f, g, h, i, j. All integers.
> I was trying to insert a record to the table using TSQLDataSet.
> (tried TSQLQuery too, with the same error).
> Following is my codes:
> --------------------------------------------
>      SQLDataSet1->CommandType = ctQuery;
>     SQLDataSet1->CommandText = "INsert into testPro (a, b, c, d, e, f, g,
h, i, j) VAlues (:a, :b, :c, :d, :e, :f, :g, :h, :i, :j)";
>        SQLDataSet1->Params->Items[0]->AsInteger = 1;
>        SQLDataSet1->Params->Items[1]->AsInteger = 2;
>         SQLDataSet1->Params->Items[2]->AsInteger = 3;
>         SQLDataSet1->Params->Items[3]->AsInteger = 4;
>         SQLDataSet1->Params->Items[4]->AsInteger = 5;
>         SQLDataSet1->Params->Items[5]->AsInteger = 6;
>         SQLDataSet1->Params->Items[6]->AsInteger = 7;
>         SQLDataSet1->Params->Items[7]->AsInteger = 8;
>         SQLDataSet1->Params->Items[8]->AsInteger = 9;
>         SQLDataSet1->Params->Items[9]->AsInteger = 10;
>
>         SQLDataSet1->ExecSQL();
> --------------------------------------------
> I got the 'DBX Error: invalid Field Type' error.
>
> Supprisingly, when changed from "AsInteger " to "AsString" when assigning
the parameter, the query works. But the fields in the table ARE all integer
type.
>
> Anybody can help me with it, please? Thank you very much.
>
> Changsong