Is it possible to count the number of records in a form/table and display that value in a field in a different table?
Yes, nearly all client packages support this concept, although they all do it a bit differently. Using ADO, you can call the recordset.movelast method, then inspect the recordset.recordcount property. In PowerBuilder (Jaguar), you can retrieve the datawindow rowcount attribute. In Perl, you need to simply increment a counter after retrieving each row. All of these packages support the ability to retrieve rows on demand, but I don't think you can get a rowcount from any of them when they are used that way.
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Database Design Web Links: tips, tutorials, scripts, and more.
- Have a Database Design tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Database Design questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Database Design guru is waiting to answer your toughest questions.
Dig Deeper on Oracle and SQL
Related Q&A from Pat Phelan
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.