Page 1 of 1

SQLite "Field 'NULLABLE' not found" Error

Posted: Wed 30 May 2012 22:06
by jbmiller
Hi,
I am working on creating a multi-tier solution where the server can reside on any platform, specifically windows and mac. I have a small test database where I am fetching a group of records and I'm able to update a record too. Everything works great on windows but when I run it on the mac, I get the "Field 'NULLABLE' not found" error.

There are no persistent fields but I am selecting all fields with one parameter in my where clause. I get the error when I make the query active.

I only have the trial version to prove that it can work so I am unable to trace the error back into the source. Any help is appreciated.

Regards,
Bill

Re: SQLite "Field 'NULLABLE' not found" Error

Posted: Mon 04 Jun 2012 09:59
by AlexP
hello,

For the following platforms: Linux, FreeBSD, Mac OSX and Windows x64, in the trial versions, there is a restriction for the number of fields in DataSet (max is 6).

Re: SQLite "Field 'NULLABLE' not found" Error

Posted: Fri 08 Jun 2012 03:23
by eddy2099
I am testing the x64 built with a 1 table with 2 fields and 3 records and I get the "Field 'Nullable' Not Found' error. However, I was able to get the Server Version Number which reflects the SQLite3 version. I take it that the connection to the x64 sqlite3.dll works, it is just that the trial version is preventing me from doing any query or table access in 64 bits. Is that correct ?

Thanks.

Re: SQLite "Field 'NULLABLE' not found" Error

Posted: Fri 08 Jun 2012 13:42
by ZEuS
Hello.

We've reproduced the problem.
The problem is due to the trial restriction for the number of fields in the dataset in Windows x64. When trying to open, the dataset can not correctly retrieve the table metadata and raises the error.
We will fix this problem with Trial version in the nearest UniDAC build.
Presently, you can either buy a licensed version of UniDAC, or develop and test your application in Windows x32.