Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
driver limits amount of return
Arturas Gruodis
2020-10-23 08:34:38.0
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
Re:driver limits amount of return
HXTT Support
2020-10-23 18:18:36.0
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.


Re:Re:driver limits amount of return
HXTT Support
2020-10-24 00:51:02.0
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.

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Sitemap