In the DBNavigator1Click I include the lines: if Button = nbPost then SQLQuery1.ApplyUpdates(-1);
The results remain unchanged. I repeat the process described below and everythings remain the same. I suppose this if command attends your suggestion, William. Is this right? Thanks Ricardo ----- Original Message ----- From: William Oliveira Ferreira Sent: 07/26/11 12:08 PM To: Lazarus mailing list Subject: Re: [Lazarus] Some information about DBNavigator and DBGrid single applications I think you shoud use apllyUpdates from your dataset after post, no? ________________________________ William de Oliveira Ferreira Bacharel em Sistemas de Informação 2011/7/26 "Arí Ricardo Ody" < [email protected] > I built a single application to browse and update a SQLite database that have 1 table with 2 columns: num and name I inserted 2 lines in the table begin my tests. The application consists in a DBNavigator and DBGrid. When I ran the program the grid appears and the 2 lines appear normally in the grid. Everything seems to be fine. Then I try to include a new line in the grid by click on "+"(insert) button of the DBNavigator. It appears a new line in the grid. I type a number and name and click the "post" button of the DBNavigator. The grid appears now with 3 lines. I repeat the operation and the grid appears with 4 lines. As expected. In this moment I click the "refresh" button of the DBNavigator. Surprise! I receive the original grid with the 2 lines I inserted originally. E.g., the insertions don't occurs in the database although the new lines appear in the grid before I click the refresh button. There was a SQLite3 connection, a SQLQuery, a Datasource and a SQLTransaction. Are these components plus DBNavigator and DBGrid data-aware components? It seems that they don't. Other question: After I click the "+" button in the DBNAvigator and type the newline, how can I get in my code the values typed in the new line? Greetings from Sao Paulo - Brazil Ricardo -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
-- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
