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, 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 sele

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 > 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

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

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 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 should be f

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: Bi

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 c

[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 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 hRo

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 a écrit: > 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",

[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" DataV