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