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
Editing Database with SQL Editor
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
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.Chad wrote:Scott, where exactly is the database located? Or do I just connect via port?
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