Recent content by sunset

Yes, this worked...note that each column in the second half of the select had to have an 'as' to match the first half of the select... . . UNION ALL SELECT 'Comment' as action_code, 'Comment' as action_comments, "TRSY"."TYUCMNTS"."CREATE_USERID" as action_emp, etc etc Thanks again...

Hi all. Looking for assistance. I have a dw which was built in PBv6.5 (back in '98) which uses a union. Fast forward to today (PBv12.1)where I am modifying the dw to add a new timestamp field to two of the tables in the union; I actually do not get any errors, but in the 'column...

Can anyone tell me if there is a limit to the number of rows retrieved on a datawindow retrieve? Or a size limit?

Hi folks. I am currently working with an application built with PB7, lets call it App 'A', which incorporates another PB application (built with PB6 using PFCs and makes calls to c++ program), lets call it App 'B', which retrieves and displays images. My task is to replace the image...

Hi all, I am using PB7 with embeded SQL to update a large DB2(Ver7)table on IBM mainframe. After running sql/script, I have been able to verify that the update of up to 58k records was indeed successful, but my script, which is to return the count of updated records returns either -7454 or...

When users perform certain activities on application on W95 pc, the application behaves as expected (specifically, user can press ENTER key in lieu of mouseclicking on buttons set up as default buttons.) However, when on W2000 pc, users cannot press ENTER key (in lieu of mouseclicking on...

I am currently testing an application built with PB7 and the users are seeing something strange. Users are working with one of two windows (tiled within an mdi, but both are viewable) on the screen and while in the 'active' window, users can work with the column fields to enter wage data, but...

I am working in an mdi and the main sheet (window1) normally takes up the whole window. User has option to make a selection from a menu in which a second window (window2) displays on the mdi and both are visible (arrangesheets with Tile!)....It is preferable that window2 display to the...

Have you looked into the HorizontalScrollPosition property? I had the same problem a while ago, so in my setrowcol function I set this property to 1 when I needed to be at the left side of the datawindow and set it to HorizontalScrollMaximum property (which I set into a variable earlier on in...