Editing Database with SQL Editor

Questions and Answers about the POS Pizza 6 & 7 Databases
Member
Posts: 5
Joined: Sun Jul 14, 2013 11:13 am

Editing Database with SQL Editor

Postby Chad » Wed Sep 18, 2013 4:41 pm

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

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Editing Database with SQL Editor

Postby Scott » Wed Sep 18, 2013 5:31 pm

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

Member
Posts: 5
Joined: Sun Jul 14, 2013 11:13 am

Re: Editing Database with SQL Editor

Postby Chad » Thu Sep 19, 2013 6:07 pm

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

Site Admin
User avatar
Posts: 2090
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: Editing Database with SQL Editor

Postby Scott » Fri Sep 20, 2013 7:09 am

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

Active Member
Posts: 39
Joined: Wed Jun 19, 2013 10:47 am

Re: Editing Database with SQL Editor

Postby crwheelr » Thu Sep 26, 2013 4:33 pm

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

Return to Database Help and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest