Search results for query: *

Hi Matt, Originally the data comes from a DDW which is used on this argumetn selection window. On the argument selection screen the data type is String (30) - initial value '%' - in the drop down data window Char (30) and in the SQL table that column is Varchar (30) On the DDW I can't...

HI, I have a report and to run that on an argument selection window can be the filtering option selected. One argument is a drop down datawindow gathing names from sql tables. When I select a name from that list I got an error msg thet: "Item 'XXX' does not pass validation test." ion't kow what...

HI, I use PB version 8.0.3 This field is in the Footer part... And this is from the source code - but here I try to retrieve from an sql database..: ------------------------------- column=(type=char(1000) updatewhereclause=no name=contact dbname="Contact" ) Thx the help in advance..

It is on a DW, and yes I tried many ways, like increasing the width of the taxt field, but as I know if I make it tighter the text will be cut into more rows...so I made it wider and heighter as well..but always cuts the text at the same charachter...

HI, I still have the problem with displaying a long string in a text field (box) ...I have at least 500 character long string which I would like to display..but when I put it into a text field it displays only around halfe of it..about 256 char...how can I make it show the full string in one...

I have PB 8.0.3

HI, My problem is that if I want to display a long string on the datawindow in a text field it always truncate it after a length ( I would guess it is 256 char?) .. My question is, can it be extended to display the whole long string? I couldn't find any option for this. Thx the help in advance.

HI, I have a SQL table which helds a long string(more then 256 chars). When the SP retrieves the string on the report I can see only a part of the string not the whole. The variable is defined in the PB as string (1000). In the Query Analizer when I selected that table for the string first it...

Hi, I have a DW which is retriving an SQL table's column. I can scroll down and up in the DW but I want to add the option if I press i.e. letter "p" then it scrolls to the first row which starts with that letter. I used keydown() command to identify the pressed button. And as the scrolltorow()...

Hi, here is the SQL, both part of the IF produces a !?result set?!(don't know how) at the second run....BUT if I use BEGIN - END on the ELSE part select in Query Analyzer then it works properly! But PB doesn't recognize the BEGIN word so I can't use BEGIN - END...how could I replace that?: If...

HI, My problem is that one of the DW gets data from an sql query result. I use if..else in it but somehow both part runs (the if and the else part as well...) I run the script in Query Analyzer and by using BEGIN ..END on the ELSE part it worked and retrieved only once the result...BUT my...

HI My problem is, I select a bacnh of info from an SQL server into a datawindow and I wanted to sort them by name BUT there is a difference between the order of alphabetic order in SQL and PB. In SQL the '-' sign comes before chars but in PB it is coming after the characters. In the query I...

HI My problem is, I select a bacnh of info from an SQL server into a datawindow and I wanted to sort them by name BUT there is a difference between the order of alphabetic order in SQL and PB. In SQL the '-' sign comes before chars but in PB it is coming after the characters. How can I have...

Hi, The problem is there are 4 users for a PB apllication. There is an option in the application to send reports via Lotus Notes. But 2 of them can't send mail and the error message is: Name not found accessing external object property title at... As I checked in the code it has a failure...

Hi, There is a report page and it has a DB2 query which retrieves the information from DB2 tables and using some paramaters in the query which is gotten from a previous screen. My problem is, the 1st variable gets only 1 parameter, but it occured that I would need to search by more value. The...