hi u can use saveas method of datawindows to export as excel sheet . or if required formated output use pbtoxls.dll freely avilable for powerbuider . best...
Hi Everyone, I have a situation in datawindow retrieve. Need your help. Ex. NAMES John Smith Michael The display should be: NAMES John, Smith, Michael I've...
Hi....anybody have an idea how to refresh/update drop down datawindow data automatically without to exit the window and restart the process again. I want the...
Refreshing means Retrieving..  Just call dwc1.Retrieve(arg1, arg2, etc.) in the appropriate event.  Happiness Always BKR Shivaprakkash ... From: aziella80...
You can use Getchild method From the help : DataWindowChild state_child integer rtncode rtncode = dw_1.GetChild('emp_state', state_child) IF rtncode = -1 THEN...
BKR Shivaprakkash, thanks for your respond.. Actually, the situation is let say I have: a) WINDOW-A to key in lookup data table, such as country code.. b)...
Hi Everyone, I have a situation in datawindow retrieve. Need your help. Ex. NAMES John Smith Michael The display should be: NAMES John, Smith, Michael I've...
What you are talking about is PUSHING data to other windows. The easiest way to do that is to have an NVO that keeps a pointer to the objects that will have...
If it works in SQL then just change the SQL of your datawindow to be that which works. Note that there is a maximum number of characters for each datatype, so ...
... You can use getchild to make a manual retrive, at the moment you need like on itemfocuschanged event or itemchange.. or even on window get focus.....
You can achieve this also by using OpenUserObjectWithParm. I had done this years back where in 2 windows are open.. double clicking the row in the other window...
LIST aggregate function is not supported in Ingres. It simply cannot be done in SQL. But i've tried this one and it works. Added a computed field in the...
pb10.5 MSWord Version 11 I have a problem with the TypeText command shown below whereby some the string data that is represeted by the variable ls_letter_data...
I have never worked with Ingres, but if you can't do it in straight sql, datawindows can have stored procedure datasources so why don't you build your list in...
I have that thought already. I've tried that one and I did made storec proc. But unfortunately, Ingres ODBC has "bugs" and powerbuilder crashes when using...
Well, then use a standard datawindow and get the data in rows. Then in the pfc_postretrieve event you run through the data, create your string in a script, and...
Thanks so much Olan! ?This site recommended using the .InsertAfter command instead of the memory limited TypeText command and it solved my problem.?Thanks...
Hi guys, Hope All of you doing gr8.After so long time i am posting some message the issue is quite strange. I have a Datawindow from sybase Stored Procs. from...
Datawindows have to interact with the print drivers to render print preview, and get page counts. The machines with the problem could have no printer...
Hello, Using PB 10.5 SQL Server 2000 I want to retrieve data in a datawindow by executing a stored procedure, which accepts 3 parameters, one of which is a...
Good day to all. I've got a datawindow with a group. With this datawindow I want to have a button on the Header Group. This button is used to modify the height...
Hi there. You can use Number array retrieval argument. Select a.name, b.code From Table A Join Table B On a.column1 = b.column1 Where a.column1 = 'A' ...
Thanks for your reply. This site gave me a good solution for the problem. http://www.sommarskog.se/arrays-in-sql-2000.html#iter-list-of-integers Happiness...