![]() ![]() I tried a lot of things, but had no success. ![]() Parse error : syntax error, unexpected ‘INTO’ (T_STRING), expecting ‘)’ in /opt/NetMake/v9-php73/wwwroot/scriptcase/… ![]() However, as I run the calendar application I get the following error: Sc_exec_sql(WHERE id=(SELECT max(id) FROM ProjCalend)) These queries can be saved for later use. 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. Grid SQL configuration SQL Select Statement It allows you to define the primary SQL of the application. sclookup (Dataset, 'SQL Command', 'Connection') This macro executes a SELECT command stored in the second parameter and returns the data in a variable. Home applications grid application SQL SQL SQL Settings This interface allows configuring the related database settings, such as the SQL statement, the used database connection, case sensitive, and others. Sc_exec_sql(SELECT id,title,description,event_color,category,start_date,end_date,start_time,end_time, calend_all_day,creator,creation_date_time FROM ProjCalend) This tool helps the construction of Queries in a Wizard form. Firstly you need to select the connection (Database) that you want to use. This macro execute SQL commands passed as parameter or a SQL command in the SQL field action type. Sc_exec_sql(INSERT INTO ProjCalendHistory VALUES (id,title,description,event_color,category,start_date,end_date,start_time,end_time, calend_all_day,creator,creation_date_time)) Then, I went to onAfterInsert event into the calendar and added the following functions: I want to have a function what will make a copy of all recent added events added to the calendar into another table, named ProjCalendHistory that is a perfect clone of ProjCalend. I have a calendar application and the table that keeps all events is named as ProjCalend ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |