"Hamburg" ) See also sertRecordCSV - Feedback: Report problem or ask question.
Filename parameters can be empty.Get(FileName) SQL Statement SQL Statement as a Text string Params Optional Pass here parameters.With plugin version.2 or later, you can specify fields and table via IDs and the plugin will lookup them for you at runtime.One parameter to this function for each parameter you want to pass to the SQL statement.Does not copy text styles, only plain text for text fields.Get(FileName) InsertTableName The name of the table to insert record into."Model" QueryFileName The file name for the database to run the query against.CustomerID stomerID group by CustomerID" ) Copy two fields from one table to other: MBS( " sertRecordQuery "ASC Apple Script "NameScript "select * from "AppleScript Copy from Anlagen example (in German) to copy of same file: MBS( " sertRecordQuery InsertFileName "Anlagen2 InsertTableName "Anlagen FieldNames "Abschreibung.In the SQL you can use functions for sums or join data from several tables together to fill a new table.Links MBS Xojo Plugins.Inserts a lot of records queried from a database.Also from one table to other or within a table."Assets" FieldNames A list of field names for the insert.
Table IDs and table names must be unique across all open files for this to work correctly.
Can be empty to look for the table in all files.
Please remove from SQL statement and field names all fields which are globals or unstored calculations.Not client, old, guides, examples, new in version:.18.104.22.168.0.1.2.3.4.5, statistic.Using tsqlbatchMode you can let the plugin insert.g.MySQL please use sertRecords function.Description Inserts a lot of records queried from a database.50 rows in one chunk which can speed up insert a lot.Use stErrorMessage and stError to see error message.Reports an error if field name list doesn't match column count of the query result.Due to passing in new field names, you can even rearrange values from one column to other while copying.
For inserting records from other database (e.g.
Empty entries in the list are ignored.