If I understand you , you want to keep the value FR00001, right? The solution I found was use 2 fields: one for data dddw (here you are going to filter) and...
PB displays displayvalue if it could find a record in dddw and datavalue if it could not find a matching record. In your case pb works fine.  Don't...
Hi All While trying to view the SQL of a datawindow I am getting an ORACLE error ‘ORA-00942 Table or View not found error’ initially and then the table...
Hi Sudhi, It may happen due to access restrictions on the table. Grant the full permission on the table using Oracle Synonyms and then try again. If the...
Hello, I could set a image data in a picture control using the command p_1.SetPicture(b_blob). Is there any way to clear the content of that picture control...
Hi, May be my subject is not clear enough. Let me ellaborate here. We are using PB 10.2.1 Build 9731. We are developing some MIS reports for our company. So in...
Hello BKR, Try pb_1.PictureName = "". I believe it should work. Best regards, George ________________________________ From: PowerObject@yahoogroups.com...
Hi Arif, If I understand you correctly, you need computed field expression for percent of division of a value in a given row by value in three rows upper. It...
Hi there, try this, 1. create a function (yourFunc) in your database to do 422/322*100 2. select acc_id, name, value, yourFunc as Percentage; 3. In dw,...
Hello George, Sorry, It's not working, which I've already tried.  Both  pb_1.PictureName = '' and pb_1.SetPicture('') are not working.  I tried passing...
Hello BKR, Do you really want to display PictureButton without any picture? May it make more sense just to make it invisible? Anyway, if you really have to...
Could it not be possible to make a blank picture and prompt it there? I mean, save the bmp or jpg with no image to your blob field then prompt it every time...
Hi All Thanks for your responses. George... Your logic will work only when i know that its always going to retrieve in the same order, but as mentioned in my...
The problem is after saving the picture along with the information about it, I need to clear that picture to allow adding more items (pictures).  That time...
hello arif , The problem u have metioned is interesting , I have tried it, in my opinion it would not be possible at the design time i.e the compute column...
Hi Rahul, Your logic works!!! no issues. But the project on which i am working is a very huge MIS reporting system. And i have a generic interface to display...
Thanks. It worked ... From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf Of Aswin Kumar Sent: Thursday, February 05, 2009 8:47 PM...
HI You might want to try SQL analytical functions. Thanks From: PowerObject@yahoogroups.com [mailto:PowerObject@yahoogroups.com] On Behalf Of aarif.shaikh ...
hi i am working on a pb9 application. i reuire to make on module of the application to web, can i use the exsisting powerscript code/functions and datawindow...
Sal, You have several options. The simplest one is to upgrade you PB9 application to PB11. After this you will be able to deploy your application as web .NET...
What I want? 1. How to display PDF in powerbuilder? 2. How to print PDF with Print dialog box? 3. How to print PDF and handle error while printing without ...
thanks for the reply actully i gave them these option but my company dont want to upgrade to pb11 nor they want to purchase apeon (recession effect ha ha..)...
smartcard card reader program passing code into sle_1.text='12345' in powerbuilder program. example:12345 i use pbm_enchange to passing from sle_1 to insertrow...
In such case, rewrite your application but this will be far more expensive and time consuming than upgrade to PB11. Purchasing DW.NET (about $500) would allow...
I would suggest if your expertise is in powerscript, then leverage that by skills by telling your boss to just purchase PB11. You may do as what George has...
Completely agree! Here is a link where you can by full Enterprize version of PB 11.5 as cheap as $2.5K: http://www.nextag.com/powerbuilder-11/stores-html ...
You can also get a membership to ISUG ($99 or so) and get PB 11.5 for free. http://www.isug.com/common/GoldBenefits.html Dan Mullings ABC Radio Networks ...
hello sandeep i have a solution to your first problem. use the below shell function: ll_return=ShellExecuteA (Handle (w), "open", ls_filename, ls_Null, ...