Recent content by dynamicjourney2001

it gpf'd on me

Hello guys, does anyone have some 'how to' documents on starting a Powerbuilder distributed? I appreciate your help in advance Dynamic

I believe you are trying to pupulate your variable based on the selected row for those 3 columns. You can use a.GETITEMSTRING variable1 = this.GetItemString(row,'col2') variable2 = this.GetItemString(row,'col4') variable3 = this.GetItemString(row,'col6') or b.dot notation variable1 =...

I believe you are trying to pupulate your variable based on the selected row for those 3 columns. You can use a.GETITEMSTRING variable1 = this.GetItemString(row,'col2') variable2 = this.GetItemString(row,'col4') variable3 = this.GetItemString(row,'col6') or b.dot notation variable1 =...

SOrry, i forgot to mention that, there's only one row, the dw is freeform and with scroll since the dw has alot of columns to hold. I believe I mentioned scrolling to proper column, sorry if my question is not clear. Im trying to use the Tab key and when the column is below the height of dw, it...

Hi, Im wondering how come a datawindow doesn't scroll to the appropriate column position when using Tab Key. I tried running our other system and it seems to be working. But when I created a datawindow with lengthy columns and when I use tab key to navigate thru columns, the datawindow doesn's...

Hi, You could place an expression in the Visible property of the fields you wish to hide other than first page. if(getrow() = 1 , 1, 0) Have fun!

Hi, thanks for the reply. I figure-out how to accomplish it without using a UNION keyword. And yes it was on my task, actually Im using the query for my Powerbuilder datawindow object. I used the inline view method in accomplishing it. Thanks again. Have fun!

Hi, I want to display a blank row when my query returns 0 result. i have accomplished this using a UNION clause, Select col1 from table where col1 = 1 Union select '' where not exists (select col1 from table where col1 = 1) but Im curious on how it could be handled w/o using a union...

thanks, I found it also in winuser.h I appreciate the reply. have fun!

Thanks for the reply, but can you show me how you came up with these decimal numbers? and where it was found?

You can check-out BackColor property for the CheckBox. Have fun!

Hi, you can define the sorted columns in the datawindow painter menu Rows>Sort , or you can use ORDER BY keyword in your Query. Hope this helps. Have fun!

Try to add single quote on as_time for scenarios 1 and 2 just like what you did in as_date eg. '"+as_time+"' and also check if the passed argument as_time is in a valid time format. Hope this helps. have fun!

Hi, When the user clicked the button, definitely that's a clicked event. There are systems events and user events(lookup 'event' in Help file). There's no way of getting the event in a string format as far as I know. Just curious, what exactly do you want to happen in your program? Have fun!