On 23 Feb, [EMAIL PROTECTED] wrote:
> 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]]
>
I think you want to use "SQL DataLink" that came with your UNIX
version of MapInfo/MapBasic. You may have to get a license key from
MapInfo for SQL DataLink.
--
-----------------------------------------------------------------------
Roy Stewart Global Atmospherics Inc.
Applications Developer Manufacture and systems integrator of lightning
[EMAIL PROTECTED] location and detection equipment and services
Phone: (520) 741-2838
2705 E. Media Rd. Fax: (520) 741-2848
Tucson AZ 85706-7155 Web: http://www.glatmos.com
How intelligent is it,
to start the day by tying a noose around your neck?
-----------------------------------------------------------------------
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]