Search Dosnt Restart From Beginning

[Ritesh]

Quote:

set @ctryID = 'gt';

set @statID = '11';

set @clncCity = 'GT01NUM1';

SET @CLINIC_ID = CONCAT(@ctryID,@statID, UCASE(LEFT(@clncCity,2)), IF(ISNULL(MAX(clinics.clnc_ID)), '01', LPAD((RIGHT(MAX(clinics.clnc_ID),2)+1),2,'0')));

Put the above text in the editor. Put the cursor at the end. Ctrl+F and search for clnc. Wont find. Put the cursor at the beginning and do the same. Finds it.

[peterlaursen]

Yes, we will add a prompt when the search reahes the end that gives user an option to start again from the beginning.

We will try to add this in 6.06 or 6.1

[Author]

Posts