Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cast Syntax
Thanks for the reply. I'm using v11.00.247. Table A2 of the help file included with the Pervasive Control Center lists money as a relational type (the column heading is Relational Data Type); Money does not appear at all in table A1, so it is possible it isn't supported at all. Decimal(6,2)...- WinePaul
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
Cast Syntax
The statement should be simple, but it's getting bounced. The database has the cost in pennies. I would like to put out a report that has the cost in dollars and cents. It starts out with (cost/100), but that some time comes out as 4 instead of 4.00, or 4.1 instead of 4.10. All I should have...- WinePaul
- Thread
- Replies: 2
- Forum: Pervasive: Pervasive.SQL
