Hi,

I'm trying to execute this SQL-Statement on a Pervasive SQL Database
with PHP.

SELECT VMDH.TXTYPE, VMDH.TXDESC, VMDH.NMBLABRDUR, VMDBHD.NMBLABRDUR
FROM VMDBHD INNER JOIN VMDH ON VMDBHD.NMDOCID=VMDH.NMDOCID WHERE
VMDH.TXTYPE BETWEEN 'C04027' AND 'P05011' ORDER BY VMDH.TXTYPE

If I leave out the "order by"-statement everything works fine.
But if I add "order by" it only shows the first two columns
(VMDH.TXTYPE, VMDH.TXDESC) which contains text.
It shows me the heading of each column but not the values of the last
two columns which contain numbers.
What is wrong with this statement?
The datatype of the last two columns is BCD.

After further testing I think it is PHP which causes this error.
I don't know....