Now the redirection button is done, we have to configure the receipt of the redirect parameter on the grid, on the “SQL” option on Scriptcase, and we will do a where and declare the variable with the redir made on the form, which was transformed into a global variable. Initially we will have a button to redirect the form to the grid, with the parameter passing the orderid field. The macro sc_apl_conf is used when we need to change an application proprieties, for example, open a form in addition mode or change the number of row from a grid dynamically. The sc_redir macro is commonly used when there is a need to make a redirection from one application to another. In this example we will use both macros to redirect from a form application (using the ‘order’ table) to a grid application (using the ‘order_detail’ table), we will use the sc_redir macro to call the grid application passing the primary key as parameter to filter the grid application, and we will the sc_apl_conf macro to change the grid application to set it to show an specific number of lines per page.

You can check the full list of macros at this link Scriptcase has more then 150 created macros to help you to insert your own business rules. * Optional: Makes the sample page fill the window.Macros on Scriptcase is the same as in any other programs, it is a saved sequence of commands or keyboard strokes that can be stored and then recalled with a single command, it is the same as a function from PHP. * Always set the map height explicitly to define the size of the div Sc_lookup(ds,'SELECT latitude,longitude,first_name,surname FROM staff WHERE active=1') My code looks like this: $LatLong = array()

I have tried rtrim and trim, and neither work, but they do take the value right off of the end of the whole result, if that makes sense?Īpologies in advance if this is incredibly simple! I cannot get my head around how to remove this. It works perfectly, however throughout the generated array, it automatically places a comma at the end of every line.

I am essentially selecting multiple fields from the database, preparing them using json to be placed inside a function for a Google Maps API (latitude and longitude, firstname and surname for description). So hopefully somebody can help.įirstly, I am using scriptcase, although this shouldn't matter as I am using a blank application and the only scriptcase macro I am utilising in my code is a database lookup, as you will see.

I have an issue which has been causing me a headache for a few days and is probably a really simple fix for somebody with a bit more knowledge around json data than me.

Scriptcase macro collapse tab