bionperformance.blogg.se - Call mysql stored procedure from scriptcase

#Call mysql stored procedure from scriptcase code#

#Call mysql stored procedure from scriptcase code#

Again will work without this.Īuthor Mark Posted on Categories All, Low Coding Platforms, php, PHPRunner PHPRunner by Xlinesoft – a personal recommendation if you need a Low Code platform perfect for CRUD application developmentīit of background I am like most, constantly looking out for better tools and have been periodically searching Google for low code tools now for nearly 5 years.

You can qualify the variables that items are being passed to.

Qualify the stored procedure with the database schema (although it does seem to work without this I am told this results in better performance).

Most of what I have discovered here is written up Of course this is all documented but when there is so much to learn it can take sometime to just look at the documentation and understand it. PHP Server Part ( note this was my first effort which although worked did not qualify the database schema or name state the procedure variables being passed parameters)Īnd just for completeness the Javascript Client After PartĪnd how it looks in the list once deployedĪnd what happens once I have hit the button.

linkĪnd here are some screenshots of the code in PHPRunner Which lead me onto investigating how programs and operating systems manage memory space. you can see that the variables in the stored procedure that I happen to have been called and although they could have been named anything because PHP is passing the values and not the memory location(variable name) which makes sense because you are passing from a web server to a separate database server and the same memory spaces don’t exist in both. Looking at the stored procedure syntax in SQL Azure. Next I put the following code in the Server event

So in Javascript I am passing the field values to parameters called Firstname and Dcreate and then in PHP I pass those variables to the stored procedure and the database procedure does the rest. Where Firstname and DateCreated are field values in my table T0001Persons Params = row.getFieldValue("DateCreated") In the CLIENT BEFORE part of the tri part event I put (I will be working on something a bit cleaner later but for now I’m just trying to get it to work) I will be working on other methods as well.įrom my previous post I already had my SQL Azure Stored procedure defined as.ĭbo.T0001Persons.Firstname=' + '''' + '''' + 'ĪND <= ' + ''''įirstly I went to the list view in PHP Runner and within the designer I inserted a button into the row. Its probably possible to do this with some kind of DB::Query or DB::Lookup but in this instance I chose to use dynamic SQL. This is useful where you have values in a table row that you wish to pass to a stored procedure.Īs per the previous post I was wanting to use this in the context of needing to create a particular view from the data in a particular row. On loading the page create a pageObj variable named window.tablePageĪfter pressing the button if there is a pageObj variable named window.tablePage refresh it! Author Mark Posted on Categories All, Javascript, Low Coding Platforms, php, PHPRunner, Web Applications PHP-Runner linked to SQL Azure – Passing parameters from a row to a stored procedure which is then Executed My understanding of the way the code works is. The ClientAfterevent references the same pageObj for page refresh. My hunch is that you would want to name this something relating to the page and something not overly complicated but unique. Can be ClientAfterevent of any buttonĪs far as I can tell what you name the pageObj in this case tablePage is up to you – at the point of naming you are creating this variable. Add the following code to any Javascript event where you want to reload the table.

Add the following code to Javascript OnLoad event of the table in questionĢ. What version of ODBC is included or is Scriptcase using?įor a procedure to work it has to set the flag for CLIENT_MULTI_STATEMENTS … to which… I found this support/reason online: "Make sure you are using the latest ODBC version I believe the support for the CLIENT_MULTI_RESULTS flag was added in 3.51.12.For example on a page we have a button that parses text coming in.ġ.

The sql debug: (mysql): call myProcedurenamehere(paramvaluehere) I have tried this and I get a mysql or odbc error returned of: 1312: PROCEDURE mydatabasenamehere.myProcedurenamehere can't return a result set in the given contextĪDOConnection._Execute(call myProcedurenamehere(paramvaluehere), false) % line 1010, file: ĪDOConnection.Execute(call myProcedurenamehere(paramvaluehere)) % line 784, file: blank_app.phpīlank_app_apl.controle() % line 1037, file: blank_app.php