Theme:
v
SQL DLL Features

Other pages of interest:

SQL is a C# ActiveX DLL which gives any APL+Win (or Dyalog APL, VB6 or C#) developer direct and full easy access to MS Access and SQL Server databases.

This page lists the SQL© product features.

SQL Features

SQL includes properties, methods and events allowing you to programmatically:

For SQL Server Databases:

  • list all existing SQL Server databases on the system
  • create a local SQL Server database
  • create a remote SQL Server database
  • create new tables in an SQL Server database
  • open an SQL Server local database
  • open an SQL Server remote database
  • close an SQL Server database
  • list all Tables contained an SQL Server database
  • list all Columns or all Columns from a given Table in an SQL Server database
  • retrieve all Primary Keys from an SQL Server database
  • retrieve all Foreign Keys from an SQL Server database
  • retrieve all existing Relations in an SQL Server database
  • retrieve the number of records in SQL Server database tables
  • get detailed Columns descriptions from an SQL Server database
  • perform any SQL query on an SQL Server database
  • perform any SQL non query on an SQL Server database
  • add data to an SQL Server database in an APL oriented way (i.e. fast bulk insert of a nested matrix of data)
  • update data in an SQL Server database in an APL oriented way (i.e. fast bulk update of a nested matrix of data)
  • add Relations in an SQL Server database
  • add Primary Keys to an SQL Server database
  • drop an SQL Server database
  • drop an SQL Server table
  • remove a Relation from an SQL Server database
  • change the “nullable” property (NULL/NOT NULL) of a given Column
  • check if an SQL Server database exists
  • return the name of the currently opened SQL Server database
  • complete error handling system allowing you to display errors in MessageBoxes or thrown them and handle them in APL
  • list all Stored Procedures contained in the databaseNew
  • get the T-SQL code of any Stored Procedure saved in the databaseNew
  • programmatically add a new Stored Procedure to the databaseNew
  • drop any Stored Procedure from the databaseNew
  • run a Stored Procedure that does not return a resultNew
  • run a Stored Procedure that returns a scalar resultNew
  • run a Stored Procedure that returns a result setNew
  • get the list of parameters that a given procedure requires, with their characteristicsNew
  • create and run stored procedures that run other stored proceduresNew
  • get and display the list of all servers visible from your computerNew
  • get and display the list of all SQL Server databases with their logical names, physical names and full pathsNew

For MS Access Databases:

  • support for .mdb and .accdb MS Access databases
  • list possible connection strings for MS Access databases
  • add a column to an existing MS Access database table
  • add data to an MS Access database in an APL oriented way (i.e. fast bulk insert of a nested matrix of data)
  • close an MS Access database
  • list all Columns or all Columns from a given Table in an SQL Server database
  • compact an existing MS Access database
  • drop a table from an MS Access database
  • drop a column from an MS Access database table
  • perform any SQL query on an MS Access database
  • perform any SQL non query on an MS Access database
  • returns a list of linked tables in the MS Access database
  • retrieve the number of records in MS Access database tables
  • open an MS Access database
  • retrieve all Primary Keys from an MS Access database
  • retrieve all existing Relations in an MS Access database
  • list all Tables contained an MS Access database
  • update data in an MS Access database in an APL oriented way (i.e. fast bulk update of a nested matrix of data)
  • return the name of the currently opened MS Access database
  • complete error handling system allowing you to display errors in MessageBoxes or thrown them and handle them in APL