Lutz wrote:Thanks for the information Chi. You can just email or pm me the file sqlite3.lsp and I include it in the upcoming 10.0.6 development release.
I sent you the extended file just a few moments before to the address you told me below. Thank you for considering to include my enhancement :-)
I assume you added an optional parameter to the 'sql3:sql' function so the function is used with or without extra variable binding?
You are right. I hope I did document it well, but if I need to improve the documentation, please let me know.
The optional parameter may be a normal list (if the host variables within the SQL statement are marked '?' only -- positional arguments), or a association list, if one choose to use the '?<number>', ':<name>', '@name' or '$name' style of host variable markup. In the second case, the parameter are not positional as they will be identified by the key part of an association, whereas the associations' value will be the value to be bound to the host variable.
If there is anything unclear. please let me know!
Thanks for adding a testing function too. You can send me the file to lutz at nuevatec dot com. Also let me know what name to add in the author line.
for your nice language! :-)