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.