Link to home
Start Free TrialLog in
Avatar of nhoj
nhoj

asked on

Whats the difference?

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 ?
Avatar of inter
inter
Flag of Türkiye image

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

Igor
Avatar of ZifNab
ZifNab

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.
Avatar of nhoj

ASKER

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

ASKER CERTIFIED SOLUTION
Avatar of rwilson032697
rwilson032697

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial