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Ģ. Thread Author Mark Posted on Categories All, ASP-NET Runner, CRUD, Low Coding Platforms, php, PHPRunner, Sweet Alert PHP Runner : Tips and Tricks – Reload a page from event that belongs to a buttonįor example on a page we have a button that parses text coming in.ġ. Most of this was from the following Xlinesoft User forum Thread On Click – Triggers the sweet alert success routine and once that is complete triggers the hidden savebutton code.Īnd also if you find the Sweet Alert modal size too small add this to your page css. Javascript OnLoad Event – Hides the real save button Next navigate to the Events tab in PHPRunner and expand the table or view to which you added the additional button.īehind the Javascipt OnLoad event add the following code $('a').hide() // Hide button "Save"Īnd on the Client Before Event of the new button add the following code How can we add code to a project to make bespoke adjustments?įirstly navigate to the form you wish to add a special sweet alert to and insert a Custom Button. In PHPRunner as of version 10.51 the sweet alert javascript library is included in PHPRunner generated web applications.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |