Parameters in SQL and MMEX

[rrodsal]

Hi there!

Is posible to use parameters in SQL and MMEX? Anybody can provide me a example?

I'm triying to amend some queries to ask about the year, the category, etc...I'm not able to do.

Thanks a lot

Regards

rrodsal

[Nikolay]

At the moment it is not possible.

[Nikolay]

And now we developing Lua scripting language interface. Now it possible!
For more information I've refer you to manual:
http://moneymanagerex.svn.sourceforge.n ... Extensions

[Renato]

Hello Nikolay

can provide me a example?

[Nikolay]

Code: Select all

-- Simple test script
------------------------------------------------------
function GetUserInfo()
   var = mmGetTextFromUser("What is your name?", "Lua Script",  "")
   return var
end
--
msg_1 = "Welcome to the world of " .. _VERSION .."<br> "
result = _"Hello "..GetUserInfo() .. "<br>".. msg_1
--
return result
--

Code: Select all

-- File: Test mmGetTableChoice
-------------------------------------------------------
   message = _("Select a month")
   heading = _("Lua: GetTableChoice")
   choice_array = {_("January"), _("February"), _("March"), _("April"), _("May "), _("June"),
        _("July"), _("August"), _("September"), _("October"), _("November"), _("December")}
  value = mmGetSingleChoice(message, heading, choice_array)
  return value

Code: Select all

sql_script_1 = "select payeeid, payeename from payee_v1"
sql_result, err = mmGetSQLResultSet(sql_script_1)
if err == 0 then
     choice, id = mmGetColumnChoice("1", "2",SQLResultSet, 2)
else
     choice = sql_result --Error description
     id = -1
end
return "Your choice: " .. choice .. " ID: " .. id


[Nikolay]

Code: Select all

eol = '\n'
br = "<br>"
site = "http://download.finance.yahoo.com/d/quotes.csv?s=USDEUR=X&f=snd1l1t1"
    var_1 = mmGetSiteContent(site)

   site="http://download.finance.yahoo.com/d/quotes.csv?s=AZNRUB=X+HRKRUB=X+EURRUB=X+RUB=X+INRRUB=X+RUB=X+RUBRUB=X+UAHRUB=X+GBPRUB=X+USDRUB=X&f=sl1n&e=.csv"
    var = mmGetSiteContent(site)

var = var:gsub(eol, br)
return var..br..br..var_1

[Renato]

Hello Nikolay

If I understand correctly, I could now use this selection:

Code: Select all

sql_script_1 = "select payeeid, payeename from payee_v1"
sql_result, err = mmGetSQLResultSet(sql_script_1)
if err == 0 then
     choice, id = mmGetColumnChoice("1", "2",SQLResultSet, 2)
else
     choice = sql_result --Error description
     id = -1
end
return "Your choice: " .. choice .. " ID: " .. id


to List all entries in the selected category.

Would it be possible to publish here, such a script (with entries and Total). ???

LUA: really for Beginners :http://lua.gts-stolberg.de/en/index.php

[Nikolay]

If something selected the data will be placed in Lua table (SQLResultSet).
Then you can do what you want in Lua side, then transform any data to html.