Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. OperaMan

    Info

    The "Unleashed" series of books are generally pretty good. I would recommend going to http://www.amazon.com. (I don't work for Amazon - but I've ordered a number of PB books from there). Do a search on PB books in there. You should be able to see reviews and ratings for the top PB...
  2. OperaMan

    Excel style copy and paste

    I think the functionality that you're looking for is the Excel "Fill Down" or "Fill Right" functionality. In Excel, the contents of the "1st" cell are propagated to the remaining selected cells. I don't think that there are any built-in PB datawindow functions...
  3. OperaMan

    DDDW Filter

    You will firstly need to get a reference to the datawindow child. Here is example code for doing that from PB help (I've modified the names of the variables slightly, to more closely following PB naming standards). dw_1 is the main datawindow, and 'emp_state' is the name of the column in the...
  4. OperaMan

    Anyone knows how to remedy the erro

    You will need to be more specific. What version of PB? What DBMS are you using? Without the answer to those questions, I can at least tell you this much: This error usually indicates that another user has retrieved one or more of the same table rows that you have retrieved. The other user has...
  5. OperaMan

    Checkbox disabled

    You're likely already aware that the standard checkbox control has a property called "enabled". In a script it can be set as follows: cb_1.Enabled = TRUE Setting it to FALSE, disables the control, and thus does not allow the user to change its value (checking or unchecking). The...
  6. OperaMan

    Data Row Validation

    For future reference you will find that you will be more likely to get replies to your questions, if you supply as much detail as you can in your question (exactly the kind of thing most programmers would like from their end-users right?) Basic pieces of information to supply are what version of...
  7. OperaMan

    Dynamic SQL in Sybase

    Take a look at the Dynamic SQL FAQ I've just posted.
  8. OperaMan

    Execute a SQL statement that produces a result set in which the input parameters and result set columns are known at compile time.

    If you want to execute a dynamic SQL statement you will need to use the Dynamic Staging Area (usually SQLSA). Following are two examples of using the Dynamic Staging Area: Example 1 These statements associate a cursor named my_cursor with SQLSA, prepare a SELECT statement with one parameter...
  9. OperaMan

    How to get the compute field value while exporting dw into excel file

    When you do a saveas with Excel! as the file type, PB will only save the resultset from your datawindow query. That is why you don't get the computed values. As far as I know the only way to save "what you see" is to do a "SaveAsAscii". However, this will give you a .txt file...
  10. OperaMan

    Convert version 3.0 to version 7.0

    stevecal mentions some good points. Version 7 together with Jaguar can take advantage of n-tier architecture and offers the possibility to logically and physically partition your application (client/app-server/database-server). Frankly, I think there will be a world of hurt involved in migrating...
  11. OperaMan

    Can we do this?

    In NVOs (non visual objects) or CVUOs (custom visual user objects) the constructor event may either override or extend its ancestor's script. The default behaviour of any PB event is to extend (ancestor code is executed first, then descendent code is executed). If you are working in PB7, you can...

Part and Inventory Search

Back
Top