RE: Database Query Builder, commit changes

[Jan Schenkel]

--- 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


=
"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

[michael parent]

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

[Jan Schenkel]

--- 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


=
"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