![]() You probably read more soon from Xojo's blog, Marc Zeedar's magazine or Bob Keeney's blog, but here are some notes from me:įor Xojo Cloud gets an updated price list and will double RAM and bandwidth numbers and get more virtual CPUs. ![]() Or just email for a copy if you like to try. What do you think? Is this useful? Will be included in 5.1pr7 soon. This table can than feed a chart or be exported. This way we can easily collect data for a sales report into a new table. For the query we use SQL features like grouping by CustomerID and summing up the InvoiceTotal fields. This does create records in table SalesReport. MBS( " FM.InsertRecordQuery" "" "SalesReport" "SumSales♬ustomerID" "" "SELECT sum(\"InvoiceTotal\"), \"CustomerID\" FROM Contacts, Invoices GROUP by CustomerID" ) Than it will insert those as new records into the table ExportContacts. This will query the fields First, Last and Company from a table called Company in current file. MBS( " FM.InsertRecordQuery" "" "ExportContacts" "First¶Last♬ompany" "" "SELECT \"First\", \"Last\", \"Company\" FROM Contacts" ) So we can make a query and use result to create new records.įor that we got two new functions for next plugin version: FM.InsertRecord and FM.InsertRecordQuery. We combine a SQL select query with insert commands. Finally you can include calculations and join data from several tables. And we can do modifications like have source and dest use different field names. We can preserve the data type, so everything is not converted to text while copying. And those tables can be in different fields. Quickly copy lots of records We got a new idea on how to copy a lot of records from one FileMaker table to another.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |