[Lazarus] TSQLQuery and creating a new record

Albert Zuurbier albert.zuurbier at gmail.com
Tue May 18 23:38:30 CEST 2010


 >> IT WORKS! I definitively vote for documentation. Now, documentation is
 >> where I can do something. I cannot add anything to the development of
 >> TSQLQuery itself, so much is made more than clear. But, I am happy
 >> that the component works the way I expected it to work.
 >
 >Glad to hear. But if you're not doing something strange, it should also
 >work with the default queries.
 >Any idea why that doesn't work?

Well...
After it properly worked (inserted a ApplyUpdates and a Refresh), I 
removed the SQL I created myself. And yes, it works.
What I think happened is that because the id wasn't shown, my impression 
was that things didn't work. I also want the new record to show in a 
form. I found information on using SQL statements, which set me on the 
wrong path. Eventually I found the bug report and saw in it the 
confirmation that I wasn't the only one with the problem.
Making the new autoincrement id visible immediately after inserting or 
appending a record, would solve confusion. However, I.understand the 
difficulty in implementing that.

Albert




More information about the Lazarus mailing list