>All parameters are strings, except the six parameter that is a SQL date then I use TTOC(datetime()) and the reference parameter paraoutput2 that also uis a SQL date type , then I used datetime() to set this parameter before to be called.
>The parameter paraoutput1 is supposed to return a code if some parameter is wrong or if the transaction is ok, but I'm receibing strange characters and some times I receive a Substring of the lcstring (sql string statement)
It looks like everything is okay. Can you use Query Analyzer (SQL Server) or SQLPlus (Oracle) to send your query outside of the VFP environment? Does it work with these? Othan than that, I'm sorry I couldn't help.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao