[Gambas-user] Change command

[Jacky]

Le Vendredi 15 Décembre 2006 15:41, Pablo Vera a écrit :
> I think you have an extra pair of parenthesis and maybe you need to
> quote the table name, something like this:
>
>    Utils.db.Exec("ALTER TABLE `" & Tab & "` CHANGE Dnfac Dnfac Char(6)")
>
> What error is MySQL returning ?
>
> Pablo

Salut Pablo
Without quote your syntax is right.
The syntax is : 
Utils.db.Exec("ALTER TABLE " & Tab & " CHANGE Dnfac Dnfac Char(6)")

Yet it is strange because with ADD we can use bracket. 
  Utils.db.Exec("ALTER TABLE " & Tab & " ADD (Num2 INTEGER(6) ,Num3 
INTEGER(6))")
but we can also not use them.
  Utils.db.Exec("ALTER TABLE " & Tab & " ADD Num2 INTEGER(6) ,Num3 
INTEGER(6)")

Thank you very much !
Good week end

Jack.