🚀 go-pugleaf

Remove last "," before ")" - in QueryStation->SQL->Add("
Cust_Group_Comments Text,");

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Ola Eriksen" <ola@callcom.no> ???????/???????? ? ???????? ?????????:
news:3D491BBA.489C88F5@callcom.no...
> Hi there!
>
> I'm using C++ Builder 5 and a Access database.
>
> I'm trying to create a table with this code:
>
>       QueryStation->SQL->Add("Create Table Cust_Groups ");
>       QueryStation->SQL->Add("(");
>       QueryStation->SQL->Add("  Cust_Group_ID Int Identity Primary
> key,");
>       QueryStation->SQL->Add("  Cust_Group_Name VarChar(30) Unique Not
> null,");
>       QueryStation->SQL->Add("  Cust_Group_Comments Text,");
>       QueryStation->SQL->Add(")");
>       QueryStation->ExecSQL();
>
> ...but I resive an exception error "Syntax error in field definition"
> What's wrong with my field definition?
>
> I've managed to create the table without any fields... (just:   CREATE
> TABLE Cust_Groups)
>
> Thank's in advance
>
> Ola
>