Scriptcase insert sql3/4/2024 ![]() sclookup (Dataset, 'SQL Command', 'Connection') This macro executes a SELECT command stored in the second parameter and returns the data in a variable. Sc_exec_sql(“insert into table-b(Name,Date,Month,Year,Cb,Cbd)Įlse//in this query I want to insert data from a table-a with the amount of data 100, to the table-b but with repetition as much as $ x, year = $ yr with a different month figures. This macro execute SQL commands passed as parameter or a SQL command in the SQL field action type. Sintax: scexecsql ('SQL statement', 'connection')The parameter connection is optional. Note that is useful to insert, update and delete because you dont get the output. Sc_lookup(qdefault, “select Date,Cb,Cbd from table-a where person = ‘’”) Executing SQL statements (Insert, Update and Delete) With the macro macro scexecsql you can execute SQL statements. After selecting the desired connection, click the Confirm button to use this connection. It is important that you must have a connection created in the project for it to be listed in SQL Builder. ![]() Note that is useful to insert, update and delete because you dont get the output. Firstly you need to select the connection (Database) that you want to use. Executing SQL statements (Insert, Update and Delete) With the macro macro scexecsql you can execute SQL statements. ![]() The following is a script that I use in key processes With the macro macro scexecsql you can execute SQL statements. These queries can be saved for later use. I have difficulties to insert data into TABLE-B using existing data in TABLE-A and is repeated as many as the number of variables that exist. This tool helps the construction of Queries in a Wizard form. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |