# connect to ODBC data source named "Test" Here is a sample script to quickly connect to data source named text with ODBC, run a query and grab the result as JSON array of records: Of course these things are depending on what database you talk to and for SQL Server you would use CONCAT() function like this: CONCAT(FirstName, ' ', LastName) as FullName. (FirstName || ' ' || LastName) as FullName. And you can always put in static data as text, date or number or even use SQL functions like concating two texts like e.g. You may rename a column with AS command inside the SQL like e.g. If your field names contains special characters like spaces, please use \" when coding them, e.g. You may put in the field names in the query if you like to define the order or only pick a few fields. Once you are connected, you can run a SQL command with SQL.NewCommand and SQL.Execute and grab some records. You can alternatively check our help page for SQL.Connect to see how to put these parameters to connect into the connection string. You can use the GUI on each operation system to enter the credentials and store them there, install required driver or set whatever parameter is needed. This means you define in ODBC control panel on macOS, Windows or Linux to define an ODBC data source. Let us show you a script to connect to a data source by its name used in the system. ODBC itself can of course be used for many more here. Since MBS Plugin supports CubeSQL, Centura SQLBase, DB2, DuckDB, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase as data source, we can help here. You have a SQL data source and you like to get JSON from it inside FileMaker to pass that JSON on to a web services or DATA API? Or you have a SQL source and you like to move records from it to FileMaker easily? Or other direction? Moving data from ODBC to FileMaker via script
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |