V4REV - select using sql functions returns bizarre values

[Bart Pietercil]

Executing with vStudio gives

Wednesday, December 14, 2011 3:57:44 PM GMT+01:00

hth,  

--  
Bart Pietercil
CTO Cognosis NV
Dorpstraat 28
3560 Lummen


Sent with Sparrow (http://www.sparrowmailapp.com/?sig)


On Wednesday 14 December 2011 at 15:45, 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. 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.
>  
>  
> Bernard
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net (mailto:Valentina at lists.macserve.net)
> http://lists.macserve.net/mailman/listinfo/valentina
>  
>  
>  


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20111214/985a27b8/attachment.html>