Dear Mr.Rao,
First of all let me thank you for providing a very detailed explanation and guidance on the proper usage of xBrowse. You are a real master of xBrowse.
Many novice users of FiveWin, like me may not be aware of the proper usage of the FiveWin Classes and fail to extract/utilize the 100% power out of these classes.
I have very well noted all the points which you have suggested
I shall test your suggestion tomorrow morning.
I am creating recordset's columns dynamically based on the user's choice. For eg. the columns like ItemCode, ItemName will be the minimum columns in a recordset. After that the user has the choice to add columns further, for eg. Location1_Qty, Location2_Qty etc. . Based on the user's choice I generate the SQL statement dynamically and then the recordset.
On the XBrowse's oBar, further I give choice to the user via a DbCombo to choose to display either the stock quantity or the stock value and the recordset is further recreated. For this reason I have referred xBrowse columns by col number. After reading your suggestions, I feel that I should redesign the way I have written the code.
May I ask your advice. As I said above, I change the recordsets dynamically using the DbCombo on the xBrowse's oBar. When I change the contents of the recordset I loose all the column width settings, Column totals, oBrw:oSeek etc. and I have to re-do the settings again through a function. Is this the expected behavior or am I doing something wrong. The xBrowse is on a window and not on a dialog.
Regards
Anser