If you are using MI 5.0 you could use the Live ODBC which would solve that
problem. The other solution is the one I have used in the past. I only
retrieve the records I require from the server at any given time. I.e. I
send an SQL statement to the server using Server_Execute then retrieve the
results using Server_Fetch Into .... (or similar). This then creates a
small table of the relevant results.
Hope that helps
Yours
Anton
Anton de Gruchy
----------------------
MapIT
29 Tecoma Crescent
Thornton
Cape Town
7460, South Africa
Tel: 27+21+548998
email: [EMAIL PROTECTED]
cell: 082 855 9747
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: 23 February 1999 06:56
To: [EMAIL PROTECTED]; Bill Thoen
Subject: MI ODBC problem
Hello All !!
Sorry for repetition, but this question I am
putting in the list third time, if any one
can help me I will really be happy.
the problem is (are)
1) is there any other way to use ODBC tables
other than making a local copy, as I am
using Oracle 7.2 database from Sun and every
time I am to make a local copy of that
table, as rows goes into million and it
creates space problem also in hard disk.
2) How do we automate the link of ODBC,
if I make the connection and record in MB
window the following results appear but when
I try in MB nothing happens
Dim __ODBC_QUERY__ as String
Dim __ODBC_CONSTRING__ as String
Server Link Table __ODBC_QUERY__ Using
__ODBC_CONSTRING__ Into "acc_year" File
"C:\DATA\Basedata\acc_year.TAB" Undim
__ODBC_QUERY__ Undim __ODBC_CONSTRING__
Thanks in advance for my help
Aditya
Executive (Systems)
Information Systems Department
GCMMF, Anand
[E-mail me at [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]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
