+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: How to use RecordGroups of DB in QTP (/Thread-How-to-use-RecordGroups-of-DB-in-QTP)
How to use RecordGroups of DB in QTP - PRERNASHARAD - 06-11-2011
I am looking for a solution that can fetch records from DB table with less impact on performance.
The requirement is to extensively use around 80 DB tables(Database: Oracle). Instead of fetching DB records one after other, I want some mechanism to fetch entire DB table once and store in temporary variables. For example, RecordGroups concept in SQL does this job.
Note: A record group is an oracle forms data structure that has a column/row framework similar to a database table.