SQLKey – About
A few details about this SQLKey web site.
I have revised the SQLKey web site from using static html pages to now using a WordPress CMS.
I am still learning more about WordPress but have found it much better and easier to work with than Joomla! which I have tried.
I also tried Drupal, but that looked like a full-time job with a longer learning curve.
The site is designed as a place to post a few tips and tricks for programming with Clarion For Windows , and more importantly, with using Clarion with MS-SQL .
As of late 2017, I am now 100% retired. I have trained up a friend (Kerry Leighton of Genawise Australia) and he may contact me with a few questions from time to time. Kerry works for Genawise Australia, the company that purchased all my clients from me.
Enjoy.
John Griffiths
We are using SQL as the back end to Clarion. I was wondering if there is a way to activate a stored procedure in SQL, pass it a value in a variable, and then capture the results for a report. Any suggestions?
Sure Walter. Use the CALL statement in your “prop:sql”. I use a DummyTable to do what you want. Yell if you want more and I’ll see if I can post an article on this.
From the CW Help:
SQLFile{PROP:SQL}='CALL GetRowsBetween(2,8)' !Call stored procedure