|
THIS SECTION IS UNDER REVIEW 12.1 Setup the dBASE Programme. Setup a file with a "PRG" extension with a line for each file as follows:- APPEND FROM [filename] TYPE SDF 12.2 Create the dBASE file. Create a dBASE file having same structure as the template file as follows: - 12.2.1 Drawing Index FIELD NAME TYPE LENGTH DWGNO CHARACTER 8 REV CHARACTER 3 TITLE1 CHARACTER 25 TITLE2 CHARACTER 25 TITLE3 CHARACTER 25 TITLE4 CHARACTER 25 SCALE CHARACTER 5 12.2.2 Instrument Index FIELD NAME TYPE LENGTH NAME CHARACTER 8 DWGNO CHARACTER 8 TITLE CHARACTER 20 FUNC CHARACTER 8 LOOPNO CHARACTER 8 12.2.3 Material List FIELD NAME TYPE LENGTH QTY NUMERIC 3 UOM CHARACTER 5 SCODE CHARACTER 8 DESC CHARACTER 55 12.3 Import the Data Into The dBASE File. Start dBASE and use the appropriate data base file. Run the appropriate programme file. This will add the data from the ASCII text files. 12.4 Generating Reports. Create a report form for the dBASE file and print out the data in the desired format.
|