A
Ashish Nanda
Hi i want to run a qury when i close a form , i am already
connected to the server when i am running this as i am
using a shared database but i dont want to run a query in
Access i want ot run it in SQL so that the results are
faster.So i am trying this.
The query runs perfectly on my workstation and does the
deallocation but when i try to run the application on a
differnet workstation it gives me an error.
What could be the cause. Can anyone help?
Private Sub Form_Close()
Dim IRowcount As Integer
Set OraSession = CreateObject
("OracleINProcServer.XOraSession")
Set OraDataBase = OraSession.OpenDatabase
("bio", "scott/nanda", ORABD_DEFAult)
IRowcount = OraDataBase.ExecuteSQL("Update leadman.leads
set date_avail=null,remove ='Y',rsn2remove='De Allocated'
where (sysdate-date_avail)>20 and sman is null")
MsgBox IRowcount & " Rows De Allocated"
Is there a better way of doing it...?
Best Regards,
Ashish Nanda
..
connected to the server when i am running this as i am
using a shared database but i dont want to run a query in
Access i want ot run it in SQL so that the results are
faster.So i am trying this.
The query runs perfectly on my workstation and does the
deallocation but when i try to run the application on a
differnet workstation it gives me an error.
What could be the cause. Can anyone help?
Private Sub Form_Close()
Dim IRowcount As Integer
Set OraSession = CreateObject
("OracleINProcServer.XOraSession")
Set OraDataBase = OraSession.OpenDatabase
("bio", "scott/nanda", ORABD_DEFAult)
IRowcount = OraDataBase.ExecuteSQL("Update leadman.leads
set date_avail=null,remove ='Y',rsn2remove='De Allocated'
where (sysdate-date_avail)>20 and sman is null")
MsgBox IRowcount & " Rows De Allocated"
Is there a better way of doing it...?
Best Regards,
Ashish Nanda
..