Home » Categories » Solutions by Business Process » SQL

SQLDET Database Structure

Datafile Software

SQLDET Database Structure

Two new data items can be added to the SQLDET.DFD file that will record the program and the parameter number which generated, together with the existing (Premier only) options to record the user-id, date and time the SQLDET record was created this allows for a basic logging procedure of changes made within Datafile Databases (although it only logs that a change was made not what the change was).

 If restructure the SQLDET.DFD you can add the following items:

Item No Item Name Item Type

156 PROGRAM X (8)

157 PARAMETER X (8)

Note that items must be created exactly as above – same item number, name and type.

In addition the SQLDET.DFD will be automatically expanded, subject to product level database size restrictions, as it becomes full so that manual expansions of this file are no longer required.

 

Custom Fields
  • Release ID: 6.4
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Datafile SQL Configuration
Viewed 1875 times since Thu, Jul 5, 2012
SQL Out
Viewed 2081 times since Thu, Jul 5, 2012
Database Refresh - Empty Table and Re-Import Data
Viewed 2284 times since Mon, Jun 11, 2012
Datafile SQL Monitor
Viewed 2099 times since Thu, Jul 5, 2012
Update Individual Records to SQL on Nominal Update
Viewed 2638 times since Fri, Oct 26, 2012
Additional SQLDET.DFD Maintenance Options
Viewed 8935 times since Mon, Jun 11, 2012
Running the SQL Manager
Viewed 2226 times since Thu, Jul 5, 2012
SQL In
Viewed 1967 times since Thu, Jul 5, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4208 times since Fri, Jul 21, 2017
Suspend SQL Mirroring During Night / Weekends
Viewed 1922 times since Fri, Oct 26, 2012