PowerBuilder Questions

  1. Rating: +1

    Positive Negative

    What will happen if you pass extra retrieve argument to the datawindow retrieve () function when the datawindow is expecting some argument?

    Powerbuilder ignores extra arguments.

  2. Rating: +0

    Positive Negative

    What would be the row status in the destination datawindow when a row is copied from another datawindow using rowscopy() function?

    Newmodified

  3. Rating: +0

    Positive Negative

    I would like to allow the user to print selected rows how it can be done?

    Have a hidden datawindow control or a datastore and assign the same datawindow object that you are using to display on the window. Copy selected rows to the datastore or the hidden datawindow control and prints the datastore or the hidden datawindow control.

  4. Rating: +0

    Positive Negative

    You have deleted few rows say 10 rows from a datawindow and update the datawindow. How many rows would be available in the deleted buffer after successful update?

    zero rows

  5. Rating: +0

    Positive Negative

    How do you change the default datawindow error message title?

    Assign the application object's 'datawindow message title' attribute with the new datawindow error box title.

  6. Rating: +0

    Positive Negative

    Assume, you have marked a field as 'Required', At run time user tabs into that field and tabs out with out entering a value in that field. Will powerbuilder force the user for specifying a value? If not, how do you force the user for specifying the value?

    No powerbuilder will not force the user to enter the value. The solution for this problem is, call FindRequired() frunction before update the datawindw.

  7. Rating: +0

    Positive Negative

    When two datawindows are shared what exactly would be shared and are there any restrictions?

    The presentation is not shared. The data is shared. There are few restrictions, which include, crosstab datawindows can't share data, the client and the server in the distributed computing mechanism can't share data.

  8. Rating: +0

    Positive Negative

    Say, you have a datawindow which returns 10,000 rows, after retrieving few rows, say, 100 rows, you have decided not to retrieve the rest of the rows. Explain different methods of canceling the result set.

    You can call dbcancel() function form any where OR you can return 1 in the RetrieveRow() event.

  9. Rating: +0

    Positive Negative

    Say, you have a datwindow with two fields emp_name, emp_address. Now, the focus is on the emp_name field. When the user press tab, what would be the return value of GetColumnName() from itemchanged event and itemfocuschanged events?

    GetColumnName() returns emp_name from itemchanged event and emp_address from itemfocuschanged event.

  10. Rating: +0

    Positive Negative

    Explain the steps that are required to update a multiple table datawindow?

    Using modify function or dot notation, you have to make one table updatable and set the primary keys for that table. Then update the datawindow with FALSE argument for the reset option in the update() function. After successful update, make the second table updatable and first table not updatabl and set the primary key of the second table. Now call update() function with TRUE for the reset option. Commit after successful update and rollback on unsuccessful update.

  11. Rating: +0

    Positive Negative

    If the NULL value is set to the sort criteria using SetSort() function and Sort() function is called then what will happen?

    powerbuilder will promt for the sort criteria at run time.

  12. Rating: +0

    Positive Negative

    A datawindow has a field with DDDW edit style and there are 1000 rows in the parent datawindow, Now if given a retrieve command then how many times the child datawindow will retrieve the data?

    Only once.

  13. Rating: +0

    Positive Negative

    What is command/function that you use to select a row?

    SelectRow() function.

  14. Rating: -1

    Positive Negative

    If there are 10 rows selected in a row, and if you call DeleteRow() function, it will delete all thase selected rows?

    No

  15. Rating: +0

    Positive Negative

    What will happen when you pass a wrong argument to the modify() function?

    Returns the Error message, but doesn't trigger any event such as dberror or error at the datawindow control.

  16. Rating: +0

    Positive Negative

    Explain the error "Rows changed between retrieve and update', also expalin solution for this?

    This error is reported when somebody updates the data before you update the data. We can't avoid this error. The solution to this problem reset the row, which caused the error using ReselectRow() function and display appropriate message.

  17. Rating: +0

    Positive Negative

    Explain the steps involved in inserting your a layer between 'transaction' object and 'SQLCA'.

    Create a standard class user object by inheriting from 'Transaction' object. Define the attributes and functions that you need. Now, make the SQLCA to inherit from your new transaction user object instead of 'Transaction' object.

  18. Rating: +0

    Positive Negative

    Expalin the method to skip printing the pages that are divisible by 7?

    In printpage event, check whether the pagenumber is divisible by 7, if so then return 1.

  19. Rating: +0

    Positive Negative

    Can we use the value passed in the retrieval arguments in the datawindow or not?

    Yes, we can.

  20. Rating: +0

    Positive Negative

    Can I store some data in the datawindow object? If yes, How?

    Yes, select rows/data from menu in datawindow painter during design mode and add data to the datawindow and save the datawindow.

  21. Rating: +0

    Positive Negative

    Explain the method to avoid the retrieve the data automatically from child datawindow?

    Store an empty data in the datawindow object.

  22. Rating: +0

    Positive Negative

    What is the difference between a datawindow and datastore?

    Datastore is nothing but a datawindow, which doesn't have interaction-related events and functions.

  23. Rating: +0

    Positive Negative

    Can we write event scripts in datastore, If yes then explain how?

    Yes, Create a datastore using standard non visual user object by inheriting from datastore and write the necessary event scripts in this user object. In the program create a datastore using this user object.

  24. Rating: +0

    Positive Negative

    What is the difference between computed column and computed field?

    Computed column is a column that is defined as part of select satement. These values are calculated by the database and sent to the powerbuilder client. Computed field are defined in the datawindow bands and powerbuilder calculates these values in datawindow not from database.

  25. Rating: +0

    Positive Negative

    You have a datawindow that has 100 rows. I want to append the rows to the existing rows when I retrieve next time in that datawindow. Explain the required steps to do this.

    Return 2 in the RetrieveStart event

  26. Rating: +0

    Positive Negative

    What is the event from which I can see the exact SQL statement that is being sent to the database by powerbuilder?

    SQLPreview

  27. Rating: +0

    Positive Negative

    Is it possible to declare an instance variable for a datawindow control only, in a window?

    No

  28. Rating: +0

    Positive Negative

    Which is the model window?

    Response window

  29. Rating: +0

    Positive Negative

    What will happen when you trigger a non existing event?

    If you trigger a non existing event using the old syntax TriggerEvent(), nothing happens. In the new syntax , you can't trigger a non existing event.

  30. Rating: +0

    Positive Negative

    What is the difference between triggerevent() and send()?

    TriggerEvent() just executes the specified event's script, but it do not really trigger the event. Send() function executes the script and also trigger the event.

  31. Rating: +0

    Positive Negative

    what is the difference between close and closequery event?

    Closequery event will trigger before close event. If closequery event's script is not executed successfully, close event will never trigger.

  32. Rating: +0

    Positive Negative

    Expalin different debugging mechanisms in powerbuilder.

    using debug painter 2. Trace flag to log all the ODBC calls 3. PBDEBUG to log the powerbuilder script execution

  33. Rating: +0

    Positive Negative

    Assume update statement in an embedded SQL statement updates 10 rows. What would be the value of SQLCODE?

    0

  34. Rating: +0

    Positive Negative

    The UPDATE statement in an embedded SQL script did not update a single row. What would be value of SQLCODE?

    0

  35. Rating: +0

    Positive Negative

    Which variable returns the number of rows affected by a SQL statement?

    SQLCA.SQLNROWS

  36. Rating: +0

    Positive Negative

    Specify the function, which is used to cancels the current datawindow query?

    DBcancel()

  37. Rating: +0

    Positive Negative

    Which is the ancestor to the SQLCA?

    Transaction

  38. Rating: +0

    Positive Negative

    How many times the SQLPreview event is fired when a datawindow has three nested datawindow reports.

    1

  39. Rating: +0

    Positive Negative

    Assume a datawindow has 100 rows and the cursor is on row number 10. Now, you scroll to row number 25 using the vertical scrollbar where the cursor will be/?

    10

  40. Rating: +0

    Positive Negative

    What is the row status when a row is inserted using InsertRow() function.

    New

  41. Rating: +0

    Positive Negative

    What is the row status when a row is added using ImportString()

    NewModified.

  42. Rating: +0

    Positive Negative

    What is the datawindow row status after a row is retrieved from database and changed ?

    DataModified

  43. Rating: +0

    Positive Negative

    What statement powerbuilder sends to the database for a row with newModified! status?

    Insert

  44. Rating: +0

    Positive Negative

    What statement powerbuilder sends to the database for a row with DataModified! status?

    Update

  45. Rating: +0

    Positive Negative

    What statement powerbuilder sends to the database for a row with NEW! status?

    NONE

  46. Rating: +0

    Positive Negative

    What is the function that returns the row status?

    GetItemStatus()

  47. Rating: +0

    Positive Negative

    What function returns the row and column that is required and contains a null value?

    FindRequired()

  48. Rating: +0

    Positive Negative

    Which function is used to find the next occurrence of a specified string in a DataWindow?

    Find()

  49. Rating: +0

    Positive Negative

    Which function is used to find the next occurrence of a specified string in a RTF presentation style DataWindow?

    FindNext()

  50. Rating: +1

    Positive Negative

    Which function is used to find the next modified row?

    GetNextModified()


Question:
Email: 1

1 - Notification of when your question has been answered. (Optional)