V4REV - select using sql functions returns bizarre values

[Ivan Smahin]

On Dec 14, 2011, at 4:45 PM, Bernard Devlin wrote:

> "SELECT FORMAT(now(), '', 'kDateFormatFull')"
> 
> Using an example like the above from the Valentina wiki:
> 
> http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string&s[]=string&s[]=function#locale
> 
> I find that the value returned in the cursor is "ˇ˛W" , and not some
> formatted date as one would expect.
> 
> I get a cursor that consists of a single row with a single field,
> named "No_name1" of type "KTypeString".
> 
> I am using put VField_Value( fldRef ) to get hold of the value from
> the one field in the cursor.  If I try to use VField_String, I get a
> Livecode error.  

There is no such a "method" in V4REV.
You are right using VField_Value

> Unfortunately the Livecode error is not very
> informative.  It could be that VField_String has not been implemented
> - I could not find a stack in the Paradigma-provided stacks that uses
> VField_String.  Thus, I cannot isolate if the problem comes from using
> VField_Value, or if it is actually a defect in the select/format
> combination.
> 
> Can anyone confirm that such a sql call works using another Valentina
> connector?  I have tried several of the example select/function calls
> from the wiki, and none provide any meaningful results.
> 
> 

Have you tried it with Valentina Studio?

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com