Please see code below:
dsLCM is Data Source
sSQL is string = "SELECT DISTINCT T_PRODUCT.CategoryManagerName"
sSQL += " FROM T_PRODUCT"
sSQL += " ORDER BY T_PRODUCT.CategoryManagerName ASC"
IF HExecuteSQLQuery(dsLCM,hQueryDefault,sSQL) THEN
FOR EACH dsLCM
ListAdd(LIST_Category_Managers,NoCharacter(dsLCM.CategoryManagerName,"""",sscAll)) // Add to list box
END
ELSE
Error("Load_Category_Managers failed.", HErrorInfo(hErrMessage))
END
HFreeQuery(dsLCM)
9 times out of 10 it runs in milliseconds. It decides 1 time out of 10 to take 30 secs to run. I cannot figure out why?.
Has anyone seen this and what would the resolution be?.
This is concerning me less these days as my patience with HFSQL has worn very thin.
I am trialling SQLite. No issues, queries are very quick.