Hi,
I am trying to create a generic module to take an SQL statement as an argument and connects to an oracle db, which then returns the resulting recordset back to the calling module for processing. I have managed to create the connection to retrieve a recordset, but I have to repeat the code in every module and I am trying to reduce the amount of code for ease of support. Any ideas????
Thanks
Paul
I am trying to create a generic module to take an SQL statement as an argument and connects to an oracle db, which then returns the resulting recordset back to the calling module for processing. I have managed to create the connection to retrieve a recordset, but I have to repeat the code in every module and I am trying to reduce the amount of code for ease of support. Any ideas????
Thanks
Paul