Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot format database insert in Word
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Cannot format database insert in Word
Miscellaneous
Thread ID:
00762688
Message ID:
00762688
Views:
43
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
Extreme Programming = Plan -> Design -> Code -> Test
Next
Reply
Map
View

Click here to load this message in the networking platform