Hello FireWorx,
Finally we now have a solution for running
Stored Procedures
by passing parameters to get results from SQL2008R2. The solution came via
Code: Select all
MS Excel Library for LiveCode - 1.3.3
by a very brilliant, overtly helpful and intelligent
Zryip TheSlug
.
So this is the skinny on using his external to make Stored Procs work, which of course requires you purchase the plugin (which is a great way to support indie developer work), keep in mind we need the data outside of MS Excel for an internal solution we are building for our internal users, so going through MS Excel was unavoidable as this is the only way we can get to have a system that automatically runs a stored proc when our business application starts up (I don't have to over state or remind that I have not seen a pure LC solution to running Stored Procs by itself).
(1). Initialize ExcelLib in your main stack (plugin by Zyrip).
(2). Use his ExcelLib commands
Code: Select all
XCEL_Workbook_Open, XCEL_PivotTable_New_FromSQL, XCEL_PivotTable_Fld_Define
to encapsulate and run the
Stored Procedure
.
(3). Dump the data result in your MS Excel spreadsheet and pass in the data a multi-dimentional array, this way you can send the array to your
DataGrid
or just dump the result in plain text.
There is a considerable amount of lag using this method, but it is due to the fact of using the ExcelLib in this fashion as a walk around to run stored procs and the side effects of MS Excel loading up and populating the results from the stored proc run.
Zyrip's ExcelLib is well commented and he constantly updates the plugin by adding new functionalities to it. As the plugin stands now, it is robust and allows for quite a great deal of flexibility with running some business oriented solutions.
There was a lot of trial and errors on our part in get the data how we want it, but all in all to us just an afternoon.
This is my update on the Stored Proc, and I hope this will help someone out there, like me for months, trying to find a solution to running stored procs in LC.
Hope this all helps and I can share more on ExcelLib if needed, but your best bet will be reaching out to
Zyrip
for questions on how ExcelLib plugin.
Good luck all,
Steveuba
Custom IT solutions that won't require you to break the bank.......
http://www.ezektec.com/