At 07:07 PM 9/15/2005, James Hagman wrote:
How about if the database is on another computer?
James.
In that case, you'll need to define a System DSN using the UNC
method and making sure that your workstation is able to see and
connect to that database with all access rights, etc.
That's all there is to it!
Very Best R:egards,
Razzak.
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.
