Error: Result Set Expired

Problem with install SQLiteStudio? Ask here.

Error: Result Set Expired

Postby JF11579 » Sat Aug 05, 2017 7:15 pm

Hi:
I am trying SQL today for the very first time. SQLite Studio to be precise.
I think I have the chinook database connected properly becasue the error message mentions it.
When I run: QUERY = "SELECT Composer , Name FROM Track WHERE Composer = 'Van Halen';"
I get back :[14:45:42] Error while executing SQL query on database 'chinook': Result set expired or no row available.
In fact no matter what I run I get this same error message.
Can someone help me get past this and started on SQL?

THANK YOU VERY MUCH ,
Joe
JF11579
 
Posts: 2
Joined: Sat Aug 05, 2017 7:09 pm

Re: Error: Result Set Expired

Postby Googie » Wed Aug 09, 2017 2:17 pm

Did you try with different query? For example what if you remove the whole "WHERE ..." part?
Googie
Site Admin
 
Posts: 772
Joined: Wed Jul 27, 2011 8:04 pm


Return to Installation

Who is online

Users browsing this forum: No registered users and 1 guest

cron