LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2003)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 23 Jul 2003 10:09:12 +0300
Reply-To:     MLiberts@csb.gov.lv
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         MLiberts@csb.gov.lv
Subject:      Path defined by macro
Content-type: text/plain; charset=us-ascii

Hi listers,

I have defined the path to files with macro:

define !cels() "C:\My Documents\Darbs\Imputation\new\2-darbs\Exports" !enddefine.

I want to use this macro in Get Capture ODBC query:

GET CAPTURE ODBC /CONNECT= "DSN=MS Access Database;"+ "DBQ="+!cels+"\2002C4\2-darbs_02C4.mdb;"+ "DefaultDir="+!cels+"\2002C4;"+ "DriverId=25;"+ "FIL=MS Access;"+ "MaxBufferSize=2048;"+ "PageTimeout=5;" /SELECT "T3"."uuk"AS "uuk", "T3"."rnr"AS "rnr", "T3"."cnr"AS "cnr", "T3"."code"AS "code", "T3"."mark"AS "mark", "T3"."cvalue"AS "cvalue" FROM !cels+"\2002C4\2-darbs_02C4"."values" "T3".

But this query is not working. Actualy the problem is in FROM statement. If I put real path in FROM statement, it works:

GET CAPTURE ODBC /CONNECT= "DSN=MS Access Database;"+ "DBQ="+!cels+"\2002C4\2-darbs_02C4.mdb;"+ "DefaultDir="+!cels+"\2002C4;"+ "DriverId=25;"+ "FIL=MS Access;"+ "MaxBufferSize=2048;"+ "PageTimeout=5;" /SELECT "T3"."uuk"AS "uuk", "T3"."rnr"AS "rnr", "T3"."cnr"AS "cnr", "T3"."code"AS "code", "T3"."mark"AS "mark", "T3"."cvalue"AS "cvalue" FROM "C:\My Documents\Darbs\Imputation\new\2-darbs\Exports"+" \2002C4\2-darbs_02C4"."values" "T3".

Any ideas how to make the macro to work in this query?

-- Martins Liberts Central Statistical Bureau of Latvia address: Lacplesa iela 1, Riga, LV-1301, Latvia phone: 371-7366877 email: mliberts@csb.gov.lv


Back to: Top of message | Previous page | Main SPSSX-L page