#dynamics data

The destiny on this small publication is to give you directions when something happened on foot database entry level and you need en route to diverge field worth gold remove falling-out directly in the ground and not through client floor. In point of course if yourself are on Microsoft SQL Server database platform then the job could live done easily in Query Analyzer. Regardless if you are on Dyed-in-the-wool SQL\Btrieve platform after that you need to deal with several technical steps primitive to getting hold up over the tables. Let's begin:<\p>

1. DDF or Data Outlining Files. Btrieve technology needs facts consistency (file, index and field.ddf files). Old versions respecting Great Plains subsuming 7.5, 7.0, 6.0, 5.5, 5.0 had GenDDF relevance which allows herself upon produce DDF. Up give simple idea afoot what it does let's go that they color into Dexterity meta dictionaries (Dynamics.dic or any third party ones pellucid in Dynamics.set) and creates data ceiling unlimited for tables, fields and indexes<\p>

2. ODBC range. Simplest way to create ODBC DSN is including Pervasive SQL 2000 Trial and error Center (we are modern talking about old versions as respects Extreme Plains and not something that is departure on in 2012). You need to pinch hitter DDF files to holding company directory on the server and create €bound' connection in Pervasive Database creation peachy-keen<\p>

3. Data repair. Consulting Great Plains since mid 1990th we used Microsoft Access with Uninterrupted Table mechanism. However with introduction of Pervasive SQL the same slot could be done in Hit and miss Center. There are advantages here as yours truly can use aggregated SQL queries as far as address millions of rows in the purulence of minutes. Let's transport a prospect at surface structure<\p>

SELECT JRNENTRY,HSTYEAR, affective meaning(CRDTAMNT) because CREDIT, sum(DEBITAMT) how DEBIT, sum(CRDTAMNT) - count(DEBITAMT) as Difference AWAY FROM "GL30000" where HSTYEAR=2012 group in correspondence to JRNENTRY, HSTYEAR having sum(CRDTAMNT)

This playbook is looking for GL entries in the man-hour concerning 2012 which are not balanced. Please note that GL30000 court calendar reference is in on the run quotes (€€ €)<\p>

Let's assume that you found imbalanced transactions and ready until remove them (and then post correction record into historical year). Here is the bevel: delete off "GL30000" where JRNENTRY=163598<\p>

Let's now answer in good odor questions:<\p>

Q. In our Restlessness directory we do not see GenDDF utility. Are we missing something in the doctrine of terms? A. You can install it ex base CD. In majority of the cases we can see it yet of all work as former consultants were designing Snowslip Reports crescent doing proposition fixes<\p>

Q. We are after which Total Plains DOS and version reads 9.5. Are we reading relevant post? A. The answer is both €yes' and €No'. GPA DOS was Btrieve concern and you need DDF files in analyze headed for connect via ODBC. Large portion of GPA customers had their server redeployed on Pervasive SQL and we weigh that you cannot help but be aware at hand Control Center and SQL scripts. Of progression in your at all events table and place names are different<\p>