Re: [Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread Charlie Reinl
Am Dienstag, den 04.08.2015, 09:32 -0400 schrieb Martin McGlensey: Charlie, Did as you suggested. Created new form with two datasources and two dataview controls. Copied the relevant code into new form. Same error as with the original form. When the original form was created the code

[Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread Martin McGlensey
Charlie, Did as you suggested. Created new form with two datasources and two dataview controls. Copied the relevant code into new form. Same error as with the original form. When the original form was created the code did work. I think it was back in Gambas 3.6 or so. Maybe it has something to

Re: [Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread Charlie Reinl
Am Dienstag, den 04.08.2015, 16:33 -0400 schrieb Martin McGlensey: Charlie, Thanks for the response. I thought it might be a bug as the routine worked before. I do not think the work around will work as I want it to. My understanding is that a datasource built on a query cannot be

Re: [Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread 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 Form_Test-0.0.1.tar.gz Description: GNU Zip compressed data tblparcel_numbers.sql Description:

Re: [Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread Adrien Prokopowicz
Le Tue, 04 Aug 2015 19:07:36 +0200, Martin McGlensey mmcg29...@frontier.com a écrit: 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 This

Re: [Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread 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

Re: [Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread Charlie Reinl
Am Dienstag, den 04.08.2015, 21:25 +0200 schrieb Adrien Prokopowicz: Le Tue, 04 Aug 2015 19:07:36 +0200, Martin McGlensey mmcg29...@frontier.com a écrit: Charlie, Here is the form and the data table. You will have to recode the connection for the datasources as well as using an

Re: [Gambas-user] Problem with MySQL syntax with DataSource

2015-08-04 Thread Martin McGlensey
Charlie, Thanks for the response. I thought it might be a bug as the routine worked before. I do not think the work around will work as I want it to. My understanding is that a datasource built on a query cannot be edited and updated. I need to change the value of the key based on the user

Re: [Gambas-user] Problem with MySQL syntax with DataSource and DataView

2015-08-03 Thread Martin McGlensey
Some more information. If I create a Result object using the syntax below the SQL query executes properly. Dim sSQL as String = Null Dim hRows as Result = Null sSQL = SELECT tblparcel_numbers.Key FROM tblparcel_numbers WHERE tblparcel_numbers.Key frmEntry.DataControl10.Value hRows =

Re: [Gambas-user] Problem with MySQL syntax with DataSource and DataView

2015-08-02 Thread Adrien Prokopowicz
Le Sun, 02 Aug 2015 22:07:35 +0200, Martin McGlensey mmcg29...@frontier.com a écrit: Hello, I have the code below in my MySQL/Mariadb project. DataSource1.Connection = modMain.$Con DataSource1.Table = tblparcel_numbers DataSource1.Filter =

[Gambas-user] Problem with MySQL syntax with DataSource and DataView

2015-08-02 Thread Martin McGlensey
Hello, I have the code below in my MySQL/Mariadb project. DataSource1.Connection = modMain.$Con DataSource1.Table = tblparcel_numbers DataSource1.Filter = db.Subst(tblparcel_numbers.Key = 1, frmEntry.DataControl10.Value) DataSource1.Sort = Parcel_No