Ray67

Undeclared global variable

4 posts in this topic

#1 ·  Posted

Hello,

I'm very new to autoit. Still trying to learn it.  I'm get undeclared global variable in the following script


;Declare error handler
Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")

;Declaration variables for SQL Connection
Local $ServerAddress = ""
Local $ServerUserName = ""
Local $ServerPassword = ""
Local $DatabaseName = ""

$constrim="DRIVER={SQL Server};SERVER="&$ServerAddress&";DATABASE="&$DatabaseName&";uid="&$ServerUserName&";pwd="&$ServerPassword&";"
$adCN = ObjCreate ("ADODB.Connection") ;<==Create SQL connection

;MsgBox(0,"",$constrim )
if @error Then
  MsgBox(0, "ERROR", "Failed to connect to the database")
  Exit
Else
  MsgBox(0, "Success!", "Connection to database successful!")
EndIf

$sQuery= "Select * from EftProv, Amt WHERE LName = 'A'"

$result= $dbCon.Execute($sQuery) (undeclared global variable error)
MsgBox(0,"MD Found:",$result.Fields( "ID" ).Value )
$adCN.Close ;==>Close the database

Thank you

Share this post


Link to post
Share on other sites



#2 ·  Posted

It's most likely related to $dbCon, I don't see it initialized anywhere in the snippet you posted

Share this post


Link to post
Share on other sites

#3 ·  Posted

$dbCon isn't declared anywhere in your script.


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

#4 ·  Posted

18 hours ago, BrewManNH said:

$dbCon isn't declared anywhere in your script.

Thanks for your help.

I think I fixed variable issues. 

Now I have another issues. It's connecting to the sql sever but it's not returning any value.


;Declare error handler
Local $oErrorHandler = ObjEvent("AutoIt.Error", "_ErrFunc")

;Declaration variables for SQL Connection
Local $ServerAddress = ""
Local $ServerUserName = ""
Local $ServerPassword = ""
Local $DatabaseName = ""

$constrim="DRIVER={SQL Server};SERVER="&$ServerAddress&";DATABASE="&$DatabaseName&";uid="&$ServerUserName&";pwd="&$ServerPassword&";"
$adCN = ObjCreate ("ADODB.Connection") ;<==Create SQL connection

 

 

;MsgBox(0,"",$constrim )
if @error Then
  MsgBox(0, "ERROR", "Failed to connect to the database")
  Exit
Else
  MsgBox(0, "Success!", "Connection to database successful!")
EndIf

$sQuery= "Select * from EftPr, Amt WHERE LName = 'AD'"

$result= $adCN.Execute($sQuery)
MsgBox(0,"MD Found:",$result.Fields( "LName" ).Value )
$adCN.Close ;==>Close the database

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now