Search results for query: *

you can try this link, https://training.sap.com/shop/sap-search/certifications?q=powerbuilder .

I was able to figure it out. I just did a dot notation of the ancestor's user object. uo_parent luo_object long ll_tabix if message.stringparm='E' then luo_object[ll_tabix].cb_1(clicked!) end if

Hi, I have a main window object (win_a) with a tab control in it. On runtime, this tab control will have a tabpage (a userobject). I would like to access the user object's event. I am not sure if this will ever work so I did some testing. On the response window close event, I added...

I was able to fix this by the way. The reason why IE crashes is that aggregates are not supported, which I got reference to the documentation. The datawindow I used have aggregate functions on the columns like sum( #x for all ). For the workaround, I created dummy columns in the SQL Select...

Hi Everyone, I would like to ask for help regarding my issue. IE browser crashes with a message like this "Unexpected error was thrown, the browser will be closed! Please report the error to the administrator. Error:'dw.gobs.computed_field1' is null or not an object." This happens every...

Please delete this thread. I was able to figure it out. Thanks. [bigsmile]

Hi Guys, I would to know if it is possible to count specific values of a column for multiple tables. Count function works okay using single table like the one below: select materialno, count(materialno) as qty from dbo.TBL_CONTRACT (nolock) where right(contractno,8) = '40178291' group by...

Thanks, Matt! That's what I did and I also tried putting all the needed dlls in the system32 folder and it also worked. No more problems for now. :)

Hi All, I experienced an error message "cannot find pbvm105.dll" when I tried to deploy an app on a client PC. I thought that it can be fix by installing the PB Runtime Packager (PBCLTRT105.msi), but I was wrong. The dlls are already on the directory C:\Program...

Hi All, I am trying to create a simple user monitoring app and it is getting a distributed communications error 52. I am just following a script I found online that I think might help. I added a question mark on each line that I think I need to fill correctly (which I think the cause of...

I was able to figure this one out, finally. Here's what I did, in case you guys are interested (specially the PB newbies like me). I created a datastore and reference the same database table as data object. Then I used: dw_valid.SetSort ("columnA A") dw_valid.Sort() dw_valid.SetFilter...

PB reads it as null. it returns 0 when I did AscA (badchar). unless you modify the text file before upload manually to get rid of that horizontal tab non-printing character. If manually removed, it will finally display the rest of the data. this is really weird.

thanks, Matt. I have tried it as "IF AscA (badchar) = 009..." but still no go. that is what Ultra Edit displayed in Hex Mode of the text file, it seems to be a horizontal tab in a fixed width formatted text file. It seems like PB does not read the rest of the data after that horizontal tab...

thanks Matt, for the reply. I tried that before: SELECT dbo.trimmer (:ls_trim) from dbo.trimmer INTO :ls_col054 USING SQLCA; it gave me a syntax error.

I found an MS SQL function that might fix the problem (http://sqltrim.codeplex.com) but I don't know how to invoke a user-defined MS SQL function in PB. I tested the function in MS Query Analyzer, it works but this needs to be tested while uploading the test files. Can someone also teach me on...

Hi Everyone, I need your expertise again. :) Here is the problem, Column displays blank or NULL as data after update. the raw data comes from a fixed width formatted text file. the current code for this by the previous programmer is invoking the trim function below: ls_col054...

Sorry it took me a while to reply. I will follow your advises. :)

thank you for replying thekl0wn. yes, it might be a table issue. I found out that it will the data from a staging table (template table with seq_no as unique identifier). on getting the valids and dups, the seq_no will not be included but a field/column (serial_no) will become the primary key...

Hi Everyone, I am here again in need of your help. I am currently assigned to do a maintenance of another module. The last one, I was able to do some work around. This time it is totally different. Here is the scenario, this module uploads one of more text files and checks on duplicate...

Hi Guys, This is the first time I will create a menu at runtime, and I don't know where to start. I was thinking of creating on a menu based on the contents of a datawindow. this datawindow contains the window name, username, access rights etc. After creating the menu, this will be...