Page 1 of 1
Database query error
Posted: Tue Jan 27, 2015 1:21 pm
by Scoperzor
I'm following this guide: "Scripting Database Access in LiveCode Stacks" on the livecode.byu website.
Trying to connect to an ODBC source (Microsoft SQL).
I have successfully connected and confirmed the connID is a number:
Code: Select all
put revOpenDatabase("ODBC","ETMDataHub","ETMDataHub","x","x") into connID
if connID is null then
answer "Not connected"
else
answer "Connected"
end if
But when I try to do a query I get "invalid connection ID":
Code: Select all
put "select * from tbl_Import_ZA_CPI" into tQuery
put revDataFromQuery(tab,return,connID,tQuery) into tData
put tData into field 'Result'
I have set up the ODBC source in Windows and the test is successful when I try connect to it there.
Re: Database query error
Posted: Tue Jan 27, 2015 1:29 pm
by MaxV
Re: Database query error
Posted: Tue Jan 27, 2015 1:30 pm
by Scoperzor
MaxV wrote:Did you read this: ...
Yes, I have done all of that. Most of my code was taken from that page too.
Re: Database query error
Posted: Tue Jan 27, 2015 1:41 pm
by Klaus
HI Scoperzor,
1. welcome to the forum!
2. did you make sure that connID is either a LOCAL or GLOBAL variable?
Best
Klaus
Re: Database query error
Posted: Tue Jan 27, 2015 2:00 pm
by Scoperzor
Klaus wrote:HI Scoperzor,
1. welcome to the forum!
2. did you make sure that connID is either a LOCAL or GLOBAL variable?
Best
Klaus
Thank you for the welcome. Does it matter if it is local or global? I didn't previously declare it as either, but when trying to now, it still seems to give me the same error. I'm not whether I'm putting it in the correct place - if I declare it once by "global gconnID" in the first part of my script, should it work?
EDIT: All the code is on the same card, should this be necessary?
Re: Database query error
Posted: Tue Jan 27, 2015 2:12 pm
by Klaus
Hi Scoperzor,
global or local is a matter of whre you decalre and use the variables.
But as you said it is everything in the card script then you can declare the variable as local at the top of the compelte script,
so it can be used by all handlers in the script:
Code: Select all
local connID
on opencard
...
end opencard
etc...
Best
Klaus
Re: Database query error
Posted: Tue Jan 27, 2015 2:15 pm
by Scoperzor
Thanks, I actually figured it out just before you replied, your first suggestion together with one other change made it work
