Then Scriptcase had enough of my tweaking (and perhaps also of my twerking) and crashed like I explained. My previous working UNION statements took their data from the same database (so, there was no need of the variable), but this time, I needed to get in a GRID, the info of separate tables from separate databases, so I needed to use a INNER JOIN and my variable. Then again, It worked surprisingly good, untilвЂ¦ This time, I created a workaround using the Scriptcase connection variables and a session variable like this (as a reminder, stores the database name of the connection) : = substr(, 0, strpos(,'_')) ДЄnd then, I use the session variable in any inner join query. This, again, works as intended: my client is happy and so am IвЂ¦ at least before deploymentвЂ¦ That because my working evironment uses my databases named according to my domainname (and so I wrote it in the INNER JOINs), but on deployment they have another name. INNER JOIN mynewdom_warehouses.myOtherTable As T2 On T1.col3 = T2.col3 The only thing you might see is that, as I canвЂ™t use two databases for a scriptcase connection, in my queries I explicitly name the database of a table, like this: SELECT I managed to work around those issues by using inner joins, unions and the вЂњconnectionвЂќ parameter of many scriptcase macros. The problem arises when my clientвЂ™s requirements ask for this:ДЎ.- Get a report combining information of myclien_finance and myclien_warehouses together, for exampleДў.- DonвЂ™t mix data from different databases at mysql serverД«y requirement 1, I build some complex queries including INNER JOIN and UNION statementsД«y requirement 2, on the other hand, I canвЂ™t create views or modify the databases so I have one single sc_connection (I know, I know, ItвЂ™s kind of unefficient, but thatвЂ™s what they wantвЂ¦)ДЄnyway, this was not a big deal before. This is not a problem as I can execute queries in a database different as the one used for the app connection (using the third parameter of sc_lookup вЂњConnectionвЂќ). The catch is this: My clientвЂ™s requirements ask me to keep the data stored in 4 diferent schemas (say myclien_projects, myclien_finances, myclien_humanresources, myclien_warehouses). My clientвЂ™s hosting handles the same way the database names. If my domain name was, then my databases would be something like mynewdom_database1. I work on a shared hosting service provider that asigns the database schemasвЂ™s name (MySQL DATABASE) tied to the hosting name. Finally I ended up with something odd, for what I have to elaborate about my query: Since I had no useful debugging information (as the error was at saving time, I wasnвЂ™t even able to build the app nor to execute it), I tried to simplify my query and вЂњcomplexвЂќ it step by step. I practically donвЂ™t know a thing about PDO implementation and behaviour on PHP, but if the query works, how Scriptcase handles the queries? DidnвЂ™t it only take the result of the PDO execution of the SQL on the server? Why is Scriptcase crashing with a working query, even when it supports the UNION structure?

I tested my query and it works, but when I use it to create a Grid app, scriptcase crashes even the saving process (a pop up shows up and It looses any field in the app)

INNER JOIN myOtherTable AS T2 ON T1.col1 = T2.col1ДЄFAIK, the first statement returns only 3 columns, as well as the second one. I want to create a grid with a MySQL UNION sentence of two SELECT statements, but one of them has some INNER JOIN statements and explicitly retrieves the same type and amount of columns something like this: (SELECT I have a running grid with a MySQL sentence that unites a single constant row with a regular select statement somehitng like this: (SELECT

Scriptcase grid application