Le Sun, 02 Aug 2015 22:07:35 +0200, Martin McGlensey
<mmcg29440 at ...3163...> 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",
> frmEntry.DataControl10.Value)
>> DataSource1.Sort = "Parcel_No"
>> DataView1.View.Columns.Width = -1
>>> DataSource2.Connection = modMain.$Con
>> DataSource2.Table = "tblparcel_numbers"
>> DataSource2.Filter = db.Subst("tblparcel_numbers.Key != &1",
> frmEntry.DataControl10.Value)
>> DataSource2.Sort = "Parcel_No"
>> DataView2.View.Columns.Width = -1
>>> Coding for DataSource1 works as expected. Returning records with a key
> equal
> to the contents of the data control.
>>> Coding for DataSource2 Fails. The error message is "DataTable load until,
> 134: Query failed, You have an error in your SQL syntax".
>>> The DataView2 shows some record numbers but nothing else. If you scroll
> down you see the error message about a failure at a specific
> record. I've looked at the data and it appears to be OK. <,>,= all work
> but
> != or <> do not. All I get is a circular cursor indicating processing is
> occurring but it looks like an endless loop. I want to load all records
> in
> which the key is not equal to the datacontrol. What have I missed?
>>> Using Gambas 3.8 with MySQL/MariaDB as the database.
>>> Thanks,
>> Marty
>
Can you provide a little test project, with the structure of your
database ?
Regards,
--
Adrien Prokopowicz