[Gambas-user] Change command

[Pablo Vera]

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


Jacky wrote:
> Bonjour à tous,
> 
> My code.
>  Tab = "Fiches_Parametres" & Soc
>  Utils.db.Exec("ALTER TABLE " & Tab & " CHANGE (Dnfac Dnfac Char(6))")
> 
> It seem that this code is bad because mysql  return an error message ( Not 
> Gambas ) 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.
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user