Home   Archive   Permalink



Dobeash SQLite Driver: SQLite ROW error?

Hello, I cannot understand this error. Using sqlite.r from dobeash.com in REBOL/View 2.7.8.3.1 on Windows 2012 R2; SQLite version is 3.15.2
    
In the most simplified form of what I am trying to do with CTEs, this query works under sqlite3 in a command line window, but fails when called in REBOL:
    
>>
>> sql {WITH x AS (select 'a' as study ),
{    y AS (select 'b' as study )
{    select y.study from y LEFT JOIN x ON y.study = x.study}
** User Error: SQLite ROW: sqlite_step() has another row ready
** Near: make error! reform ["SQLite" error]
>>
    
Any advice greatly appreciated!
-Jack


posted by:   JackKort       21-Mar-2019/14:40:20-7:00



Name:


Message:


Type the reverse of this captcha text: "e c i v r e s - e t o m e r - t s a l"



Home