Invalid connection id error

[rleiman]

Hi Everyone,

I'm using Mac OSX for the operating system.

I'm running a stack from lesson number 5 from the LiveCode Academy called "Simple Query Example" and it is giving the following error:

Code: Select all

invalid connection id

The only thing I changed was the specialFolderPath to where the database was as shown in this coding:

Code: Select all

local sDatabaseID

on preopencard
   put empty into field "details"
end preopencard

on connectToDatabase
   local tDatabasePath, tSQLQuery
   
   ## Connect to the database
   ## Save the connection id
   put specialFolderPath("emailaddresses.sqlite") into tDatabasePath
   put revOpenDatabase("sqlite",tDatabasePath,,,,) into sDatabaseID
end connectToDatabase

on displayDetails
   ## Query all details
   ## Put the result into the field
   put "SELECT * from contact_details" into tSQLQuery
   put revDataFromQuery(tab, return, sDatabaseID, tSQLQuery) into field "details"
end displayDetails

Since I'm new to the language, can you tell me what else I need to do to get it working?

I made sure the database was in the same location as the other files for this stack.

Thanks.

[Klaus]

Hi rleiman,

well, "specialfolderpath()" is a function with FIXED parameters, please read up this term in hte dictionary!
You connot supply your own parameter

So your line:
...
put specialFolderPath("emailaddresses.sqlite") into tDatabasePath
..
does not create a valid path and will give an error later.

Where exactly is your database "emailaddresses.sqlite" located?
You need to supply the full path to that db file in your "connection" script!


Best

Klaus

P.S
Welcome to the forum!

[rleiman]

Thanks for the reply.

All files are in the same folder on my Mac.

I'm at work now so I can't tell you the exact path but it's off the main user folder in a folder called iosdevelopment.

If you can tell me how to proceed that will be appreciated.

Thanks.

[Klaus]

Hi rleiman,

so the stack and the db file are in the same folder?
Be sure to read up all terms in capitals in the dictionary!

Then you could do something like this:
...
## 1. get the filename (0 path) to your stack
put the effective filename of this stack into tDatabasePath
## I use the "EFFECTIVE" keywords, since this will also work for substacks, which do not have a FILENAME of their own!
## this will result in something like this on my Mac
## -> /Applications/Revolution Enterprise/cool_stack.livecode

## 2. now set the ITEMDELIMITER to extract the "parent" folder from the name
## pathnames in Livecode always use the UNIX style SLASH as a pathdelimiter!
set itemdel to "/"

## 3. Instead of extracting the "parent" folder, we simply overwrite "cool_stack.livecode" with "emailaddresses.sqlite"
## in the last item of tDatabasePath and voila, the absolute path to your database file
put "emailaddresses.sqlite" into item last item of tDatabasePath
## -> /Applications/Revolution Enterprise/emailaddresses.sqlite
## Now tDatabasePath contains the correct path to your database file, ready to use
...

Best

Klaus

[bangkok]

I think your problem is coming from :

Code: Select all

Local sDatabaseID

You declared it as... a local variable.

And then you use it in several handler.

It can't work.

In your script, at the top of it, put :

Global sDatabaseID

Then the content of sDatabaseID will be available to all your handlers (but be sure to remove all the other local sDatabaseID)

[Klaus]

Yes, but the main problem was: specialFolderPath("emailaddresses.sqlite")

[sturgis]

Its declared as a script local, so all the handlers in that script should be fine with it that way. If other handlers are being called of course, then theres a problem, but my guess is that all the handlers are in the same script.

I think your problem is coming from :

Code: Select all

Local sDatabaseID

You declared it as... a local variable.

And then you use it in several handler.

It can't work.

In your script, at the top of it, put :

Global sDatabaseID

Then the content of sDatabaseID will be available to all your handlers (but be sure to remove all the other local sDatabaseID)

[rleiman]

Thanks everyone for your replies and help.

I have it working now.

I originally thought that specialFolderPath was required for a database path since that was how it was shown in the tutorial. After reading your replies, I stuck in an "answer" statement to see what the actual path specialFolderPath was giving me and it was not where the database was located.

I looked at the properties of where I moved all of the files in finder and found out what the actual path was and included it like this statement:

Code: Select all

put "/Users/emad-ud-deenleiman/Development/iosdevelopment/CBT/ExampleStacks/emailaddresses.sqlite" into tDatabasePath

[Klaus]

OK, but this absolute and hard-coded pathname will only work on your machine, I'm sure you know this!

[rleiman]

Hi,

Yes. I know. It's just for working with the tutorials and I will need to find out later how to do it for development on IOS.