> -----Original Message-----
> From: HENROTAY PIERRE 
> Sent: Friday, August 06, 1999 11:34 AM
> To:   'IDS'
> Subject:      RE: MI Unrecognised Command "Server Execute"
> 
> The Run Command does not apply to Server_execute; Server_Execute is a
> MapBasic function whose return function is an integer.
> Look at the MapBasic help for an example.
> Pierre
> 
> -----Original Message-----
> From: IDS [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, August 06, 1999 8:28 AM
> To:   [EMAIL PROTECTED]
> Subject:      MI Unrecognised Command "Server Execute"
> 
> Hello,
> 
> I am trying to execute the "server-execute command" in a loop. The syntax
> that I have written is as follows:
> 
> hdbc = Server_Connect("QELIB","DRIVER={MapInfo Win32 Oracle8
> Driver3.10};UID=PO8;PWD=PO8;SRVR=")
> str1 ="Server_Execute("+hdbc+", "+"""INSERT INTO
> TEMP_CLASS(ron,retlr_id)select rownum,retlr_id from BASE where location in
> ("""'")
> for ctr1=1 to ubound(arr_store)
>       if ctr1=1
>       then
>               str1=str1+""+arr_store(ctr1)+""""
>       else
>               str1=str1+","""+arr_store(ctr1)+""""
>       end if
> next
> str1=str1+")"")"
> note str1
> run command str1
> 
> Notes:
> 
> 1. arr_store(ctr1) -> array for string or integer
> 2. We are using MapBasic and Personal Oracle 8.0.4
> 
> 
> This gives an error : "Unrecognised Command "Server Execute"
> 
> The question is how to run the Server Execute command in a loop?
> 
> Thanks in anticipation
> 
> Sanjoy Dassarama
> **************************
> Integrated Digital Systems
> 4B Sundaram
> 46F Rafi Ahmed Kidwai Road
> Calcutta 700 016
> Tel : 91 33 2290541/2295265
> Fax : 91 33 4667974
> **************************
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to