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