How about if the database is on another computer?
On Sep 15, 2005, at 5:05 PM, A. Razzak Memon wrote:
At 04:20 PM 9/15/2005, James Hageman wrote:
Can I do this in an eep? Such as
--------------------------------------------------------------
SCONNECT recman IDENTIFIED BY username
SATTACH department
SELECT * FROM department ...
RETURN
-------------------------------------------------------------
James,
Yes, you can!
You'll need to use the BROWSE command to view the data.
Use the following sample as an embedded custom EEP for button
in RBG7/RBG75/RBG8 Form Designer:
-- start
SDETACH Albums NOCHECK
SDISCONNECT BluzVan
SCONNECT BluzVan IDENTIFIED BY NONE
SATTACH Albums USING ALL
BROWSE * FROM Albums
RETURN
-- end
Make sure to define a system DSN "BluzVan" based on BluzVan
database in C:\RBTI\Oterro31 directory using the Oterro3.1
ODBC driver.
Enjoy and make sure to have fun
Very Best R:egards,
Razzak.
