Posted: Sat Oct 31, 2009 2:00 pm
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:
Placing the following code in a button in Rev 3.5 enterprise will display "2009-10-31 12:59:43" in an answer dialog.
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