Lazarus
Free Pascal => Database => Topic started by: sstvmaster on May 12, 2018, 01:29:16 pm
-
Hi,
i want to read a DBF file. Without mdx it reads the DBF. With mdx i get the error:
Index based on unknown field "LEFT"
The DBF is from Fritz!Fax, the mdx is generated automatically by FritzFax.
The Test project: https://ufile.io/s0vbm (http://ttps://ufile.io/s0vbm)
Please help.
Rgr Maik
-
Your index T_DATEI have expression UPPER(LEFT(DATEI,100))
According http://wiki.lazarus.freepascal.org/Lazarus_Tdbf_Tutorial#How_to_add_indexes_to_a_table (http://wiki.lazarus.freepascal.org/Lazarus_Tdbf_Tutorial#How_to_add_indexes_to_a_table) tdbf 1.1 docs, LEFT is unsupported function. So maybe here is the problem.
-
Hi,
thanks. And where i can add this function in which file?
In C:\fpcupdeluxe\fpcsrc\packages\fcl-db\src\dbase there are many files, where?
-
Hi,
thanks. And where i can add this function in which file?
In C:\fpcupdeluxe\fpcsrc\packages\fcl-db\src\dbase there are many files, where?
Expression functions are defined in dbf_prscore.pas but idk if this is enough.
-
Many thanks.
Thread closed!!
-
Patch applyed to fpc rev 38990 (3.1.1)