| Subject | Simple SELECT statement not working Firebird-2.5.0.26083-0_Win32 |
|---|---|
| Author | RDS |
| Post date | 2010-09-15T18:36:10Z |
1. I'm using Firebird-2.5.0.26083-0_Win32 on Windows 7 OS.
2. For an existing record in table a PATIENTCHARGESDUES, the under mentioned select statement does not returns the exisiting record when i uncomment the line that compares field ENTRYTIME even on copy paste the field value. Rest all fields work fine. I've tried removing zeros event ie '15.9.2010, 20:40:06.674'
select * from PATIENTCHARGESDUES p where
p.SERVICEID='2300094' and
p.AMOUNT=2000 and
p.AMOUNT_BEFORE_DISCOUNT = 2000 and
p.HOSPSRVCDESC='OUT PATIENT' and
p.REMARKS='1x1800. ' and
p.DATEOFEXPENSE = '15.9.2010, 20:20:14.8230' and
p.ENTEREDBY = 'HISADMIN' and
p.ENTRYPC = 'NannuPC'
/*and
p.ENTRYTIME='15.09.2010, 20:40:06.674'
p.REGDID=:REGDID and
p.RECEIPTANTID=:RECEIPTANTID;*/
3. Any support, will please be much appreciated.
2. For an existing record in table a PATIENTCHARGESDUES, the under mentioned select statement does not returns the exisiting record when i uncomment the line that compares field ENTRYTIME even on copy paste the field value. Rest all fields work fine. I've tried removing zeros event ie '15.9.2010, 20:40:06.674'
select * from PATIENTCHARGESDUES p where
p.SERVICEID='2300094' and
p.AMOUNT=2000 and
p.AMOUNT_BEFORE_DISCOUNT = 2000 and
p.HOSPSRVCDESC='OUT PATIENT' and
p.REMARKS='1x1800. ' and
p.DATEOFEXPENSE = '15.9.2010, 20:20:14.8230' and
p.ENTEREDBY = 'HISADMIN' and
p.ENTRYPC = 'NannuPC'
/*and
p.ENTRYTIME='15.09.2010, 20:40:06.674'
p.REGDID=:REGDID and
p.RECEIPTANTID=:RECEIPTANTID;*/
3. Any support, will please be much appreciated.