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 derfloh 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. tabhijit

    Please help create an auto increment primary key in a table

    Hi Push, This can not be done using PB but do it using database utilities and while designing dw to add/update/delete records, select column as identity column in properties of datawindow. Regards, Abhijit.
  2. tabhijit

    Databaseconnections

    Hi, You can have many transaction objects pointing to each database respectively. But just make sure that it is not impacting performance. If you want many transaction object ( say > 10) then create only few of them as global transaction object apart from SQLCA and rest can be created and...
  3. tabhijit

    Export using SaveAs method(datawindow)

    Hi, This can be done only if no. of columns and type of columns (and probably sequence too) are same in both dw. Add one additional computed column to both dw. Set value = 1 for first dw and set value = 2 for second dw. //copy all rows from dw_2 to dw_1 dw_2.RowsCopy...
  4. tabhijit

    DataStore

    Hi, You can get values from datastore as you get value from datawindow. e.g. variable = datastore.object.column [index] or variable = datastore.getitemString (index,"column_name") for further details please go through the help of getitemString or getitemNumber or getitemDate etc. Get value...
  5. tabhijit

    Datawindows

    Hi, Just check with sybase support. Probably you need to apply patch. Regards, Abhijit.
  6. tabhijit

    how to force the db to use an index

    Hi Larry, The query seems ok. Remove order by if included in query and use datawindow sort function to sort recordset. When you use order by then index is not used. Please let me know if it works. Regards, Abhijit.
  7. tabhijit

    date function exclude weekends

    Use daynumber function. Cheers, Abhijit.
  8. tabhijit

    Datawindow expression for rownumber

    Hi, Create Compute column and set values starting from 1. Use FindGroupChange function to get row num where group is changing. Reset counter and start from 1 again. Do While ll_Counter <= ll_RowCount ll_Counter = 1 ll_GroupChange = dw_control.FindGroupChange (ll_Counter,level)...
  9. tabhijit

    How to select values in dropdown using keyboard

    Hi Lalit, Keep the column editable and try to type 121 and press down key. 121 will be selected. Regards, Abhijit.
  10. tabhijit

    diff between declare procedure and RPCFUNC

    Hi all, We have migrated our application from PB8 to PB10 and oracle client from 8.4 to 9.2i. What we observed that the procedures which are declared using declare procedure syntax behave inconsistantly in PB10. Some of them work fine, some of them fails but all of them work fine with PB8...
  11. tabhijit

    Performance issue in PB10

    Hello everyone, We just now migrated our application from PB8 to Pb10. Our application have 2 databases. 1) Oracle 2) SQL Anywhere which is available on every PC. Data is cached in local database when application starts. We have one function which performs below operations. 1) check all...
  12. tabhijit

    store datas between two database

    eri, Try following steps : 1) Have 2 transaction objects. 1) Retrieve rows from one database. 2) Change status of all rows to newmodified!. 3) Change trasaction object and point to another database. 4) Update. Let me know if it works. Regards, Abhijit.
  13. tabhijit

    Upgrade from 7 to 10. How much effort?

    mbalent, I encountered problem while migrating one object which was having external function. Rest all objects successfully migrated and were automatically updated. Regards, Abhijit.
  14. tabhijit

    Color picker (Eyedropper)

    blktoptrvl, You can open paint using OLE object but I am not sure that you can choose color picker as default. As default I guess you will get cross-hairline. Regards, Abhijit.
  15. tabhijit

    Treeview - Beginner

    blktoptrvl, You can send it to me at abhijit.tambe@polaris.co.in. Regards, Abhijit.
  16. tabhijit

    Jesus Campos

    Get reference of sub report using getchild and use .object properties to get value of computed field. Regards, Abhijit.
  17. tabhijit

    Can PB doing scan job?

    dex, No idea. but you can try by calling appropriate API functions. Search for API in MSDN and try your luck. But lot of questions are unanswered such as 1) How will you capture the output ? 2) How will you store it ? etc.
  18. tabhijit

    Stored procedure on report

    Dear A0C61ZZ, Have u tried export and import option ? Export dw. Edit the srd file manually and import it back. Regards, Abhijit.
  19. tabhijit

    Treeview - Beginner

    Edders, Look at the help of treeviewitem. It demonstrate how to insert an item into tree view. Regards, Abhijit.
  20. tabhijit

    data window grouping

    nspagnuolo, Try FindGroupChange function. Keep increamenting level argument somewhere the function will return 0 or -ve number. That is the maximum level of grouping. Regards, Abhijit.

Part and Inventory Search

Back
Top