[Gambas-user] Problem with MySQL syntax with DataSource

[Charlie Reinl]

Am Dienstag, den 04.08.2015, 13:07 -0400 schrieb Martin McGlensey:
> Charlie,
> 
>  
> 
> Here is the form and the data table. You will have to recode the connection
> for the datasources as well as using an integer (1-200) for
> frmEntry.DataControl.Value.
> 
>  
> 
> Regards,
> 
> Marty
> 

Salut Marty,

bad news, you hit a FIXED Limit of 256, thats a BUG.

But the good news are there is a workaround I think. Use

DataSource2.Table = "Select * from tblparcel_numbers" ' like this it
works

I attached my changed project and your SQL, in the hope Adrian is still
online (and not yet in holidays), I'v not the time actually to correct
that bug.


-- 
Amicalement
Charlie
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Form_Test-0.0.2.tar.gz
Type: application/x-compressed-tar
Size: 4802 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20150804/585839f4/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tblparcel_numbers.sql
Type: text/x-sql
Size: 25890 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20150804/585839f4/attachment-0001.bin>