Just Switched from SBS-1

[nortonbeak]

If you want to try a SQLite editing tool there is a freeware one available at

http://sourceforge.net/projects/sqlitebrowser/

[tarbat]

Yes, sqlite browser is very useful for viewing/updating databases.  You will need to be able to write SQL statements to get the most from it.  See http://www.sqlite.org/ for documentation on SQLite.

The feature I use most in SQLite Maestro is the Visual Query Builder, which generates SQL statements for you based on a visual representation of the tables and their relationships.  I've never written a single line of SQL myself, it's all been done with the Visual Query Builder!!

[9M-ISJ]

Hi,

I have downloaded SQLite Maestro, and it seems to have a 30 full usage trial.

We shall see how we go!

Thanks to all.... expect further questions soon! :-)

[abrad41]

Hi 9M-ISJ

tarbat is the expert with SQLite Maestro, but there is a few of us who use it, so just ask, if we can help we will.

After my 30 day trial I made the purchase, at the time (Just over a month ago) it worked out to £69.90 - might be different now due to the exchange rate - but would not be without it now.

Cheers

Andy

[9M-ISJ]

Hi,

Had a quick toy with it this morning,,, managed to produce the query to show all aircraft with the ... or null type following Tarbats example.

Generally struggling with the other query to import my Basestation data though. In the screen dump Tarbat sent me it seems the two tables are linked... not sure how to do that!

[tarbat]

Put both tables into the query builder, then just drag a line from the AircraftID field on one table to the Aircraft ID field on the other table (I think).