To [AutoComplete] attribute iparxi stin me8odo tou component den xeirizomai egw to transaction.
To connection den to kratao se kapoi pedio alla mesa stin me8odo.
Ta settings tou component einai:
Object Pooling = false
JIT Activation = true
TransactionOption = RequiresNew
TransactionIsolationLevel = ReadCommitted
8a prospa8iso na perigrapso me pseydokodika to comonent:
-----------------------------------------------------------------------------------------------------------
Public Class Component
Public Sub TransferDataFromSQLtoOracle()
GetDataFromSQL()
InsertDataToOracle()
End Sub
AutoComplete
Private Sub GetDataFromSQL
Try
open connection
get record from table (SELECT Top 1....FROM T1 With (NOLOCK))
delete record (DELETE FROM T1 with (ROWLOCK) WHERE ID=...)
Catch
Finally
close connection
End Try
End Sub
AutoComplete
Private Sub InsertDataToOracle
Try
open connection
insert record
Catch
Finally
close connection
End Try
End Sub
End class
----------------------------------------------------------------------------------------------------
Distixos o SQL Server briskete se allh etairia kai den exw ton elegxo...
Pantos tsekara tin version pou exoun kai distixos den exoun riksi kanena SP!!!
tous enimerosa kai perimeno na dw an to problima htan ayto...oso gia to OS perimeno akoma apantisi ti SP exoun riksi...
Tnx again...!