[Gambas-user] Change command

[Pablo Vera]

According to MySQL documentation, none of these instructions use 
parenthesis, which means that in some cases it might work and in some 
others, not.  I've never used parenthesis and this statements have 
always worked for me.

Pablo

Jacky wrote:
>> 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)")
> 
> Excuse me. After some tests we can't use parenthesis with ADD but we must use 
> them with CHANGE.
> 
> 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
>