Editing Database with SQL Editor
5 posts
• Page 1 of 1
Editing Database with SQL Editor
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
Chad
Re: Editing Database with SQL Editor
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
A good SQL tool is SQLite Expert.
Scott
Re: Editing Database with SQL Editor
Scott, where exactly is the database located? Or do I just connect via port?
Re: Editing Database with SQL Editor
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
Re: Editing Database with SQL Editor
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
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
5 posts
• Page 1 of 1
Return to Database Help and Discussion
Who is online
Users browsing this forum: No registered users and 1 guest