V4REV - select using sql functions returns bizarre values

[william humphrey]

I'm glad to see you working on this Bernard. The LiveCode functions "V4REV"
need to be updated for function and documentation. I just use the same old
ones that I know work all the time and don't branch out into any of the
others because it takes so long to learn a new function both because of
documentation failings, my own failings, and sometimes the little used ones
don't work anymore because of changes in LiveCode. Are you using the most
recent release of LiveCode and on a Mac?

On Thu, Dec 15, 2011 at 8:25 AM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> wrote:

> On 12/14/11 7:18 PM, "Bernard Devlin" <bdrunrev at gmail.com> wrote:
>
> Hi Bernard,
>
> I believe issue is not infunction.
>
> They work in other ADKs and just in Vstudio.
>
> Issue is or
>
> A) in method of V4REV you try to use to get string from cursor
>
> B) or ... Hard to image what else
>
> Please show EXACT code of rev you have to get this ?
>
> Can you get other string fields from cursor ?
>
>
> > I ran through a selection of the various functions that can be called
> from a
> > SELECT.  As you can see from the results, most are defective:
>
> SELECT
> > DATABASEVERSION(); =  œ6
> SELECT CONCAT('Va', 'len', 'tina'); =  œV
> SELECT
> > HEAD('aesop', 'ea'); =  œa
> SELECT HEX( 327680 ) ; =  œ0
> SELECT FORMAT(now(),
> > '', 'kDateFormatFull'); =  œW
> SELECT INITCAP ( 'valentina' ); =  œV
> SELECT
> > LEFT('database', 5); =  œd
> SELECT IF('Hello!' LIKE 'Hello_', 1, 0); =
> > 1
> SELECT LOCATE('len', 'Valentina'); = 3
> SELECT MD5('1234567890'); =
> >  œE
> SELECT REGEX_REPLACE('abcd', '(ab)(cd)', '$2--$1:' ); =  œc
> SELECT
> > REVERSE('data'); =  œa
> SELECT RPAD('hello',7,'?'); =  œh
> SELECT
> > SCHEMAVERSION(); =  œ1
>
> From this selection it looks like IF() and LOCATE()
> > are returning
> correct results.  It seems that anything that returns a
> > non-integer
> result is failing.
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20111215/723daace/attachment.html>