|Subject||Re: [firebird-support] Firebird/Internet performance questions|
>From: "David Johnson"existence of a table in DB2.
> >Standard SQL provides language to do what your Access databases need
> >rowcounts for - see esp. the EXISTS() predicate.
> The whole table count was intended as an existence check - it is how you typically check for the
It is quite common that hacks from one platform do not work as expected on another
(what else is using Count instead of standard Exists).
Are you checking existence of table or rows in table ?
Some other hacks you can try:
- "SELECT Min(PK_Field) FROM tab;" and look if it returns anything
- "SELECT * FROM tab;" and try to fetch just one record.