Gammon Forum : MUSHclient : General : SQLite column order problem

Entire forum ➜ MUSHclient ➜ General ➜ SQLite column order problem

SQLite column order problem

It is now over 60 days since the last post. This thread is closed. Refresh page

Pages: 1 2

Posted by Nick Gammon Australia (23,133 posts) Bio Forum Administrator

Date Reply #15 on Fri 25 Jan 2013 09:39 PM (UTC)

Message

Looks good to me. You don't need the brackets for the "if" in Lua, but they won't do any harm.

Example:


local row	
local stmt = db:prepare (query)
	
if stmt then
  if stmt:step() == sqlite3.ROW then
    row = stmt:get_named_values() 

    -- process row

  end -- if got row
		
  stmt:finalize()
else
  -- sql error
end -- if got statement

- Nick Gammon

www.gammon.com.au, www.mushclient.com

Top

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

49,889 views.

This is page 2, subject is 2 pages long: 1 2

It is now over 60 days since the last post. This thread is closed. Refresh page

Go to topic: Search the forum

top