Search results for query: *

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.

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

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

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

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

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.

Use daynumber function. Cheers, Abhijit.

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)...

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

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

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

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.

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

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.

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

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

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.

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

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

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.