> If I have a default value, with a unique index on this field, and it is left blank, which I don't want, it will not allow me to enter any more information into the grid. Also, if I used a buffered table and a save button, I would have to use a DO WHILE loop to make sure that the record is not blank. The reason for the DO WHILE loop is that once they have clicked on the page and gotten around the valid() event, they can then click back into the grid on a completely different line. If at this time, a person was to click on the save button, and just check the current line, there would be problems. With the possiblity of the lines in the grid being huge, this would take to much processing time to run through all of the line to ensure that invalid data has not been entered.
Please read Garrett's response. I totally agree with him that you should NOT use a unique index.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only