![]() ![]() When I entered a table name where the fields did exist, the grid opened and displayed the data. ‘SelectLimit(SELECT field1 from table_without_these_fields, 12, 0)’. Appearantly the global variable is lost I start the container by a scredir to the container application. As soon as i put this app in a container it displays that it cannot find any record. Called from within the menu it works well. I got an error like ‘Error while accessing the database’. I have a global variable to show a form with a certain record. I was able to confirm it was working by entering a valid table name where the table didn’t have the listed fields in its structure (for example, ‘table_without_these_fields’). When I matched the case, it replaced the table name in with the variable. In this attribute we should define the name of the session variable, active in the previous item, that will receive the field’s value. I found that if I had the query as “… from Original_Tablename” but put “original_tablename” in the ‘Variable for Table’ field, then it ran the default query, so it is case sensitive. In this example the SQL is “SELECT field1, field2, field3 from original_tablename” and the global variable is I tested something similar to the image below and it seemed to be working. In the SQL tab, enter the global variable and original table names in the ‘Variable for Table’ fields. Pls can anyone help me I want to assign “any table” within the connected databse to a grid for report generation. In Application → Global Variables, is the variable set as ‘session’ or just as ‘post’ and ‘get’? Depending on how you navigate from the application that sets the variable to the grid that requires it, you might need to use ‘session’.ĭynamically assign a table to grid or form? Database Connections But it sounds like if this variable is not set, the grid won’t have the source table set, so I’m not sure that’s what you want. I have realy tried many options, but without succes. I have a ajax on click on field1 and I want to pass the content of field2 to a global which i can use in an other application. It shouldn’t prompt for missing ‘Out’ variables. In a grid I tried to pass the content of a field, other then the one with the ajax-onclick, as an global So i.e. If you want to directly open the grid in development and don’t want it to prompt for the variable, then in Application → Global Variables, set it as ‘Out’ instead of ‘In’. ![]() Are you directly running this grid using the ‘Run’ button, or are you running the form or control that sets the variable and then clicking a link in that application to open the grid? I assume this is in development, not production, because I don’t think it will prompt for missing variables in production. I’m not sure if I understand the question, because you say you are passing a variable that was already established before the grid opens, but also that you are putting ‘that in the onScriptInit and onApplicationInit’ events. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |