[V4REV] problem with binded variables - SQL

[David Simpson]

Ruslan,
In the Mantis report, I wrote:

[Answers to your questions: 11/8/2008

Stack - The stack which shows this issue is attached. The handler is  
900_03 (this is test 003 in my 900 series test stack, which is  
specific to Valentina database testing.

Yes - Revolution 2.9+ includes support for bind variables with the  
revExecuteSQL statement. I use this feature successfully with SQLite,  
ODBC and MySQL databases.
I am using the revDB calls because I have thousands of lines of code  
in my application which have to work with 12 different databases - so  
that is why I use the platform and database independent revDB funtions.

Dates - Extra spaces issue - Yes - I understand that Valentina will  
require precise date formatting. When I look at the source data in  
the array element for that field, there are no extra spaces. But when  
I see the error message returned in the varError variable, I see  
extra characters following the date. ]


David Simpson
www.fmpromigrator.com