Editing Database with SQL Editor

[Chad Profile]

Is there anyway I can see all the tables and everything affiliated with POS Pizza with a SQL Editor? I can't seem to add a time-clock entry before the first time-clock entry was entered.. so I need to do so in the database.

Chad

[Scott]

Yes, it can be done with any SQLite tool. Be careful not to get the clock/in clock/out sequence out of whack or you will break it.

A good SQL tool is SQLite Expert.

Scott

[Chad Profile]

Scott, where exactly is the database located? Or do I just connect via port?

[Scott]

Scott, where exactly is the database located? Or do I just connect via port?

For LT, and SA the database is located in the program folder. For CS it is located in the server folder. The default database name is pospizza.PZ6, all of the databases would end in the .PZ6 extension.


Scott

[crwheelr Profile]

Chad,

I have been using Razor SQL for table viewing and editing. have to be super careful though not to disrupt record ID's etc for correct indexing though.

chuck