I want to show a single row

[AbdulHaseeb]

I want to show a single row completely but i want it to use only Select From Where

[Villeroy]

Code: Select all

SELECT * 
FROM "Table"
WHERE "Identifier" = :Please_Enter_ID

[UnklDonald418]

You didn't provide any information about what type of database you are using.
To limit the result set to one row for many databases you could add

Code: Select all

AND ROWNUM() = 1

to your WHERE clause.
If you are using an Embedded Base database

Code: Select all

SELECT TOP 1 * FROM "YourTable"  WHERE whatever constraints you have.

This query must be run in the direct mode, the Base parser will reject that statement. In the direct mode you must specify all the elements in the WHERE cause.you cannot use a parameter query like the one recommended by Villeroy.