Tech Tip: Checking a table number to see if a table still exists
PRODUCT: 4D Developer | VERSION: 11 | PLATFORM: Mac & Win
Published On: January 31, 2008
New to 4D v11 SQL is the ability to delete tables. There may be a situation, then, that will require you to check if a table number is still valid or not.
The command to do this is "Is table number valid", which returns a True if the table still exists in the database, or False if it has been deleted or is in the Trash.
The command to do this is "Is table number valid", which returns a True if the table still exists in the database, or False if it has been deleted or is in the Trash.
The command to check is: Is field number valid (tableNum | tablePtr; fieldNum) -> Boolean
It will return True is the field still exists in the database or False if it was deleted or is in the Trash.