Database Search
TechHome
 |
- !!NEWSFLASH!!
- An Empty Record Gets Created
- dbGetEntireRecord Quotes
- dbOpen 10012 Read-Only Error
- dbSort Issue
- LAFFDB Example
- LAFFDB Extender De-emphasized
- LAFFDB Leaving Emtpy Row in Table
- LAFFDB Table Browser
- Limitations of LAFFDB
- Look for Number in Field and Retrieve Line
- Remove Duplicate Records Using Laffdb
- RemoveDups
- Search Addresses by Area Code
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
LAFFDB Leaving Emtpy Row in Table
Question:
When I use LAFFDB dbDeleteRecord to delete the last record in a file, it leaves an 'empty' record in the db.This is causing me problems in that I perform certain operations if the count of the records is greater than 0 and this is returning a count when there actually aren't any valid records.
Is this normal? I've been looking and don't see anything unusual in my code. The record does not exist until I delete the LAST record in the table (minus the header, of course). At that point, an empty row remains. The LAFFDB dll is: laffd34i.dll
(I'm using database 'templates', that is, text files that use the first row as column names for easier column naming when opening the database, if that matters.)
Answer:
Hmmm. Well, there is a "feature" where laffdb prepares the next row in the table for use, making it "look" like there is yet to be filled final record. This sounds suspiciously enough likethe problem you are having that I think there is some relation.You may need to "inspect" the record you are working on to verify it is a goofd record before proceeding.
Article ID: W16831
File Created: 2007:07:03:14:26:28
Last Updated: 2007:07:03:14:26:28