Hello!
I am facing a persistent challenge where the "rowid" column is consistently excluded from the column iterations in RichClient. This exclusion forces me to use less straightforward methods to handle it, which complicates my code unnecessarily. Here’s how I currently iterate through the columns:
This setup omits "rowid" from the listing, making it difficult for me to handle database structure and field types as seamlessly as I'd like. To work around this, I have to "smuggle" "rowid" back into the mix, which overcomplicates what should be a straightforward task.Code:Public Sub TellCols(ByRef uCn As cConnection) Dim nDB As cDataBase Dim nTbl As cTable Dim nCol As cColumn For Each nDB In uCn.DataBases For Each nTbl In nDB.Tables Debug.Print "Table: " & quote(nTbl.Name) Debug.Print "Cols: " For Each nCol In nTbl.Columns Debug.Print vbTab & quote(nCol.Name) If IsEqual(nCol.Name, "rowid") Then Debug.Assert False'This line is never hit End If Next Next Next End Sub
Does anyone have insights on why "rowid" might be omitted or advice on how to include it in the iteration without resorting to cumbersome workarounds? Any suggestions for a more elegant solution would be greatly appreciated.
Thank you!




Reply With Quote
