Hi,
How can I make the code below work? (I would have sworn that this previously worked!). The point is that FILE HANDLES don't work in ODBC connect strings.
So I thought that the next best thing was to define a mini-macro for the database name and a file handle for the directory where the mdb lives. In any case, I only
want to use symbolical names after the file handles/macros have been defined.
file handle tempdir /name="%temp%".
define !database () "myDatabase.mdb" !enddefine.
cd tempdir.
*host commmand = ['cd /d %temp%'].
get data
/type=odbc
/connect='DSN=MS Access Database;DBQ=' + !database + ';DriverId=25;' +
'FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;;QuotedId=Yes'
/sql='SELECT * FROM tblMyTable'
/assumedstrwidth=255.
cache.
execute.
* this is an option, but it's ugly (despite of the fact that it's Python ;-)
begin program.
import spss
filehandles = {item[0]: item[1] for item in spss.GetFileHandles()}
spss.SetMacroValue("!path", "%r" % filehandles["tempdir"])
end program.
define !database () !path + "\myDatabase.mdb" !enddefine.
get data /
.....
Regards,
Albert-Jan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a
fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Locked
