[Gambas-user] Change command

[timothy]

> -----Original Message-----
> From: gambas-user-bounces at lists.sourceforge.net [mailto:gambas-user-
> bounces at lists.sourceforge.net] On Behalf Of Jacky
> Sent: 08 December 2006 14:43
> To: mailing list for gambas users
> Subject: [Gambas-user] Change command
> 
> Hi all
> >  Tab = "Fiches_Parametres" & Soc
> >  Utils.db.Exec("ALTER TABLE " & Tab & " CHANGE (Dnfac Dnfac
Char(6))")
> 
> I have a mysql  error message but i can't see where i am wrong.
> Is anybody can help me ?
> 
> Gambas 1.9.46 under Suse10.1
> 
> Many thank's
> 
> Jack.
> 


There is no need for the () after CHANGE

Utils.db.Exec("ALTER TABLE " & Tab & " CHANGE Dnfac Dnfac Char(6)")


Thanks

8-{)} Timothy Marshal-Nichols
<mailto: timothy.marshal-nichols at ...247...>