Eye On SQL

I was using Linux a few years ago, but I had so many projects to support and everyone was using windows, I finally had to go back.

Ok -- I blew away helpDesk.db and recreated it.
I used SQLite not ionSQL.. I still have too many problems with ionSQL. Actually ionSQL was an exercise to see how interactive I could make RB. I learned a lot, and after seeing all the possible problems, I really should write it again knowing what I know now.

In SQLite (NOT ionSQL)
* I exported the heplDesk.db into a helpDesk.sql dump
* I created a new helpDesk.db.
* I opened it, and since it has no tables it shows only the db. But in the official SQLite docs you really can'd do much until you have a table. So I created a table called xxx
* clicked the [query] button, and it opened a place to do queries. I pasted the helpDesk.sql dumped file into the query window and executed it. It created all the tables with data.
* I dropped the xxx table.

So it has a new db, and I'm able to use it.

Do you still have the problem with the DB??

Dan

It's 2am here I'll check it out tomorrow
Thanks for taking a look at it

EDIT:

system starts fine now Dan
do you get an error when clicking on either of these buttons
Ticket
Ticket Log
Customer
Translate tables (xlate)

I'm getting


sorry to be a pain

Laurie

PS I have downloaded the new helpDesk.zip and still get the missing table error, but it does exist when I use DB Browser

g'day Laurie!

No problem.. I want to know what's going on as well.

First: when you load the helpDesk DB with ionSQL or SQLite can you see the tables. Can you browse the xlate table?

The first thing the program helpDesk.bas does is open the database and read the xlate file.
Since I'm not using Linux, I keep thinking there is something wrong in the program where I set up the path to the DB.
If you look around line 20, I text Platform$ to see if it windows (if left Platform,3ドル = "win") and set up the path for windows or not windows.
Maybe you can load the program helpDesk.bas into RunBasic and put a couple lines after the path assignment around line 38 to see where it's assigned.
print helpDeskDb$ ' should point to the database
input xxx ' to stop the code
I don't know if DefaultDir$ in linux has the slash "/" after it. If it does then I need to change the helpDeskDb$ assignment.

Thanks for the help..
Dan

Back again
I have a windows version of runbasic and Linux too
So print helpDeskDb$ gives.....

Linux path = /home/laurie/rb101/projects/helpDesk_project/data/helpDesk.db

on Win10 Laptop path = C:\rbp101\projects\helpDesk_project\data\helpDesk.db

I can't see anything wrong there.

I'll keep looking, it doesn't make sense.

Doesn't make sense to me either.

You might want to download the latest SQLite dll. Maybe there are some differences there.

If that all looks good;
Can you open the helpDesk db with ionSQL or SQLite. If so can you see the tables? If you see the tables can you browse the xlate table?
If that all works then load the database used by ionSQL or SQLite to keep track of the tables you used. Browse the table that holds all the databases. That table should have the location of your databases. See if the location looks like the location used with the helpDesk System.

Got to be a answer somewhare?? I hope!

Ok getting somewhere
fixed in ticket.bas

projectDir$ = "helpDesk_project"
if left$(Platform,3ドル) = "win" then
helpDeskDb$ = DefaultDir$ + "\projects\helpDesk_project\data\helpDesk.db"
incdir$ = DefaultDir$ + "\projects\" + projectDir$ + "\"
else
helpDeskDb$ = DefaultDir$ + "/projects/helpDesk_project\data\helpDesk.db"
incdir$ = DefaultDir$ + "/projects/" + projectDir$ + "/"
end if
should read

projectDir$ = "helpDesk_project"
if left$(Platform,3ドル) = "win" then
helpDeskDb$ = DefaultDir$ + "\projects\helpDesk_project\data\helpDesk.db"
incdir$ = DefaultDir$ + "\projects\" + projectDir$ + "\"
else
helpDeskDb$ = DefaultDir$ + "/projects/helpDesk_project/data/helpDesk.db"
incdir$ = DefaultDir$ + "/projects/" + projectDir$ + "/"
end if
same solution for ticketLog.bas and cust.bas

easy when you actually look

OK! I must be getting blind in my old age.
I don't see any difference?
What changed?

you had helpDeskDb$ = DefaultDir$ + "/projects/helpDesk_project\data\helpDesk.db"

should be

forward slash /data/helpdesk.db

think I'll have a coopers pale Ale with cascade hops (home brew on tap) I've just earned it

Duh! Ok.. Is it starting to work?
Only thing I don't understand is why is mine working.
I'm using win/7 so I guess there is a difference in win/10.
I'll have to check all my stuff and I bet I have the same error all over the place.

If you use it, the first thing you might want to do is change the xlate table where the fieldName = 'siteHdr'. That titles it for you. You may want to call it 'Customer Support' or something.

Let me know if you have other problems. Looks like more will pop up with win/10.

Thanks for the help..
Now I owe you a brew.

Dan

Win10 seems to be fine Dan, it did have a problem with the old DB but as far as using
Ticket
Ticket Log
Customer
Translate tables (xlate)
I'M guilty of not testing completly