How to use variables?

[9LUCAS]

Hi.

I'm using a function to add information to an Access database. I want to add information from a variable that I have declared previously.

When I open the file access. In the modified fields just appears "$campo", rather than the content of the variable ("campotest").

The function is:

$FULL_MDB_FILE_NAME = @ScriptDir & "\MyDatabase.accdb"
$SQL_CODE = "select * from Table_1"
$CONN = ObjCreate("ADODB.Connection")
$CONN.Open('Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=' & $FULL_MDB_FILE_NAME & ';')
$RecordSet = ObjCreate("ADODB.Recordset")
$CONN.Execute("INSERT into Table_1 (Name, Campo1) values ('$campo', '45326')")
$CONN.Close

I declared the variables as follows:

Global $campo = "campotest"

I am declaring the variables correctly? Is there any error in function?
Thanks in advance.

PS: sorry for my English.

[Bowmore]

This line 

$CONN.Execute("INSERT into Table_1 (Name, Campo1) values ('$campo', '45326')")

should be

$CONN.Execute("INSERT into Table_1 (Name, Campo1) values ('" & $campo & "', '45326')")

 

[9LUCAS]

2 minutes ago, Bowmore said:

This line 

$CONN.Execute("INSERT into Table_1 (Name, Campo1) values ('$campo', '45326')")

should be

$CONN.Execute("INSERT into Table_1 (Name, Campo1) values ('" & $campo & "', '45326')")

 

Thanks. Solved!