AirNav RadarBox
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 


Author Topic: Just Switched from SBS-1  (Read 42170 times)

0 Members and 1 Guest are viewing this topic.

nortonbeak

  • Sr. Member
  • ****
  • Posts: 318
  • RadarBox MVT7100 PCR1000 M0NBK
Re: Just Switched from SBS-1
« Reply #45 on: December 20, 2008, 08:30:41 PM »
If you want to try a SQLite editing tool there is a freeware one available at

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

tarbat

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Just Switched from SBS-1
« Reply #46 on: December 20, 2008, 08:40:55 PM »
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

  • Full Member
  • ***
  • Posts: 119
Re: Just Switched from SBS-1
« Reply #47 on: December 21, 2008, 08:15:23 AM »
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

  • Guest
Re: Just Switched from SBS-1
« Reply #48 on: December 21, 2008, 03:47:06 PM »
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

  • Full Member
  • ***
  • Posts: 119
Re: Just Switched from SBS-1
« Reply #49 on: December 21, 2008, 08:05:16 PM »
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

  • ShipTrax Beta Testers
  • Hero Member
  • *
  • Posts: 4219
    • Radarbox at Easter Ross
Re: Just Switched from SBS-1
« Reply #50 on: December 21, 2008, 08:28:42 PM »
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).