ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Tue 22 May 2018 20:15

Hello good afternoon
I installed the trial version of the driver "Devart ODBC Driver for xBase" to perform some tests with the .Netcore to read some tables of Visual Fox in the directory C: \ test, below I am putting the code that I am testing with C #.

Code: Select all


           using (var conexao = new OdbcConnection("DSN=MYDSN"))
            {
                conexao.Open();
                using (var comando = conexao.CreateCommand())
                {
                    comando.CommandText = "select * from teste";

                    using (var tabela = comando.ExecuteReader())

When I run the command.ExecuteReader () the error is generated.

ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL


The test table has the following structure
CODIGO N(5)
DESCRICAO C(10)

WITH THE FOLLOWING CONTENT
Codigo = 1
Descricao = “Teste”

Since I'm with the trial version, I only have 20 more days to be able to test and evaluate if we should buy and we'll get what we need

Thank you
Nelson

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by azyk » Wed 23 May 2018 10:23

Please fill the teste table with the test data on which the specified error is reproduced. Then use the contact form at our website https://www.devart.com/company/contactform.html and send us all the files of the teste table ( teste.dbf and index-files teste.* ).

nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Wed 23 May 2018 10:45

Ok thank you very much for the return, I sent the form by the address indicated https://www.devart.com/company/contactform.html in RAR format.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by azyk » Wed 23 May 2018 12:30

Thank you for the information. This error has already been fixed. This hotfix is included in the next version of ODBC Driver for xBase.

nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Wed 23 May 2018 13:57

Many thanks for the feedback, I got the version with the fix and it worked for this bug.
Now another bug with the same scenario is appearing.

ERROR [HY000] [Devart][ODBC][xBase]vtable constructor failed: DBFDIF

Should I open another contact form?

Thank you
Nelson

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by azyk » Thu 24 May 2018 06:48

Please send us all the files of the DBFDIF table (DBFDIF.dbf and index-files DBFDIF.* ).

nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Thu 24 May 2018 11:04

Good Morning,
I will be sending the DBFDIF.dbf file through the form, there is no DBFDIF.CDX file, although I am not using this table in the command.

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by azyk » Fri 25 May 2018 09:15

Thank you for the information. We fixed this bug. This fix is included in the next version of ODBC Driver for xBase.

nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Fri 25 May 2018 11:31

Good Morning,
I installed the version shipped with the above bug fix, but now it has generated another bug.

ERROR [HY000] [Devart][ODBC][xBase]Invalid expression

I am opening another support form with the example.

Image

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by azyk » Fri 25 May 2018 12:34

We tested the attach, but the specified error is not reproduced. The Teste table is opened successfully by our driver. Please make sure that the provided night build is installed on the computer where the error is reproduced.

nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Fri 25 May 2018 20:20

Hello good afternoon
I was able to find the problem, inside the working directory there is another table that I will be attaching in the form.
The table "fpnewlogi.DBF", has an index with the tag with name "NOMEFORM" that has the following expression
PADR(UPPER(ALLTRIM(nomeform)),20," ")

Removing this tag did not generate any more error.

Note: If I am doing a command in a specific table in the "Teste.dbf" case, I do not understand why it reads the file "fpnewlogi.dbf" and I did not call the command.

Thanks,
Nelson

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by azyk » Tue 29 May 2018 08:59

Thank you for the information. We reproduced the specified error. Soon we will add support for the PADR SQL function in our driver.

The driver reads the headers of all *.DBF files in the folder when requesting any table for the first time. When requesting Teste.dbf, the header fpnewlogi.dbf is also read, because both the files are located in the same folder.

nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Tue 29 May 2018 18:48

Good afternoon,
Many thanks for the feedback I understood the operation of the driver.

With your return I did a search of the backup that I have of a client of its production base, that contains 1302 * .DBF files with several types of index.

I found 2 more examples that end up causing problem due to expression.

I'll be attaching to the call form.

ARCHIVE: saralmpt.dbf

The error was generated in the TAG "CHAVE"

Expression: acchcodigo*10000000000+IIF(codcli=-1,1,codcli)*100000+codpos

ARCHIVE: sarflcx.dbf

The error was generated in the TAG "CHAVE"

Expression: PADL (INT (VAL (idsarflcxp)), 10, "0") + PADL (INT (VAL (idsarflcx)), 10, "0")

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by azyk » Wed 30 May 2018 12:11

Thank you for the information. We implemented a number of Foxpro SQL functions including the specified ones. These functions are included in the next version of ODBC Driver for xBase.

nelson.arcas
Posts: 8
Joined: Tue 22 May 2018 19:47

Re: ERROR [HY000] [Devart][ODBC][xBase]Unknown expression FieldName VAL

Post by nelson.arcas » Wed 30 May 2018 16:53

Thank you very much for the feedback, with this last version that was made available, no other errors were generated.

Please close this topic, since all inconsistencies have been corrected.

Thank you for your attention in the calls.
Nelson

Post Reply