RE: MI Unrecognised Command "Server Execute"

[Thake, Peter]

Hi Sanjoy,

I don't think you can issue the Server_Execute command using command method,
though I could be wrong! Server_Execute returns an integer value used later
for the fetch statement. You also need to close the link afterwards. eg.

        Statement_number = Server_Execute(hdbc,SQL_String)

        Server Statement_number fetch into "MyTable" File "c:\Mytable"
        'Note must name the file and path in statement above or will
generate error "unable to open table"
        Server Statement_number close
        server hdbc disconnect 

Try using the syntax above.
Hope this helps,

Pete, Ordnance Survey, UK

-----Original Message-----
From: IDS [mailto:[EMAIL PROTECTED]]
Sent: 06 August 1999 07:28
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]