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('descri ption').As String := 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 ?
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 ?
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.
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
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;
if MyDataSource.State in [dsEdit, dsInsert] then
UpDateTheFieldValues;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Table1.Edit;
..// Do your modifications
Table1.Post;
Igor