pcsoft.us.windevCopyright 2026, PC SOFT24 Feb 2015 13:03:00 Z24 Feb 2015 06:32:00 ZI am trying to retrieve data from DB and populate it in a Looper using following code: dsMyData is Data Source sSQL is string bRetCode is boolean I is int //Variables to store Student info for Populating Looper nStudentID is int sStudentName is string sStudentNum is string bIsPresent is boolean nStudentDivID is int sStudentDivName is string IF COMBO_SubjectType = "Optional" THEN //Means Optional Subject sSQL = "SELECT DISTINCT sm_id, em_serial_no, sm_fname, sm_lname, em_div_id, div_division_name FROM student_master AS sm INNER JOIN enrollment_details AS em ON (sm_id = em_sm_id) INNER JOIN div_master ON (em_div_id = div_id) WHERE (em_std_id = " + COMBO_Standards..StoredValue + " AND em_sub_id = " + COMBO_Subject..StoredValue + ") ORDER BY em_serial_no;" ELSE sSQL = "SELECT DISTINCT sm_id, em_serial_no, sm_fname, sm_lname, em_div_id, div_division_name FROM student_master AS sm INNER JOIN enrollment_details AS em ON (sm_id = em_sm_id) INNER JOIN div_master ON (em_div_id = div_id) WHERE (em_div_id = " + COMBO_Division..StoredValue + " AND em_std_id = " + COMBO_Standards..StoredValue + " AND em_sub_id = " + COMBO_Subject..StoredValue + ") ORDER BY em_serial_no;" END bRetCode = HExecuteSQLQuery(dsMyData,hQueryDefault,sSQL) IF bRetCode = True THEN IF HNbRec(dsMyData) > 0 THEN HReadFirst(dsMyData) I = 1 Info(HListItem(dsMyData,hLstAll)) FOR I = 1 _TO_ HNbRec(dsMyData) nStudentID = dsMyData.sm_id sStudentName = dsMyData.em_serial_no sStudentNum = dsMyData.sm_fname + " " + dsMyData.sm_lname bIsPresent = True nStudentDivID = dsMyData.em_div_id sStudentDivName = dsMyData.div_division_name Info(nStudentID,sStudentName,sStudentNum,sStudentDivName) //<=== Code works till here but after this line gives error //Add to Looper LooperAdd(LOOP_StudentPresenceData,I) LOOP_StudentPresenceData.ATT_StudentID = nStudentID LOOP_StudentPresenceData.ATT_StudentName = sStudentName LOOP_StudentPresenceData.ATT_StudentNum = sStudentNum LOOP_StudentPresenceData.ATT_StudentPresent = bIsPresent LOOP_StudentPresenceData.ATT_StudentDivID = nStudentDivID LOOP_StudentPresenceData.ATT_StudentDivName = sStudentDivName HReadNext(dsMyData) END //FOR i = 1 _TO_ HNbRec(dsMyData) END //IF HNbRec(dsMyData) > 0 THEN ELSE //IF bRetCode = True THEN Error("Error ",HErrorInfo()) END //IF bRetCode = True THEN But...but... is does not work. It gives the error No browse was initialized. I have been banging my head for last 2 days trying to get this code up and running without success. I am using SQLite as this is an Android app as back end. Can someone please help here... TIA Yogi Yang30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50653/read.awp24 Feb 2015 13:03:00 ZHello Yogi I appreciate you say it doesn't work using the read loop but putting a for/end loop in place is not the way to try…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50653/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50653/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50652/read.awp24 Feb 2015 12:59:00 ZIsn't your for-loop running 1 too many, because you already start with a hreadfirst? FOR I = 1 _TO_ nTotalStudents should be …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50652/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50652/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50651/read.awp24 Feb 2015 12:45:00 ZArie, That is right. In fact I build my queries using SQLite Manager tool which allows me to build queries and test them. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50651/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50651/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50650/read.awp24 Feb 2015 12:32:00 ZYogi Yang, I sometimes test a query in a separate sqlite tool or viewer to see if it returns records. Apart from WM, because it…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50650/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50650/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50649/read.awp24 Feb 2015 12:22:00 ZIf I use the For Loop like this nTotalStudents = HNbRec(dsMyData) IF nTotalStudents > 0 THEN HReadFirst(dsMyData) FOR I = 1 _TO…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50649/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50649/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50648/read.awp24 Feb 2015 12:11:00 ZICI, I tried is like this WHILE HOut(dsMyData) = False nStudentID = dsMyData.sm_id sStudentName = dsMyData.em_serial_no sStu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50648/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50648/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50643/read.awp24 Feb 2015 07:50:00 ZYogi . If hNbRec() return more then 0 the you have your data, THEN use or WHILE() or FOR (dont combine it) You don't need "I"…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50643/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50643/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50642/read.awp24 Feb 2015 07:43:00 ZI don't think so because this WHILE code is also not working WHILE NOT HOut(dsMyData) //Do your thing HReadNext(dsMyData) END …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50642/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50642/read.awpWM17 - no browse was initializedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50641/read.awp24 Feb 2015 07:14:00 ZHi Yogi Not sure but my guess would be that the loop To HnbRec(dsMyData) is clearing the buffer so the HReadNext fails I wou…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50641/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50640-wm17-browse-was-initialized-50641/read.awpWM17 - no browse was initialized