Ahsan Amin


is there any command to select the record of user's choice aprt of sql select command




Re: select records command

Naomi Nosonovsky


You can also check SET KEY command in the help. There is SET FILTER command as well, but this one is not usually recommended.

You can also create a local view with parameters. But essentially it's still a SELECT-SQL.

Another way would be to create FILTERED index.






Re: select records command

dni

What does "aprt" stand for







Re: select records command

Naomi Nosonovsky

BTW, if you're talking about one record and not records, when you can just search for this record using either index and indexseek() or seek() functions or LOCATE if you need to search by several conditions.