I have a bug in one of my programs where once in a while when I post a record in a dbgrid that is connected to an ADO query, It'll return an id of 0 for an autoincrement field.
I've found that to cause this to happen I have to have opened 2 other forms and one of them has to remain open.
I've looked through the form with the grid and the 2 other forms (which don't relate in any way to the query or grid) and haven't been able to locate anything that could cause this.
Any ideas as to why this happens? 95% of the time the id field is returned correctly after the post has been performed.
I've found that to cause this to happen I have to have opened 2 other forms and one of them has to remain open.
I've looked through the form with the grid and the 2 other forms (which don't relate in any way to the query or grid) and haven't been able to locate anything that could cause this.
Any ideas as to why this happens? 95% of the time the id field is returned correctly after the post has been performed.