SQLite Browser

[RizlaUK]

has anyone got a copy of sqlite database browser thats compatable with AMS databases.

i know 10 mins on google will find it but sure someone can save me the time :yes

[RizlaUK]

nm, i got it (v1.1)

http://sourceforge.net/project/showfiles.php?group_id=87946&package_id=91778

[HMMurdock]

V1.1 and V1.01 have two different feature sets. You'll probably want to get a copy of both.

V1.01 can modify database Pragma options.

[RizlaUK]

i wouldent modify a AMS database with sqlite browser, im sure i read somewhere that once saved it removes the auto increment from the primary key feilds, i remember a discussion about it here at the forums.

[HMMurdock]

If I remember correctly, that applies to altering table structure.

[RizlaUK]

im not sure, but i would check if planing on editing a database with sqlite browser just to be on the safe side.

i found this great app for sqlite database managment

SQL Maestro for SQLite (http://www.sqlmaestro.com/products/sqlite/maestro/)

[HMMurdock]

I haven't modified any table structures with SQLite Browser, and thus far I haven't had any problems with AutoIncriment fields.