Home » Categories » Solutions by Business Process » SQL |
SQLDET Database Structure |
Article Number: 110 | Rating: Unrated | Last Updated: Mon, Jun 12, 2023 at 2:45 PM
|
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.
|
Attachments
There are no attachments for this article.
|
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
|