SQLite3 Action Plugin (free)

[reteset]

SQlite3 Action Plugin Has Been Updated

What's New :

• New : Updated to AutoPlay Media Studio 8

• New : Help file now integrated to plugin (except actions)

• Note : Plugin now requires minimum Windows 2000

Download : Click Here

[Imagine Programming]

what ??

what is Forum Member rank

The text what sais Indigo Rose Customer or Forum Member, but for
some reason, it sais Indigo Rose Customer again in your name (it said
Forum Member a while back)

[webultra]

Another function that could be use after FillGrid()

function AppendGrid(gObject, sqlquery, title)
	if db then
		if ( db:isopen() ) then
			local stmt = db:prepare(sqlquery)
			if stmt then
				--## If we don't know the number of columns that will be retrieved by the query we can do the following ##--
					if (Grid.GetColumnCount(gObject)) < (stmt:columns()) then
						for b=1, ((stmt:columns())-(Grid.GetColumnCount(gObject))) do
							Grid.InsertColumn(gObject, -1, false);
						end
					end
					Grid.InsertRow(gObject, -1, false);
					local j = Grid.InsertRow(gObject, -1, false);
					if title then --it's like a subtitle that describes what we're going to append
						Grid.SetCellText(gObject, j, 0, title, false);
					else
						Grid.SetCellText(gObject, j, 0, "", false);
					end
					local k = Grid.InsertRow(gObject, -1, false);
				--## END ##--
				Grid.SetRedraw(gObject, false, false);
				for n,y in stmt:get_names() do
					Grid.SetCellText(gObject, k, n-1, y, false);
				end
				for row in stmt:rows() do ----It returns an indexed table like db:rows
					nRowID = Grid.InsertRow(gObject, -1, false);
					for x=1, stmt:columns() do
						if row[x] then
							Grid.SetCellText(gObject, nRowID, x-1, row[x], false);
						else
							Grid.SetCellText(gObject, nRowID, x-1, "", false);
						end
					end
				end
				Grid.AutoSizeColumns(gObject, GVS_DEFAULT, false);
				Grid.ExpandLastColumn(gObject, false);
				Grid.SetRedraw(gObject, true, true);
				stmt:finalize();
			end
		else
			Dialog.Message("Notice", "You haven't selected any database.", MB_OK, MB_ICONSTOP, MB_DEFBUTTON1);
		end
	else
		Dialog.Message("Notice", "You haven't selected any database.", MB_OK, MB_ICONSTOP, MB_DEFBUTTON1);
	end
end

[reteset]

And something else, how did you get a green name, but a Forum Member rank? 0.o'

what ??

what is Forum Member rank

[Imagine Programming]

thank you :yes

And something else, how did you get a green name, but a Forum Member rank? 0.o'

[Centauri Soldier]

Hey reteset,

Do you have any plans to update this plugin with functions for the intellisense and all that fancy? I'd love to see more done with this plugin, I love it!

[reteset]

Here comes the help . 3 more ways to read a database and fill the grid. I hope this could help.

thank you :yes

[webultra]

Here comes the help . 3 more ways to read a database and fill the grid. I hope this could help.

[reteset]

is there anyone who has some examples which are using SQlite3 plugin.
if so please could you upload to here.
because i am receiving example request PMs from new users
and i can not provide examples for this plugin right now

thanks

[reteset]

Correction :

Lua Version : Lua 5.1 was not correct

this plugin uses statically linked Lua 5.0 library that comes with IR PluginSDK
it was an unnecessary information though
sorry for confusion.

[reteset]

here is a simple first step example for SQLite3 action plugin
actually there are no much differences between standard SQLite plugin

for example sqlite3:exec("") does same thing with SQLite.QuerytoTable

simply : sqlite3:exec("") returns same thing with SQLite.QuerytoTable

this example shows :

• Create and open a database

• Create a table with simple fields

• Add 500 entry

• Query and load data into stadard grid object

i am going to update this example when i have got free times

[azmanar]

Hi,

Just bumping this thread up for everyone's reference.

Major contributions by our friends, Reteset & Dermot.

[bule]

First, bule.

myvalue = Input1.GetText()
sql = "INSERT IGNORE INTO Table (id, name) VALUES (null, "..myvalue..");"

Don't you mean

Input.GetText("Input1");

?

Indeed. Too much of a Delphi lately, I guess.

[Dermot]

Try this.

db:exec("CREATE TABLE ProfServ (id INTEGER PRIMARY KEY, cdat, cust, desc, proj, lang)")

db:exec("INSERT IGNORE INTO ProfServ (id, cdat, cust, desc, proj, lang) VALUES (NULL, '".. s_cdat .."', '".. s_cust .."', '".. s_desc .."', '".. s_proj .."', '".. s_lang .."')");

[ShadowUK]

Concentation in long strings ( [[ ]] ) is something along the lines of this.

world = "world";
hello = [[Hello ]]..world..[[!]];