>>we are using pdox 4.5 and sql-links 1.0 with oracle 7.x
>>How can I only log onto the database once in a multiform application? We
>>pass other variables between forms using a library. Pdox won't let a
>>method return a variable of type database! How do I put to gether an
>>application with multiple forms and not force a user to re-login to
>>oracle becuause every form is using the database!
>>Any hints or actual answers will be greatly greatly appreciated! Thanks
>This works if you pass the dataBase varible by reference. Here's an example
>of how you can make this work.
>In your library create a method that every form will call to make sure the
>dataBase is open.
>method initDB(var db dataBase)
>if not db.isAssigned() then
>Then on the open method of each form, before the doDefault open the library
>and call initDB pass in a dataBase varible. As long as the form is open
>the dataBase varible will be open.
>|| || ||\/|| ||=|| ||| Phone : (408) 425-7455
>!!!! !! !! !! !! !! !! !! Fax : (408) 425-7516
change roles on login, so I have a library login and then execute a sql
statement " set_role write_role with identification idpassword".
The statement executes correctly. It raises the role of the login to allow
the application to write to the database. It works from the sqldba command
line, but the Paradox app tcursors returns with insufficient priviledge
errors. Any Ideas? Thanks again in advance!
/* Through the driver, out the port, off the modem,
through the phone line ... nothing but Net. */