Database Query Builder, commit changes
Hello, all I need to make some simple changes to a Valentina DB, the Query builder is a great tool and I have everything set to open the tables and edit the fields. The problem comes when I am saving the changes back. If I use the auto edit feature of the Query Builder I get no erros but the changed data is not committed, on refresh the original field contents show. I tried a button with revCommitDatabase currentDB and I get cant find handler error. I am sure there is something simple I am missing, thanks all Michael Parent Read Naturally 1-800-788-4085 ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Database Query Builder, commit changes
--- Michael Parent [EMAIL PROTECTED] wrote: Hello, all I need to make some simple changes to a Valentina DB, the Query builder is a great tool and I have everything set to open the tables and edit the fields. The problem comes when I am saving the changes back. If I use the auto edit feature of the Query Builder I get no erros but the changed data is not committed, on refresh the original field contents show. I tried a button with revCommitDatabase currentDB and I get cant find handler error. I am sure there is something simple I am missing, thanks all Michael Parent Hi Michael, Have you ticked the 'Cache record set' checkbox ? If you didn't, you may have refresh problems. When you explicitly refresh the query, do the changes show up or not ? Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Database Query Builder, commit changes
Hello Jan, I did not check 'cache record set as I will be opening many different Db files. When I do a change and either click refresh query from Query Builder or through a Button set to the auto refresh action from Query Builder the original Data is displayed on screen. Michael Parent Read Naturally 1-800-788-4085 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jan Schenkel Sent: Monday, May 02, 2005 1:45 PM To: How to use Revolution Subject: Re: Database Query Builder, commit changes --- Michael Parent [EMAIL PROTECTED] wrote: Hello, all I need to make some simple changes to a Valentina DB, the Query builder is a great tool and I have everything set to open the tables and edit the fields. The problem comes when I am saving the changes back. If I use the auto edit feature of the Query Builder I get no erros but the changed data is not committed, on refresh the original field contents show. I tried a button with revCommitDatabase currentDB and I get cant find handler error. I am sure there is something simple I am missing, thanks all Michael Parent Hi Michael, Have you ticked the 'Cache record set' checkbox ? If you didn't, you may have refresh problems. When you explicitly refresh the query, do the changes show up or not ? Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Database Query Builder, commit changes
--- michael parent [EMAIL PROTECTED] wrote: Hello Jan, I did not check 'cache record set as I will be opening many different Db files. When I do a change and either click refresh query from Query Builder or through a Button set to the auto refresh action from Query Builder the original Data is displayed on screen. Michael Parent Hi Michael, In that case it's not writing the data back to the database. Hmm, if you have selected the correct primary key, it ought to work. If not, you may have to check with Rev support to see what is causing you problem. Jan Schenkel. Quartam - Tools for Revolution http://www.quartam.com = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution