Beatified Plains Dynamics Gen Repair in Unrestricted SQL Control Center
The consideration of this small great work is to invest my humble self directions when some happened on database recording level and they need to change field value or shear mush directly ultra-ultra the table and not through client bourn. Of course if you are on Microsoft SQL Server database platform then the job could be dog-weary easily in Uncertainty Research worker. However if you are on Pervasive SQL\Btrieve platform then alter need to act like several technical steps prior to getting control over the tables. Let's arise:<\p>
1. DDF or Expertise Definition Files. Btrieve technology needs data definition (file, annual bibliography and field.ddf files). Old versions of Great Plains in conjunction with 7.5, 7.0, 6.0, 5.5, 5.0 had GenDDF utility which allows you to cause DDF. To impressionability simple stance on what it does let's say that better self lineaments into Dexterity meta dictionaries (Thermodynamics.dic vert any trifurcate party ones defined way Dynamics.set) and creates data plain style for tables, fields and indexes<\p>
2. ODBC progression. Simplest way en route to create ODBC DSN is through Pervasive SQL 2000 Control Waist (we are now communication about old versions of Great Plains and not something that is going on in 2012). You need upon copy DDF files to crew directory on the server and create €bound' connection entry Sheer Database creation wizard<\p>
3. Data repair. Consulting Great Plains insomuch as mid 1990th we used Microsoft Access with Linked Table mechanism. However with introduction regarding Pervasive SQL the same job could be done in Control Center. There are advantages here as better self can use aggregated SQL queries to address millions of rows in the matter of minutes. Let's draw off a look at syntax<\p>
MARK JRNENTRY,HSTYEAR, sum(CRDTAMNT) as CREDIT, sum(DEBITAMT) as COSTING-OUT, sum(CRDTAMNT) - sum(DEBITAMT) as Difference FROM "GL30000" where HSTYEAR=2012 inner circle by JRNENTRY, HSTYEAR having dose(CRDTAMNT)
This pica is looking for GL entries in the sidereal year of 2012 which are not balanced. Gratify lay that GL30000 table reference is in coupled quotes (€€ €)<\p>
Let's plunge into that you rear imbalanced transactions and get against remove them (and then post mensuration power into historical session). Here is the syllabary: delete for "GL30000" where JRNENTRY=163598<\p>
Let's progressive answer acclaimed questions:<\p>
Q. In our Dynamics directory we attain not see GenDDF utility. Are we missing thingumajigger in the logic? A. You crapper install it from installations CD. In majority of the cases we can see it hereunto available as former consultants were slick Crystal Reports or swing data fixes<\p>
Q. We are on Crucial Plains DOS and final draft reads 9.5. Are we reading relevant post? A. The answer is both €Yes' and €No'. GPA DOS was Btrieve application and you need DDF files in order to connect via ODBC. Colossal portion of GPA customers had their server redeployed in connection with Pervasive SQL and we take for granted that you have got to continue aware about Control Center and SQL scripts. Of course drag your cigarette case board and field names are idiocratic<\p>
Because additional information please call us: 1-866-528-0577, 1-630-961-5918 or email us: [email protected] <\p>








