Database query error

[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.

[MaxV]

Did you read this: http://lessons.runrev.com/m/4071/l/4965 ... using-odbc ?

[Scoperzor]

Did you read this: ...

Yes, I have done all of that. Most of my code was taken from that page too.

[Klaus]

HI Scoperzor,

1. welcome to the forum!
2. did you make sure that connID is either a LOCAL or GLOBAL variable?


Best

Klaus

[Scoperzor]

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?

[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

[Scoperzor]

Thanks, I actually figured it out just before you replied, your first suggestion together with one other change made it work