Problem with SQLite libraries

[RB Smissaert]

Trying to use AddParameter and SetParameter, but the intellisense on the command object doesn't give me those options, so it looks there is something wrong with the SQLite libraries, but not sure what as I have installed the latest versions of SQLDesktop.dll and SQLDevice.dll.
Not sure where these files should be and also not sure about System.Data.SQLite.DLL should all these file be in the libraries folder or
C:\Program Files\Anywhere Software\Basic4ppc Desktop\Libraries\SQLNative\Desktop\ and
C:\Program Files\Anywhere Software\Basic4ppc Desktop\Libraries\SQLNative\Device\
Should all 3 be added as components to the project?
Thanks for any advice in this.

RBS

 

[Erel]

You also need to make sure that SQLDesktop and SQLDevice files which are located in the folder of your source code are the new ones.

 

[RB Smissaert]

OK, thanks, I got this fixed now.
How about System.Data.SQLite.DLL?
I see that there are 2 files with same version number, but different size and
I can see that there is a newer version out, 1.0.60.0.
Which version should I have and where should the file(s) be?

RBS

 

[Erel]

One is for the desktop and one is for the device.
When you'll compile your application the right one will be copied to the same folder as the executable.

 

[RB Smissaert]

OK, how about the new 1.0.60.0?

RBS

 

[Erel]

It is not possible to just replace those dll files. The ones included with Basic4ppc were modified a little bit. Probably one of the future versions of the SQL library will include newer versions of these dlls.

 

[RB Smissaert]

OK, thanks for clarifying.
Where can I see on what SQLite version those dll files are based?

RBS

 

[Erel]

Version 1.0.40 and SQLite 3.3.12.