implode(’, ', array_values($insert_fields)). This option can be found inside the Application menu of in the default toolbar, and it is also possible use the shortcut F9. implode(’, ‘, array_keys($insert_fields)). Saves and execute the application that is opened in the edition mode. $check_sql = “SELECT poid, styleid, colorid, dimid FROM tblPODetail WHERE poid = ‘’” It has 7 detail records, but only the first is processed, then it goes on to the next checked header record. Right now it only processes the forst detail record it findsĮX: HEader record 123 is checked. I have a run button of a grid for the header records.įor the records I select, I want to find all the detail records and insert new records in another detail table. I have a header table with detail records. ![]() Sincerely “ambiguous” solutions would be a bit annoying and time-consuming for the user, because it just so happens that a user might have forgotten to “copy” other records and insert them immediately after the copy of the background, without leaving by app. I have to log out or a macro to redirect (sc_redir) in another application. The system copies the selected ones selected records and copied in Step 1. ![]() Now, the application remains open and copy other records (for the second time), of course, different from those copied in Step 1. I run the application, and I select the records you want to copy in “table1” through its checkbox, then I click on the “Run” button and successfully copies the record … It states that the application runs after a user login and then through the security module created from the “Forms”> “Security” as Type: Application. Sc_exec_sql("INSERT INTO table1 (idtable1, field1, field3, field4) SELECT Null, field6, field8, field10 FROM table2 WHERE idtable2 IN ".$to_copy) The configurations in the “table2” are as follows: To copy the records selected through the relevant checkbox, in another table: “table1”. In a grid which extracts the data in a MySQL table “table2” I added a run button as indicated here. I’m posting this request because I can not understand, and to find a solution about this problem: I hope I have looked for good, in the forum, before posting this request, but I had not found anything in my case, otherwise I apologize right now. Passionate about PHP programming and SQL as an alternative hobby … ![]() My name is Michele from the low Friuli Venezia Giulia - Italy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |