Inserting rows

When I insert a row into a table, the results from the query that come after the row don’t show up. If I re-fetch the results, I can get at all the results, but the row is not where I put it. Why?


What you are seeing are the expected results of three underlying actions in Power Objects.

When you click on the Insert push button in the tool bar, it inserts a row into the recordset at the position of the current row. If your current row is in position 4, the new row is inserted in position 4 and all subsequent rows are moved back a postion in the recordset.

The recordset remains these positions for its lifetime. When you re-fetch your data, you build a new recordset, whose order is determined by either the OrderBy property of the form or the index used by default to retrieve the data.

The reason you seem to be ‘missing’ some results after your insert has to do with the interaction between your application and the database when the RowFetchMode is set to one of the incremental fetch modes, “Fetch As Needed” or “Fetch Count First”. It is good practice to commit your write operations, such as an insert, as soon as possible after the operation is complete to avoid causing too much contention in the database. Once you commit a transaction, the cursor for the transaction is destroyed by the database. Once the cursor for the transaction is destroyed, you cannot fetch any more data. So, if you are incrementally fetching data and do a commit or a roll back, you will be unable to retrieve any more data from the database, leaving you with an incomplete recordset in your application.

You can handle this situation by calling the FetchAllRows() method for a form that uses an incremental fetch mode before you commit or rollback a transaction.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may

man on floor with data

DevX Quick Guide to Data Ingestion

One of the biggest trends of the 21st century is the massive surge in internet usage. With major innovations such as smart technology, social media, and online shopping sites, the internet has become an essential part of everyday life for a large portion of the population. Due to this internet

payment via phone

7 Ways Technology Has Changed Traditional Payments

In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier to pay for goods and services without carrying cash or using a checkbook. This article will look at seven of the most significant ways technology has transformed traditional payment methods.