I have an Advantage Database and try to get the following code to work as a simple asp page:
Expand|Select|Wrap|Line Numbers
- SELECT
- f140.customer As CustomerNumber,
- f75.description AS CustomerName,
- f75.description2 AS Details,
- f42.description AS Branch,
- f140.masterpolicy as Masterpolicy,
- f140.policy as Reciept,
- f103.description AS Insurer,
- f145.description AS Category,
- f140.characteristic AS Characteristic,
- f140.issuedate,
- f140.effectivedate,
- f140.expdate,
- f140.canceldate,
- f140.grosspremium as Premium
- FROM
- fpotype f145,
- fcustomr f75,
- finscomp f103,
- fbranch f42,
- fpolicy f140
- WHERE
- f145.code=f140.category
- AND
- f75.code=f140.customer
- AND
- f103.code=f140.insco
- AND
- f42.branchcode=f140.branch
- and
- f140.agent=788
- order by customername
- ..
f140.grosspremium as Premium
It comes up as without formating as currency, any suggestions??
Advantage Database 7.1.0.10
Frontpage 2003
Thank you in advance
Anthony