John introduce me to the set passthrough command - that allows a foreign
database command to work - I am using the below code - first witjout the
passthrough set on - everything works with the odbc table - when I set
on the passthrough - the program eother give me an error message or hang
up. When I used the sql command dirrectly everything works- is there
something I am missing? thank you for your help
j
inp r
select cust_id from a0cust_account
cust_id
----------
66
67
68
73
*set passthrough on
select cust_id from a0cust_account
-ERROR- Error message from server: [MySQL][ODBC 3.51
Driver][mysqld-5.1.52]You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'from a0cust_account' at line 1 (2957)*
Error message from server
set passthrough off
select cust_id from a0cust_account
cust_id
----------
66
67
68
73
--
*J. Blaustein*
*J Blaustein Associates, Inc.*
* 12 Herrick Drive*
* Lawrence, NY 11559*
*516-371-3445 FAX 516-345-8009*
