Livecode, DBLib and Quartam Reports

[nicoloose]

Good day,

Does anyone have a working example of printing from an sqlite databse using the DBLib library? I need to ask some questions as my coding skills are non-existent.

Thanks
Nic

[MaxV]

If you have no program skills, probably you don't need that library. Please, explain better what you want to do with a clear example. Livecode embed sqlite3, so probably Livecode already has all you need.

[nicoloose]

I have actually managed to figure out how to use DBLib commands to print to the quartam print stack. Thank you for your time though. My next problem will be to put together the correct SQL statements to gather data from separate tables all at once instead of using multiple selects.

[MaxV]

I don't have Quartam Reports, but to print a stack usually this is the code:

Code: Select all

 print stack "a very cool stack"

Probably you should read this: http://livecode.wikia.com/wiki/Printing

Regarding SQL, please, give me an idea of tables and data and what you need.