Pro *C Programming Do’s and Don’t

by Mark Marucot on November 18, 2007

Use one array per action such as inserting, updated and deleting records.
Always increment the array counter every time you add new records.
Always resize array every time you add new records.
Always reset the array counter after the bulk update, insert and delete.
Inserting or updating records should comes last if the value of column in comes from a separate logic such as calculation, sequence retrieval.