SQLite vs Access query differences

[fla]

I've found database queries in XRecord suite that use syntax like:

select top 10 * from ...

SQLite seems to want this syntax:

select * from ... limit 10

Is there a syntax to accomplish this that can work for both SQLite and Access? If not, from within a plugin how can I ask gbpvr which database is currently in use? That way I can use the correct syntax for the current database.

[sub]

I've found database queries in XRecord suite that use syntax like:

select top 10 * from ...

SQLite seems to want this syntax:

select * from ... limit 10

Is there a syntax to accomplish this that can work for both SQLite and Access?

No, I dont think there is. I've luckily managed to avoid having to deal with that difference.

These types of difference are a pain in the butt.

If not, from within a plugin how can I ask gbpvr which database is currently in use? That way I can use the correct syntax for the current database.

You can call DatabaseHelperFactory.getDbProviderFactory().getDbConnectionString() and examine that to determine what database is in use.

[fla]

Thanks. I put in different syntax for Access and SQLite.

Strange thing. I found that there was already code in XGuide looking at the config.xml's DatabaseConnectionString and searching for "jet". This check works fine to distinguish between Access and SQLite but I wonder why XGuide already had this method since the initial load way before gb-pvr supported SQLite?

[sub]

Some poeple have used other databases like SQLServer etc, pretty much forever.

[psycik]

hey sub, while on the subject, have you found differences in parameter processing in mdb and sqllite? Found I had to drop Parameter.Add from MDB because it just wasn't finding anything but now it looks like I need it again for SQL-Lite (to handle quotes on works). You ever seen anything like that?

[sub]

hey sub, while on the subject, have you found differences in parameter processing in mdb and sqllite? Found I had to drop Parameter.Add from MDB because it just wasn't finding anything but now it looks like I need it again for SQL-Lite (to handle quotes on works). You ever seen anything like that?

No, I've found them very consistent.

I use Parameters.Add in lots of places.

[psycik]

No, I've found them very consistent.

I use Parameters.Add in lots of places.

hmm, must have been something I was doing....might have to revisit it.