hi i have typical problem while filtering the datawindow using the strings i put the code in the editchanged event which filters the detail datawindow based on...
Alim - The PFC libraries are available as an installation option on your PowerBuilder discs. Insert the PB disc #1, set up to install PowerBuilder (yes,...
Santosh - Since your code already supplies the quotes for the search string, the only reason to enter a quote IN the search string is if the data contains a...
it's a not too much tested sql: i suppose there are code and id (serial) fields, maybe instead of id field u can use the rowid function (i try it on informix) ...
I am trying to run this script and getting an error message because I am trying to use a MAX date in a nested select statement. does anyone have a solution to...
1. Take this script and use it to create a datawindow. 2. Replace the DATE parameters in the script with retrieval arguments. 3. Test the dw, If it works then...
hi Olan, thank you very much. I found in my CD. by the way, do you ever used n_cst_queue ? if yes, can you give me some tips ? best regards, alim ... ...
im working on WMS, we always use the FIFO method but most of the time this can be done by just sorting the criteria, in your case the field is the date...
hi, i have noticed that you have used cpmplete_date in place of completed_date correct that mistake i think it will solve your problem select distinct...
In my application the dataobject `d_guest_search_result2' is used to display the guest. I have use a stored procedure for the result set. The dataobject have...
Hi, I am developing a program in which I retrieve n add rows and then copy to another datawindow & then update it gives error of database Give me hint how i...
Hi All, It's my pleasure to be a part of Power builder group. I visited many sites who are providing the good solutions in Power builder. After seeing this...
hi, disable retrieve rows as needed property of datawindow coz, that disables your filtering bye laxman faroqe_kvp <faroqe_kvp@...> wrote: The column...
I guess you can always check the return value for setfilter. also suggest to do one thing, first you set the filter and then retrieve and see the result. ...
Hi all! I just want to know if its possible to get data from a series of rows and put it in an array. like select fname, lname from table into fname[],lname[] ...
Yes, this is easily done with a datawindow/datastore, however it is too much to type. Look up "dot notation" in the Help, and the follow the link to the...
Hi Jeff, It is not possible, but you could populate your arrays from DataStore based on your SQL in one assignment or in a loop from cursor. However, if your...
Dear Group members, I have a problem in Powerbuilder ver 6.5 which I wonder if someone can help. My application was using SQL Server 6.5 as the back-end. I...
If you want to do that in SQL, check out your DBMS's "BULK" operation. For example, in Oracle there is the bulk collect clause that lets you put multiple rows...
Hi guys !! I receive an error message saying "INVALID ROW RANGE AT LINE 0 IN FUNCTION MY_FN OF OBJECT MY_FN" I realized the function is corrupted ,is there...
Is there a way to minimize response windows? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam...
how were u able to say it is corrupted? the erorr message u posted tells you that the row either returned null, 0, or a row that is inexistent in the...
Hi Kiron, Check this link http://support.microsoft.com/kb/867880 "Microsoft distributes Microsoft SQL Server 2000 fixes as one downloadable file. " Hope it...
What for? If it would be minimize instead of closed, user can do nothing in the application? If you want to minimize it and allow user working, use popup...
Kiron, Change your DBMS for connection to SQL Server 2000 from ODBC to OLEDB and this will fix your problem. Regards, George ________________________________ ...
