5234_de-DE

liliconcom

Skript zur Angabe des DBQ<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Hallo,

Ich frage mich, wie ich die Quelle der Datenbank angeben könnte, sodass diese, vielleicht als globale Anweisung, von jedem dt = referenziert werden könnte. Wie Sie im folgenden Skript sehen konnten, dupliziere ich DBQ = .... für jedes dt =. Der einzige Unterschied ist der Teil "SELECT ...". In SAS würde ich eine Makrovariable schreiben (% let dir = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse \), um den Speicherort der Datenbank anzugeben. Aber ich habe nicht gelernt, wie man das in JMP macht. Ich habe den duplizierten Teil der ersten beiden dt = unterstrichen. Mein Skript liegt bei.

dt1 = Open Database ("DBQ = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse \ Chang_bee_db.mdb; DefaultDir = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse; Treiber = {Microsoft Access Driver (* .mdb)} ; DriverId = 25; FIL = MS Access; FILEDSN = C: \ Programme \ Gemeinsame Dateien \ ODBC \ Data Sources \ chang_bee_db.dsn ; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID = admin; UserCommitSync = Yes; ",

    "SELECT * FROM qryAFF14", "qryAFF14", unsichtbar);

dt2 = offene Datenbank ("DBQ = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse \ Chang_bee_db.mdb; DefaultDir = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse; Treiber = {Microsoft Access Driver (* .mdb)} ; DriverId = 25; FIL = MS Access; FILEDSN = C: \ Programme \ Gemeinsame Dateien \ ODBC \ Data Sources \ chang_bee_db.dsn ; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID = admin; UserCommitSync = Yes; ",

    "SELECT * FROM qryALF0", "qryALF0", unsichtbar);

dt3 = Datenbank öffnen ("DBQ = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse \ Chang_bee_db.mdb; DefaultDir = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse; Treiber = {Microsoft Access Driver (* .mdb.) )}; DriverId = 25; FIL = MS Access; FILEDSN = C: \ Programme \ Gemeinsame Dateien \ ODBC \ Data Sources \ chang_bee_db.dsn; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID = admin; UserCommitSync = Yes; ",

    "SELECT Behandlung, Biene, Alter, days_exp_cum, trips_exp_count FROM qryTrips_days_exp", "qryTrips_days_exp", unsichtbar);

dt4 = Datenbank öffnen ("DBQ = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse \ Chang_bee_db.mdb; DefaultDir = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse; Treiber = {Microsoft Access Driver (* .mdb.) )}; DriverId = 25; FIL = MS Access; FILEDSN = C: \ Programme \ Gemeinsame Dateien \ ODBC \ Data Sources \ chang_bee_db.dsn; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID = admin; UserCommitSync = Yes; ",

    "SELECT * FROM qryLeft_time_hour", "qryLeft_time_hour", unsichtbar);

dt5 = Datenbank öffnen ("DBQ = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse \ Chang_bee_db.mdb; DefaultDir = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse; Treiber = {Microsoft Access Driver (* .mdb.) )}; DriverId = 25; FIL = MS Access; FILEDSN = C: \ Programme \ Gemeinsame Dateien \ ODBC \ Data Sources \ chang_bee_db.dsn; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID = admin; UserCommitSync = Yes; ",

    "SELECT * FROM qryCombo_exp", "qryCombo_exp", unsichtbar);

Re: Skript zur Angabe des DBQ

Versuche dies:

dbq_string = "DBQ = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse \ Chang_bee_db.mdb;" ||

             "DefaultDir = E: \ Now \ (Projekt) RFID_r3_Homing_r1 \ Ben-Analyse;" ||

             "Driver = {Microsoft Access Driver (* .mdb)}; DriverId = 25; FIL = MS Access;" ||

             "FILEDSN = C: \ Programme \ Gemeinsame Dateien \ ODBC \ Datenquellen \ chang_bee_db.dsn;" ||

             "MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID = admin; UserCommitSync = Yes;" ;

dt1 = Datenbank öffnen ( dbq_string .

    "SELECT * FROM qryAFF14" . "qryAFF14" . unsichtbar ) ;

dt2 = offene Datenbank ( dbq_string .

    "SELECT * FROM qryALF0" . "qryALF0" . unsichtbar ) ;

dt3 = Datenbank öffnen ( dbq_string .

    "SELECT Behandlung, Biene, Alter, Tage_exp_cum, trips_exp_count FROM . "qryTrips_days_exp" . unsichtbar ) ;

dt4 = Datenbank öffnen ( dbq_string .

    "SELECT * FROM qryLeft_time_hour" . "qryLeft_time_hour" . unsichtbar ) ;

dt5 = Datenbank öffnen ( dbq_string .

    "SELECT * FROM qryCombo_exp" . "qryCombo_exp" . unsichtbar ) ;