Close all open databases -- VDataBase_Open()

[Mark Schonewille]

Hi Ruslan or anyone else who knows this,

Unfortunately, this script

function queryTest
    put vDatabase_SqlQuery(lDatabase,"SHOW DATABASES") into myCursor
    put VCursor_GetRecords(myCursor,,,tab,cr) into myData
    return myData
end queryTest

returns an empty value. An integer is stored in myCursor, but myData is 
empty. If I run the samein Valentina Studio, I get a small table with 
all databases. What am I doing wrong?

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other 
colour spaces. http://www.color-converter.com

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

Fill out this survey please
http://livecodebeginner.economy-x-talk.com/survey/

On 10/13/2013 23:15, Ruslan Zasukhin wrote:
> On 10/13/13 8:18 PM, "Mark Schonewille" <m.schonewille at economy-x-talk.com>
> wrote:
>
> Hi Mark,
>
>> Thanks. How do I execute SQL and get the data directly, just like the
>> revDataFromQuery() function in LiveCode?
>
> Hi Mark,
>
> Directly into string?
>
> Oops, it seems PDF misses 2 functions of this kind
> We will add it tomorrow.
>
>
>
> Class VCursor
>
>
> put VCursor_GetRecord(
>      cursorRef, [RecIndex], [fldDelimiter] )
> into VAR
>
>
>
> put VCursor_GetRecords(
>      cursorRef, [FromRec], [MaxRecords], [fldDelimiter], [recDelimiter] )
> into VAR
>
>
>
>
>