Hi there (again) ok i sort of solved my woes, but if i want to locate a record in such a query, it takes ages (considering that i have quite too many rows), i tried the locate and lookup functions and wont be much help. Then i thought. oh well i can filter the table leave the row i want and then disappear the filter, but it seems to fetch the rows again. this is on a MS-SQL 7 DB w/ADO on D5 TIA Moises lopez __________________________________________________ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
