Call Set Trans or SetTransObject Function Error

[bigpapi]

Hey folks;


i'm getting the following error when i try to retrieve values on a data window.

"Call Set Trans or SetTransObject Function"

Here is my code:

dw_mytest.SetTransObject( SQLCA )
dw_mytest.Retrieve()

My database connection is set and i can retrieve values in the data window screen.

Is there something else i am missing???

 

[mbalent]

Have you checked the return code from the SetTransObject call?

Matt

"Nature forges everything on the anvil of time

 

[thekl0wn]

Try adding this directly after your .Retrieve():

MessageBox( 'SQLcode...', 'SQL Code: ' + SQLCA.SQLerrText )

If you're booted out before that, then move it before the .Retrieve().