How do I populate the mslink column for a new database record?
If an SQL Insert statement must be manually processed and an mslink value must be specified and the next mslink to use is not known, then first process an SQL Select statement using the ‘max’ SQL function (ex. select max (mslink) from parcel) to get the current largest mslink value and simply add one to calculate the next mslink value. Unfortunately, the ‘max’ SQL functionality is not available in Xbase. In dbWindow, the user does not need to be concerned with what mslink value to use since dbWindow will automatically take care of it. To further explain, when the user inserts a new row into the grid item, the user can leave the mslink column blank and when the Commit button is pressed dbWindow will automatically determine the next mslink and process the correct SQL Insert statement for the user. Also in dbWindow, the Import utility can be used to automatically populate the mslink column value when importing data into a table.
