I've created a treeview datawindow with 3 levels. The original highest level that gets set in the initial painter is fine, but when I create the second level, those values end up repeating. I've tried Rows/Suppress repeating values and selected the second level column, and the values still repeat. As an example, let's use individual columns for YEAR, MONTH, and DAY. Year would be level one, Month level two. My treeview will show 2021 at the highest level, then will have 31 rows of "01" for January and 28 for February, etc. There's got to be something I'm missing. I want it to show 2021 and then the next level should only have 12 items (Jan - Dec). My data isn't this exactly, just using this as an example that's easy to follow.
Kevin
--------------------------------------------------------------
1. In text mode: I write SELECT * FROM whateverTable
2. Then I convert to graphic mode
3. Then I convert back to text mode:
Result: the "Select * " has been replaced by SELECT with all the column names, which is how it should be.
regards
Just remember that if you develop your SQL in "Syntax" mode - your "locked in" to that DBMS. If you develop your SQL in "Graphics" mode, the PB runtime will adjust the SQL at run time to support your app running dynamically across various DBMS vendors at execution time. One of the "Power's" of PowerBuilder. FWIW: I only use Graphics mode wherever possible. ;-)
Food for thought. Just my $0.02
Regards ... Chris