Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot format database insert in Word
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00762688
Message ID:
00762745
Vues:
15
I believe you could avoid the problem if:
1. copy table to txt delim with tab, and then
2. insert the txt file into word


>I would appreciate some insight...
>I have inserted a database into a word doc, which is working fine. It is 4 columns (3 text and 1 amount field). Problem is, the amount field will not display cents when there are zero's and it drops the decimal also. Any ideas?
>
				
>.property number. .description.   . cost . .serial number.
>   112131		           438.	
>   112132		           438 3	
>   112133		           438.03	
>
>
>This is what displays, the first record should be 438.00 and the 2nd 438.30. It is displayed based on selections in the "insert database wizard", which has no cell format options. This is the syntax for that insert. I used the periods to format the width of each cell because I could not figure out another way other than building the whole page in script, which we do not want to do because we have no one else that has the knowledge to maintain it if it broke or needed modified.
>
>{DATABASE  \d "R:\\Finacct\\TestPropNum\\memodata.dbf" \c "DSN=FoxPro Files -
>Word;UID=;PWD=;SourceDB=R:\\Finacct\\TestPropNum\;SourceType=DBF;
>Exclusive=No;BackgroundFetch=No;Collate=MACHINE;Null=Yes;Deleted=Yes;" ;
>\s "SELECT nproperty as '. Property Number .', descrip as ;
>'.                             Description                             .', ;
>acqcost as '.    Cost  .', serialno as '. Serial Number .' ;
>FROM memodata.dbf ORDER BY `nproperty`" \l "2" \b "63" \h}
>
>
>Thanks, Chuck
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform