[Closed] DBF + MDX error
lazarus / 63-Database

----------------------------------------------------------------------
sstvmaster · 2018-05-12 11:29

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

Please help.

Rgr Maik

----------------------------------------------------------------------
bigeno · 2018-05-12 14:05

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 tdbf 1.1 docs, LEFT is unsupported
function. So maybe here is the problem.

----------------------------------------------------------------------
sstvmaster · 2018-05-12 14:20

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?

----------------------------------------------------------------------
bigeno · 2018-05-12 15:09

Quote from: sstvmaster on May 12, 2018, 04:20:11 pmHi,

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.

----------------------------------------------------------------------
sstvmaster · 2018-05-12 15:38

Many thanks.

Thread closed!!

----------------------------------------------------------------------
sstvmaster · 2018-05-14 19:45

Patch applyed to fpc rev 38990 (3.1.1)