Hi,
I have an INI file, contans a field with "RestrictedRead =100"
I am reading the INI file in my Java code and getting this restrictd value and building a query dynamically for further processsing as...
sSQL = sSQL + " TOP " + getRestrictReadValue() + " ";
PROBLEM
If I have 10000 records to be processed, as of now it is reading only 100 records.But I want after 100 records completed it should fetch next 100 and continue till EOF(10000) records...
Can anyone help me how to succeed this and how to form a query for this scenario.
Matter very urgent
Cheers
Ravi