Advice Please

[Guest]

Hi,
Can someone explain me the following string for what?

"SELECT MyTable.*, False AS Expr2 FROM MyTable WHERE (((False)<>False))"

I think this will not bring any record on subform; any better solution which
i can replace this string?

Thanks in advance

 

[Pieter Wijnen]

The Where Clause is to make sure you don't get any records, typically used
as a recordsource before the user makes a selection instead of returning all
rows from large tables

Clearer to understand would be to use:
SELECT MyTable.* WHERE 1=0

HtH

Pieter

 

[Guest]

Thank you very much

The Where Clause is to make sure you don't get any records, typically used
as a recordsource before the user makes a selection instead of returning all
rows from large tables

Clearer to understand would be to use:
SELECT MyTable.* WHERE 1=0

HtH

Pieter