SQLITE Query Successful command line faile RR

[trevordevore]

Hi Kevin,

I can't tell from your last response if you were just posting what you got working or not. I just wanted to confirm that your original code works fine (Rev works with SQLite databases in memory) if you include the database id when calling revDataFromQuery:

Code: Select all

on mouseUp pMouseBtnNo
    put revOpenDatabase("sqlite",,,,,,,) into _db 
    put revDataFromQuery(comma,return,_db,"SELECT datetime('now');") into _now
    revCloseDatabase _db 
    answer _now
end mouseUp

Placing the following code in a button in Rev 3.5 enterprise will display "2009-10-31 12:59:43" in an answer dialog.