Search results for query: *

Hi there, I'm not exactly sure what it is you want, maybe post an example of what you are trying to achieve. However it does sound like you need to look at using the datawindowchild function? More info could help you get answers quicker. Cheers

Try setting the the value to null, for instance if your dddw data value is an integer do the following: int li_null SetNull(li_null) dw_1.object.dddw_name[dw_1.getrow()] = li_null Used this before but can't remember if it actually cleared the value while the user has not tabbed of it yet, but...

Sorry not using MS SQLServer, in fact using Firebird, plus I want to send an attachment in certain cases as well. Does anyone maybe know of a good website to read up on e-mail with PB (any version)? Thanks for the help so far though Matt. Cheers

Hi all, I wonder if someone can help me, I’m using PB10 and would like to send e-mail with an application I wrote but using MAPI is not good enough unless someone knows how to specifically tell the MAPI command that I want to use a certain account on outlook express as it seems to always look...

Hi Simon Thanx for the info, however windowstate only specify the initial state of the window in the script that opens the window. When the window is already open this command doesn't seem to do anything. Let's put it this way, I have a windows opened maximized inside a frame window, I click...

I'm using PB 6.5 and when I open 2 windows over each other. How do I maximize the one window when I close the other one with code. Does anyone know as I can't find anything in PB help. Thanx Tentacle

I have a numeric edit mask on my window with a spin control. However I can’t seem to find the correct event that executes every time a user clicks on one of the spin control up or down arrows. I want a text field to update with a value every time the spin control is clicked and the value is...

Hi all I think an example will explain my problem the best. I have the following SQL select statement: select (sum(sold) - sum(paid)) as duty from clients join sold on sold.client_id=clients.id join paid on paid.client_id=clients.id where clients.id=<whatever> The obvous problem is that if a...

If I understand you correctly you want to export a datawindow, make changes to the exported script and then re-import the changed script so that it will dynamically change your datawindw at runtime? Well if so, this is what I have done in the past to accomplish this. First create a .pbl file...

Hi all. I’m using PB 6.5 at the moment and have an application I wrote that need to shutdown Microsoft windows when I click the close button on my application. Does anyone know how to have windows shutdown automatically without asking the user whether they want to or not after clicking a button...

Give more information on what exactly it is you want to do. Sort what, group how and calculate which fields for instance. Plus you can’t use retrieval arguments on an imported file, your best bet would be to filter the information once it's imported. Also which version of PB are you using...

Try summing the total instead of counting them like so: cf_percent_total = sum(cf_percent for all) - in the footer band According to your example that should add up to 100%

Hi To get the total amount of records you need to enter the following in you computed field: count(cf_date_range for all) that should bring back 5, why your total is bringing back 16 could be because it is summing the totals and not counting them. Let me know if this solved your problem...

The easiest solution would be to place the following computed field in the trailer group for cf_date_range: count(cf_date_range for group 1) This should give you the total records per group, which you can then use to do your percentage calculation with. Let me know if this solves your...

You need to use the getchild() function. This provides a reference to a child DataWindow or to a report in a composite DataWindow, which you can use in DataWindow functions to manipulate that DataWindow or report. dwcontrol.GetChild ( name, dwchildvariable ) Where dwcontrol equals the name of...

I suppose there are many solutions to this problem; however my solution would be as follows: On your datawindow create a computed field called cf_date_range for instance. I take it from your question that you already have the age worked out, so let’s say you called it cf_age, in which case the...

Try the SecondsAfter function, it gets the number of seconds one time occurs after another. Syntax : SecondsAfter ( time1, time2 ) Then just devide by 60 for minutes and 60 again for hours... hope this helps

You could always use the timer function and event of PowerBuilder. Then all you need to do is make sure the window using it is open and start the timer as the window is opened. Then check in the timer event if a certain time you have specified has passed and if so call a function or something...

I'm using PB 6.5, and want to create an object or objects in a datawindow at runtime. In other words let's say I want to place 4 round rectangles on a datawindow (I have the x, y, height and width values of each) but they have to be created on the datawindow at run time and is not predefined on...

What you need to do is go to the SQL view of the datawindow and then click on the join. When the join window opens select the join that says: = table_1.user_id = table_2.user_id and rows from table_1 that have no table_2 This should fix your problem and still list data from the first table even...