Editing Database with SQL Editor

Questions and Answers about the POS Pizza 6 and newer Database
Post Reply
Chad
Member
Member
Posts: 5
Joined: Sun Jul 14, 2013 12:13 pm

Editing Database with SQL Editor

Post by Chad »

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
User avatar
Scott
Site Admin
Site Admin
Posts: 2564
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Editing Database with SQL Editor

Post by 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
Member
Member
Posts: 5
Joined: Sun Jul 14, 2013 12:13 pm

Re: Editing Database with SQL Editor

Post by Chad »

Scott, where exactly is the database located? Or do I just connect via port?
User avatar
Scott
Site Admin
Site Admin
Posts: 2564
Joined: Wed Apr 16, 2003 5:35 pm
Location: Western PA

Re: Editing Database with SQL Editor

Post by Scott »

Chad wrote: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
Active Member
Active Member
Posts: 56
Joined: Wed Jun 19, 2013 11:47 am

Re: Editing Database with SQL Editor

Post by crwheelr »

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
Post Reply