Sloan You need to use the DLG switch e.g in your case "DLG=0" - this suppresses the dialog unless you have entered the wrong values.
Paul Crisp BT Syntegra Innovation Place Delta Bank Road Newcastle NE11 9DJ Tel 0191 461 4522 Fax 0191 460 1987 -----Original Message----- From: Sloan Ritchie [mailto:[EMAIL PROTECTED] Sent: 22 March 2004 22:41 To: Jorge Cordero; [EMAIL PROTECTED] Subject: RE: MI-L ODBC Dialog OK, Thanks for the response. After it populates, the dialog box just sits there until I "OK" it. Can it be accepted automatically without my clicking OK? This way the script can proceed without me. Sloan -----Original Message----- From: Jorge Cordero [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 2:19 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MI-L ODBC Dialog Try with this command: ConnNum= Server_Connect("QELIB","SRVR=" + gcSRV + ";DBMS=" + gcDSN + ";DNS="+";DB=" + gcDTB + ";UID="+gcUSR+";PWD="+gcPSW) Where gcSRV = Is the name of PC server where life database gcDSN = Is the name of DSN gcDTB = Name of DataBase gcUSR = User of Database gcPSW = Password to login Jorge Cordero Mexico DF -----Mensaje original----- De: Sloan Ritchie [mailto:[EMAIL PROTECTED] Enviado el: Monday, March 22, 2004 4:04 PM Para: [EMAIL PROTECTED] Asunto: MI-L ODBC Dialog Hi, Bear with me, I am not an experienced programmer. How do I use the following MapBasic code, but also have the ODBC dialog click "OK" automatically. I want this to run every day automatically. Can I add a line of code that will allow the ODBC dialog "OK" button to occur automatically? Thanks, Sloan ConnNum = Server_Connect("ODBC","DSN=ARS1;UID=user;PWD=password") hstmt = Server_Execute (ConnNum, "Select Request_ID, Device_Name, Latitude, Longitude, Access_Type, Date_Time_Targeted_Real, Assigned_To, Date_Time_Assigned, Site_Owner, Product_Type, Short_Description, Freeform_Description, Notes, Num_Preferrred_TOMMS, Status, SC_Affected from Service_Request where SC_Affected like '%Puget%' and Status <>'Closed'") Server hstmt Fetch Into "ARS_tickets" Commit Table ARS_tickets As "ticket" Close all interactive Server hstmt Close Server ConnNum Disconnect --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11010 ******************************************************************** This email may contain information which is privileged or confidential. If you are not the intended recipient of this email, please notify the sender immediately and delete it without reading, copying, storing, forwarding or disclosing its contents to any other person Thank you Check us out at http://www.btsyntegra.com ********************************************************************
