Hello,
we are trying to excute the query with hibernate and yuor driver from dbaseIII.
It seems it return not all records. We have more than 1000 records, but it returns only 265-302 records, but no more. Maybe there is some kind of limitation?
select
studyentit0_.StudyInsta as col_0_0_,
studyentit0_.StudyDate as col_1_0_,
studyentit0_.StudyTime as col_2_0_,
studyentit0_.StudyDescr as col_3_0_,
patientent1_.PatientNam as col_4_0_,
patientent1_.PatientID as col_5_0_,
studyentit0_.AccessionN as col_6_0_,
seriesenti2_.Modality as col_7_0_
from
DICOMStudies studyentit0_
inner join
DICOMPatients patientent1_
on (
patientent1_.PatientID=studyentit0_.PatientID
)
inner join
DICOMSeries seriesenti2_
on (
seriesenti2_.StudyInsta=studyentit0_.StudyInsta
)
order by
studyentit0_.StudyDate DESC,
studyentit0_.StudyTime DESC limit 1001
|
Yeah.
Differences between the trial version and the licensed version: .
The trial version of the driver is available to use free for a 30-day trial period.
The trial version of the driver allows executing not more than 50 queries once.
SELECT queries return the first 1000 rows in the result set.
|
Yeah.
Differences between the trial version and the licensed version: .
The trial version of the driver is available to use free for a 30-day trial period.
The trial version of the driver allows executing not more than 50 queries once.
SELECT queries return the first 1000 rows in the result set.
|
Main
webmaster@hxtt.com