Good reason could be to set up the access rights on the client
application - you can prevent some user to display any row from any
query on your form. He does not receive any error messages that the
table is not granted to him etc. and sees only empty grid for example.

Ales

Martijn Tonies wrote:

> Hi,
>
>
>>>>I need to come up with a statement that's as fast a #2 but also works
>
> on
>
>>>>most IB/FB engines.
>>>>How should this statement look like ?
>>
>>>select * from table where pkcolumn = nonexistingvalue.
>>
>>The problem with this statement is that it forces me to know a bit too
>
> much
>
>>about the table :
>>a column name and a non-existing value.
>>
>>Ideally, I'd need something more generic.
>>Any other hint ?
>
>
> No.
>
> But why do you want to do this?
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>