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

Re: [Gambas-user] problem with mysql

2009-05-07 Thread Benoît Minisini
> Hi everyone, > > I'm running Kubuntu 9.04 (Jaunty) on an Intel P4 3GHz (i386) with 1GB > of RAM. I have tried the packaged Gambas2, and have also compiled the > latest from source following the instructions on the website. > > I am getting the following error: > > Cannot find driver for database:

[Gambas-user] problem with mysql

2009-05-07 Thread Adam Camp
Hi everyone, I'm running Kubuntu 9.04 (Jaunty) on an Intel P4 3GHz (i386) with 1GB of RAM. I have tried the packaged Gambas2, and have also compiled the latest from source following the instructions on the website. I am getting the following error: Cannot find driver for database: MySQL. H

[Gambas-user] Problem with MySQL LONGTEXT field type (Null data)

2009-01-03 Thread Luigi Carlotto
I have changed the heading of the mail, because I have noticed that sometimes it does not come received from the mailing list. In any case, this continuous speech approximately the problem of the fields “longtext” in MySQL. ... I have executed of the tests, to line of commando from Linux, in orde

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2009-01-02 Thread werner 007
Ciao Luigi I believe it comes from permissions. Try this: Give all permissions to user Test for schema mysql and schema Test. That should work. Regards, Werner >From the mySQL Help: There are two sets of permissions for stored functions, 1. permissions to create and manage stored function

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2009-01-02 Thread Luigi Carlotto
Il giorno ven, 02/01/2009 alle 12.27 +0100, Luigi Carlotto ha scritto: > Il giorno lun, 22/12/2008 alle 21.41 +0100, Luigi Carlotto ha scritto: > > > Il giorno lun, 22/12/2008 alle 20.51 +0100, Luigi Carlotto ha > > scritto: > > > > > Il giorno lun, 22/12/2008 alle 20.13 +0100, Luigi Carlotto ha

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2009-01-02 Thread Luigi Carlotto
Il giorno lun, 22/12/2008 alle 21.41 +0100, Luigi Carlotto ha scritto: > Il giorno lun, 22/12/2008 alle 20.51 +0100, Luigi Carlotto ha scritto: > > > Il giorno lun, 22/12/2008 alle 20.13 +0100, Luigi Carlotto ha > > scritto: > > > > > It pardons me, but the table in object is not part of mine >

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-22 Thread Luigi Carlotto
Il giorno lun, 22/12/2008 alle 20.51 +0100, Luigi Carlotto ha scritto: > Il giorno lun, 22/12/2008 alle 20.13 +0100, Luigi Carlotto ha scritto: > > > It pardons me, but the table in object is not part of mine database, > > but of the same motor of MySQL. > > The fact that is complete with the dat

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-22 Thread Benoit Minisini
On lundi 22 décembre 2008, Luigi Carlotto wrote: > Il giorno lun, 22/12/2008 alle 20.13 +0100, Luigi Carlotto ha scritto: > > It pardons me, but the table in object is not part of mine database, > > but of the same motor of MySQL. > > The fact that is complete with the data, or without data, is not

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-22 Thread Luigi Carlotto
Il giorno lun, 22/12/2008 alle 20.13 +0100, Luigi Carlotto ha scritto: > It pardons me, but the table in object is not part of mine database, > but of the same motor of MySQL. > The fact that is complete with the data, or without data, is not the > true problem. > My function reads the content of

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-22 Thread Benoit Minisini
On lundi 22 décembre 2008, Luigi Carlotto wrote: > It pardons me, but the table in object is not part of mine database, but > of the same motor of MySQL. > The fact that is complete with the data, or without data, is not the > true problem. > My function reads the content of this table in order to

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-22 Thread Luigi Carlotto
It pardons me, but the table in object is not part of mine database, but of the same motor of MySQL. The fact that is complete with the data, or without data, is not the true problem. My function reads the content of this table in order to determine the structure of a database, and not the data. Th

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-21 Thread Benoit Minisini
On dimanche 21 décembre 2008, Luigi Carlotto wrote: > In reality, in my application, use the logons only for operations of > reading of the information of the structure of the database, since the > application is a program for the design of database (es. ErWIN, Oracle > Designer, etc). > > The quer

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-21 Thread Luigi Carlotto
In reality, in my application, use the logons only for operations of reading of the information of the structure of the database, since the application is a program for the design of database (es. ErWIN, Oracle Designer, etc). The query they come executed on the system tables, like in the followin

Re: [Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-20 Thread Benoit Minisini
On dimanche 14 décembre 2008, Luigi Carlotto wrote: > Gambas2 - versione 2.9.0 > > The single anomaly verification in a circumstance, that I will try to > describe: > > - I have created a small static class that executes the logon to a > database, executes query and returns the data in a structure

[Gambas-user] Problem with MySQL LONGTEXT field type

2008-12-14 Thread Luigi Carlotto
Gambas2 - versione 2.9.0 The single anomaly verification in a circumstance, that I will try to describe: - I have created a small static class that executes the logon to a database, executes query and returns the data in a structure much similar one to the logic applied to the Result/Field object