We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Whats the difference?

nhoj
nhoj asked
on
Medium Priority
165 Views
Last Modified: 2010-04-04
Why can I modify data in an Empress database table with data aware controls i.e. DBEdit, DBMemo, but I cannot do it with code i.e. Table1.FieldByName('description').AsString := Edit1.Text;
The table is open with ReadOnly set to false.
the same thing happens with queries even when RequestLive is set to true.
I do not have this problem with Access tables.
Is there anyone else out there using Delphi 3.0 and Empress ?
Comment
Watch Question

Commented:
Hi, May be it is silly to ask but did you do
Table1.Edit;
..// Do your modifications
Table1.Post;

Igor

Commented:
Sorry, don't know anything of Empress... You do use Edit/post, don't you? But since you don't have problems with Access, I guess you do.

Author

Commented:
From nohj
Thanks chaps that sorted the problem, but I still have never had to do this with Access. Empress is a Canadian RDBMS for UNIX, very powerful, checkout www.empress.com

Commented:
The DataSet must be in edit or insert mode to change a value.  You can use this code to check the status
if MyDataSource.State in [dsEdit, dsInsert] then
  UpDateTheFieldValues;

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.