RGD Table Delete Invalid KeysThis is a featured page

No matter how hard you try, invalid data can creep into tables either by well intentioned users or by the odd programming error.

System delimiters stored in record ids can cause all sorts of odd behaviour, mainly centered around index retrieval.

the TABLE_DELETEINVALIDKEYS function will can a table for records that have a system delimeter or a null as a key and then remove them. Alternativly, the procedure will move the bad records to a backup table, changing any system delimiters into dots, so that you can scan through them to see if the data is worth keeping.




zapher67
zapher67
Latest page update: made by zapher67 , Feb 5 2008, 4:51 PM EST (about this update About This Update zapher67 Edited by zapher67

98 words added

view changes

- complete history)
Keyword tags: delete keys remove table
More Info: links to this page
There are no threads for this page.  Be the first to start a new thread.
Unknown File rgd_table_deleteInvalidKeys.bas (Unknown File - 3k)
posted by zapher67   Feb 5 2008, 4:52 PM EST
basic+ source code version 1.00

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)