[ciapug] Adodb: RecordCount()

[Barry Von Ahsen]

David Champion wrote:
> Is this on mysql or ms-sql? Some of ADODB's methods don't work with some 
>  databases. For instance, the Identity_Insert() doesn't work with 
> Oracle. Others that are "spotty" are things like MoveFirst() - or 
> anything that moves the cursor position anything more than forward one.
> 

oracle does not support RecordCount(), but it does support 
PO_RecordCount(table, where), which if the database doesn't support 
PO_RecordCount, it runs "select count(*) from $table where $where", at 
the expense of an extra database hit.

-barry