Re: Filtering data

yes, the good idea would be to do a SQl query that give you the filtered records, and if your problem is that you creat your criteria at run time , then select records from database , create your criteria on the basis of selected records and then requery from the database, with new criterias.
You can dynamically create your SQL in you Delphi code.

Faheem Rao

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ts91t2j6kgvmaf_at_news.demon.nl>...
> "Shishir Mishra" <shishir_at_agnisoft.com> wrote in message
> news:dbb1ff9aff315c3db8df54727be3cbb6.32095_at_mygate.mailgate.org...
> >
> > Hi Oracle Gods!
> > I have stuck at one point . I am a Delphi programmar .
> > My problem is:
> > I Want to return a set of recordset from different table . I can do it
> using
> > ref cursor . Now inside another function which will get above recordset ,
> I
> > want to filter the data (delete some unwanted record ) on basis of some
> > condition . Then i am suppose to return these edited recordset to a
> diffrent
> > function which will be also filter recordset and and again this function
> will
> > return these to diffrent function .
> > Though i can filter the recordset but the problem is that i have to access
> the
> > so called table(data type) as array . I dont want to use that . I want to
> use
> > sql statement to access that data.
> > If i declare that table as object it still not working in the way which i
> want
> > .
> > So plz help me .
> > thanx in advance
> > shishir kumar mishra
> >
> > mail me at shishir_at_agnisoft.com
> >
> >
> >
> >
> > --
> > Posted from [203.200.15.20]
> > via Mailgate.ORG Server - http://www.Mailgate.ORG
>
>
> One of the first commandments in using Oracle is you should do *everything*
> on the database side what you *can* do on the database side.
> Filtering records in a procedure is a *very bad* idea,
> and from what you describe I don't hope I ever have to look at your actual
> code.
> You're asking the impossible.
> Restructure your code and try to do as much as possible in *one*
> sqlstatement instead of at procedural level.
>
> Regards,
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Oct 10 2001 - 19:32:11 CDT