I agree with Nancy. Remove anything that is UI related.
Are you using SP5?
Also, why are you requiring a transaction for a query? It's overhead that isn't needed.
>Hi all
>
>I have a big problem with one of my component and i just found out the cause of the problem, maybe somebody can explain what i am doing wrong.
>
>Here is the sequence to reproduce the problem:
>
>On a VFP Com server on Com+ set with "require transaction" Built with VFP6 SP5 Running on W2K Server SP2
>
>
>lnConnect SqlConnect( MySqlConnect String to Sql Server 2000 )
>lnResult = SqlPrepare( lnConnect, "Select * from someTable Where SomeField = ?" )
>*-- Value of lnResult = 1
>lnExecRes = SqlExec( lnConnect)
>*-- lnExecRes value is 1 even if the statement was not successfull !!
>=SqlDisconnect( lnConnect )
>*-- I get a C5 Right here every time
>
>
>Anybody could tell me what i am doing wrong, my statement contains a "?" and VFP would normally ask the user for a parameter but since we are in a DLL and no interface is allowed, i trap the error with a IF Used("TableName") and then disconnect. Maybe VFP is confused by the ? inside a dll !!
>
>Thanks
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer