Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display value in text to
Message
From
27/02/2016 03:16:01
 
 
To
26/02/2016 18:52:48
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2008 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01632182
Message ID:
01632189
Views:
61
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform