SQLite version - 2x or 3x

[sferguson]

Hi Gang,

What version of SQLite is built into AMS 7? We've got some older apps built in AMS 5 with the SQLite plugin - which is SQLite 2x. We need to some of the benefits of SQLite 3x and I'm wondering if that's the version in AMS 7. If so, will a simple recompile of the AMS 5 source come out of AMS 7 with the newer SQLite version?

Thx

[Dermot]

AMS 7 still use SQLite 2.8 the same as AMS 5 did.

[sferguson]

Thanks for the quick response!

[TJ_Tigger]

hopefully we will see version 3 appear in AMS 7 in the near future.

[sferguson]

Yeah - that'd be super-duper! There's a lot of handy things to take advantage of in 3x.

[sferguson]

Of course... a SQL Express plug would be FANTASTIC ; -) I'd pay mucho dinero for that add-on. I know there are some work-arounds, but good greif - can you imagine how that would open things up. Sweet! There's tons of apps I deal with that are already standard SQL - so I don't have the option to roll my own in most cases.

[bule]

AMS 7 still use SQLite 2.8 the same as AMS 5 did.

Are you sure?
When I open up a newly created database in Notepad, it says 2.1.

[Dermot]

Are you sure?
When I open up a newly created database in Notepad, it says 2.1.

Well using the AMS action SQLite.GetVersion() returns 2.8.6