>Hello comunity
>
>I want to know if it is possible display the variable values with ? In text to msel...
>Example
>
>Text to msel textmerge No show
>Insert into mytable1(date, documentname,value, isprocess)
>Select ?t.date, ?t.documentname, ?t.debit, ?t.process
>From mytable2 t where t.keystamp = ?t.keystamp
>Endtext
>
>If sqlexec(msel)
>Else
>Msg(msel)
>Endif
>In fact i need to see all variable value passed with ?something.
>On my example i want to see:
>Select '20160229', 'invoice',234.50,1
>From mytable2 t where t.keystamp='adm12334.456'
>
>Many thanks
>Luis
You don't have access to the actual SQL statement passed to the server, as it is hidden deeply in the ODBC driver inner works. Not even the trace will display them. But, of course, at any time you have full access to the expressions used as parameters.
I believe the example you gave is not an actual production example: parameters are set at the client environment, not at the server's. What follows each ? is an expression that must be resolved by VFP before the execution of the statement(s).
----------------------------------
António Tavares Lopes