Getting recordcount of tables

[Beatrix Willius]

Hi Ivan,

thanks for your reply.

On 20.11.2011, at 11:16, Ivan Smahin wrote:

> That value is in UPPER case now.
> 
> select fld_name, fld_kind_str, fld_record_count from (show tables) where fld_kind_str = 'USER'

Since when is this kind of SQL case-sensitive.
> 
> Double quotas are for identifiers - not a string literals:
> 
> select "f1" from "t1" where "f1" = 'string literal'
> 
> so "user" was treated as some variable/field name.

Ah, okay.

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20111121/c600a883/attachment.html>