Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Datebase not Updating
Wed, Jan 16 2013 5:59 AMPermanent Link

Jeff Newlin

Lightspeed

I made a ElevateDB Unicode database called TestUnicode and things look fine with that. I have a form with a grid on it and tEdit called fName where I can enter a  new name. When I run this code

     with TestUnicode  do
     begin
        TestUnicode.Insert(True);
        Columns['Name'].AsString:= fName.Text ;
        Save;         
      end;

I can see it update my grid just like I want. But when I exit the page and re-run it, I find my new record is not there.

I must be missing something simple....

Thank you
Jeff
Wed, Jan 16 2013 11:08 AMPermanent Link

Leslie

Jeff,

Sending data to the server requires commiting the transaction.

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=Transactions

Cheers,
Leslie
Thu, Jan 17 2013 10:31 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jeff,

<< I must be missing something simple.... >>

You need to both start and commit a transaction in order to update a dataset
or datasets.  You can see this in action here in this video:

http://www.youtube.com/watch?v=5GUFqrwN918

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com
Sat, Feb 2 2013 9:05 PMPermanent Link

Jeff Newlin

Lightspeed

Tim

Just now getting back to this - I really enjoyed that video - so simple! But if you can believe it my products database is still not updating. I don't have DBISAM on my system and I'm wondering if that's somehow related. Everything works exactly as in the video - it goes into the edit mode, I make a change and press ENTER and I can see it take the edit - but when I close  my project and start it back up again - the record is still unchanged. I don't have the "Viewer" utility so I started up another copy of EWB so I could view the table BEFORE I closed my program, but I get the same result. Just for curiosity I tried another dataset and it's the same thing.

Can you think of any other reason that this dataset it not updating? I attached a screen shot but it looks like like your demo program to me.

Thanks very much - I'd love to see more videos I think they are very helpful for me and they illustrate how easy it is to use EWB.

Jeff



"Tim Young [Elevate Software]" wrote:

Jeff,

<< I must be missing something simple.... >>

You need to both start and commit a transaction in order to update a dataset
or datasets.  You can see this in action here in this video:

http://www.youtube.com/watch?v=5GUFqrwN918

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com



Attachments: shot1.jpg
Mon, Feb 4 2013 11:47 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jeff,

<< Just now getting back to this - I really enjoyed that video - so simple!
But if you can believe it my products database is still not updating. I
don't have DBISAM on my system and I'm wondering if that's somehow related.
Everything works exactly as in the video - it goes into the edit mode, I
make a change and press ENTER and I can see it take the edit - but when I
close  my project and start it back up again - the record is still
unchanged. I don't have the "Viewer" utility so I started up another copy of
EWB so I could view the table BEFORE I closed my program, but I get the same
result. Just for curiosity I tried another dataset and it's the same thing.

Can you think of any other reason that this dataset it not updating? I
attached a screen shot but it looks like like your demo program to me. >>

Did you manually define the Products table or use the one that was created
with the Install Example Applications option from the Help menu ?

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=Example_Applications

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Mon, Feb 4 2013 1:18 PMPermanent Link

Jeff Newlin

Lightspeed

My Goof! I had the "After Save" event defined (with the commit in it) but now I see my "save" method was never being called. I knew it would be something silly. Thanks for the help!

Jeff


"Tim Young [Elevate Software]" wrote:

Jeff,

<< Just now getting back to this - I really enjoyed that video - so simple!
But if you can believe it my products database is still not updating. I
don't have DBISAM on my system and I'm wondering if that's somehow related.
Everything works exactly as in the video - it goes into the edit mode, I
make a change and press ENTER and I can see it take the edit - but when I
close  my project and start it back up again - the record is still
unchanged. I don't have the "Viewer" utility so I started up another copy of
EWB so I could view the table BEFORE I closed my program, but I get the same
result. Just for curiosity I tried another dataset and it's the same thing.

Can you think of any other reason that this dataset it not updating? I
attached a screen shot but it looks like like your demo program to me. >>

Did you manually define the Products table or use the one that was created
with the Install Example Applications option from the Help menu ?

http://www.elevatesoft.com/manual?action=viewtopic&id=ewb1&topic=Example_Applications

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Wed, Feb 6 2013 3:59 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jeff,

<< My Goof! I had the "After Save" event defined (with the commit in it) but
now I see my "save" method was never being called. I knew it would be
something silly. Thanks for the help! >>

Fantastic.  I love things that aren't my error. Wink

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Image