![]() ![]() ![]() ![]() It makes it easy to leave off the ‘where’ clause or the ‘order by’ clause. I particularly like the ability to highlight a query and click the execute button to run just the highlighted text. RazorSQL has a bit of documentation on this for FileMaker. Once you have all that set up, its fairly simple to configure a connection to your solution and start making queries. In addition to enabling ODBC in the FileMaker Server Admin tool, the privilege set you are working with needs to have the access via ODBC extended privilege enabled.įinally, your firewall needs to allow RazorSQL to connect to your FileMaker server on port 2399. For the remainder of this post, I’m going to limit myself to talking about FileMaker Server. If you are working with a standalone database, you can only connect from RazorSQL to your solution on the same machine. RazorSQL connects to FileMaker via the ODBC interface, so you have to have that enabled in your standalone solution or FileMaker Server. Once you have your query perfected in RazorSQL, you can then build it in FileMaker, knowing that you have the basic query correct. With regard to the last issue, RazorSQL is a nice tool for working directly with your FileMaker solution to very quickly test SQL code. ![]() On the down side, you have to be very careful about its impact on your application’s performance and building SQL queries in FileMaker’s calculation dialog is challenging. It can help keep your relationship graph simpler, allow you to query data without changing your context, and makes virtual lists easier to build among other things. The advantages and disadvantages of SQL in FileMaker are pretty well known. In the early days it required a 3rd party plugin, but since version 12 we’ve been able to run SQL Select statements against our FileMaker data with the native Execute SQL function. RazorSQL 6.0, an SQL editor, database query tool, database browser, and database administration tool, is now available.Developer’s have been able to run SQL queries against their FileMaker data for many years. Using RazorSQL, users can query, edit, browse, and manage all major databases from one tool. RazorSQL supports over 30 databases, examples of which include the following: PostgreSQL, Amazon SimpleDB, Apache Derby, DB2, Firebird, FrontBase, H2, HSQLDB, Informix, Intersystems Cache, JavaDB, MS Access, MySQL, OpenBase, Oracle, Pervasive, SQLite, SQL Azure, SQL Server, Sybase, Sybase SQL Anywhere and Teradata. Connect to other databases via JDBC or ODBC (Windows only). Users can also use the built in relational database engine for their database needs. Some of the main features contained in RazorSQL are visual tools for creating, editing, describing, altering, dropping, and viewing database objects such as tables, views, indexes, procedures, functions, and triggers tools for importing and exporting data in various formats such as MS Excel, delimited files, SQL insert statements, HTML, XML, and text a database browser for the viewing of database objects and structures search tools for searching for database objects and database data, tools for building SQL queries and generating SQL and DDL, a SQL formatting tool, SQL history tracking and and SQL favorites tool for storing frequently used SQL statements, and a robust programming editor and query tool with support for SQL, PL/SQL, TransactSQL, SQL PL, PHP, Java, XML, HTML, and many other programming languages that features tools for searching and replacing data, programmable macros, coding sidekicks for various programming languages, a file system browser, function and method browsers, and much more. New features in version 6.0 include database conversion support for PostgreSQL, MySQL, Oracle, MS Access, MS SQL Server, SQLite, and HSQLDB. Also included are conversion tools to easily copy tables and query results from remote databases to RazorSQL's local database engine for local development. Versions of RazorSQL are available for Windows, Mac OS X, Linux, and Solaris. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |