TableName cannot be empty on TMyQuery.Execute
Posted: Thu 21 Jan 2021 16:30
Hi all,
I have a "TableName cannot be empty" with MyDAC 10.3.2 in Delphi 6 and Delphi 7 on a query in our software.
It seems to be caused by a REPLACE of the point character (.) in some cases.
Here is a query as simple as possible that causes me the problem.
A simple table.
The query
If I replace REPLACE(barcode, '.',',') by REPLACE(barcode, 'x',',') there is no error.
If the REPLACE is moved on the first select it works.
Our real request is of course more complex.
How can we fix this error ?
Thank you in advance.
I have a "TableName cannot be empty" with MyDAC 10.3.2 in Delphi 6 and Delphi 7 on a query in our software.
It seems to be caused by a REPLACE of the point character (.) in some cases.
Here is a query as simple as possible that causes me the problem.
A simple table.
Code: Select all
CREATE TABLE "tmp_stock" (
"barcode" char(20) COLLATE latin1_bin DEFAULT '',
KEY "id1" ("barcode")
)
Code: Select all
drop temporary table if exists tmp_tempo2;
create temporary table tmp_tempo2
select barcode
from tmp_stock t1
;
select barcode, REPLACE(barcode, '.',',') as Barcode2
from tmp_tempo2 t2
If the REPLACE is moved on the first select it works.
Code: Select all
drop temporary table if exists tmp_tempo2;
create temporary table tmp_tempo2
select barcode, REPLACE(barcode, 'x',',') as Barcode2
from tmp_stock t1
;
select barcode, Barcode2
from tmp_tempo2 t2
How can we fix this error ?
Thank you in advance.