PureBasic Forums - English

This code used to work in 3.94:
It now returns the error "Bad parameter type, number expected instead of a string".

Anyone?

You are using somebody's wrapper for Sqlite (a third party lib, not pb commands) and PB's syntax has changed a bit between versions so you have to find out who wrote the wrapper and ask them to fix it.

Personally, I never use wrappers because this is what happens and you have no control over it. El_Choni made a warapper but he also wrote some code to directly access the sqlite dll so that we don't have this problem and I am using his code without change on all pb versions.

You might want to see if he, Kiffi or Num3 did the wrapper (More likely Kiffi) and check PureAre.net for an update.

You are using somebody's wrapper for Sqlite (a third party lib, not pb commands) and PB's syntax has changed a bit between versions

This is not a syntactical error, but it is El Choni's SQLite interface code. Which El Choni code are you using without modification? Would you mind sharing some examples?

change this to this: Not tested, but should work

That fixed it! Thanks!

Can someone point me to where I could download El_Choni's SQLite3 wrapper?

I don't think such a thing exists.

How would u know!

El_Choni wrote:I don't think such a thing exists.

I guess you would know! I thought I read you'd written a wrapper but I guess that was just for the previous version of SQLite... thanks anyways.

I read somewhere that there's a wrapper for Sqlite3 done by Kiffi, but I'm not sure. Mine is for Sqlite2, that's sure.

For Kiffi's wrapper, visit purearea.net. He made a wrapper for SQLite3.x and he also contributed it to the PBOSL project.

El_Choni, you are a dead set legend. I am still using your wrapperless code. Works a treat on everything and never breaks between compiler versions. Much betetr than a wrapper (shudders)

Fangbeast wrote:...El_Choni, you are a dead set legend. I am still using your wrapperless code. Works a treat on everything and never breaks between compiler versions. Much betetr than a wrapper (shudders)

El_Choni, how about a version then for SQLite3??? Please???

I suggest that you try Kiffi's' wrapper first... No need to reinvent the wheel. Fangles refers to some code I wrote for sqlite3 without wrappers, using the sqlite functions directly.

El_Choni wrote:I suggest that you try Kiffi's' wrapper first... No need to reinvent the wheel. Fangles refers to some code I wrote for sqlite3 without wrappers, using the sqlite functions directly.

You mean "sqlite2", right?

El_Choni wrote:I don't think such a thing exists.

dmoc wrote:How would u know!