Posts Tagged ‘database’


PrimalSQL 2015: What’s New?

Monday, May 4th, 2015 by David Corrales
The release of PrimalSQL 2015 (v4.1.41) introduces some changes and new database providers.   Updated Database Browser The Database Browser was overhauled so that it will load the database piecemeal instead all at once. As a result, the schema will always be displayed in the database browser tree. When you expand a schema node for the first time, it will build the metadata for the specific schema only, thus reducing the demand on the server.     New Database Providers Support for following database providers was added: PostgreSQL Sybase Oracle Native Provider   When creating a new connection, visual cues…   More »

Feature Peek 2011: Queries and Grids in 1, 2, 3

Wednesday, May 19th, 2010 by David Corrales
A new feature in PrimalForms 2011 is the Database Browser which makes creating queries in PowerShell GUIs as easy as 1, 2, 3: Click here to view a video of the Database Browser!  1. Create a Database Connection or open an existing connection Fig 1: Create New Database Connection button 2. Use the Database Browser to drag a table you wish to query onto the Form Designer. It will automatically create a grid and the necessary code to fill the grid. Fig 2: Drag the Table or View in the Designer to create the grid with query script. 3. Call…   More »

Database Scripts with PowerShell

Sunday, May 4th, 2008 by Don Jones
 Did you know that PrimalScript 2007 Professional and Enterprise can produce database-connected Windows PowerShell scripts? At least, the new service build (566) for these products can! Just open your Database Browser (select it from View > Browser Windows if it isn't visible; by default it's on the right-hand side of the code editing window, once it's made visible), right-click to create a new database connection, and use the GUI to connect to any kind of database. Then, right-click a table to generate a script using the database wizard. You'll get complete boilerplate code that maps to YOUR database schema -…   More »