I found more about this problem. The error occurred when it tries to post a value to numeric(15,7) field with value i.e.: 0,0000000 If I try to post the value 0,000000 (one zero less, total 6 decimals) there is no problem.
Any suggestions? Dennis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marselle Sent: Friday, December 14, 2007 3:41 PM To: [email protected] Subject: RE: [delphi-en] access violation on post, working on delphi 7 and firebird 2.0.3.12981 ref/eDN0013816581 Looks like you need to do your open on the database component.. then do your other actions with the DataSet component. --- dennis <[EMAIL PROTECTED] <mailto:dennis%40praxi.gr> > wrote: > Also, I use Interbase Express 7.11 delphis > components > > > > > > Here is all the code of the project: > > > > unit unit_simple_opening_a_table; > > > > interface > > > > uses > > Windows, Messages, SysUtils, Variants, Classes, > Graphics, Controls, Forms, > > Dialogs, StdCtrls, Buttons, DB, IBCustomDataSet, > IBDatabase; > > > > type > > Tform_simple_opening_a_table = class(TForm) > > IBDatabase1: TIBDatabase; > > IBTransaction1: TIBTransaction; > > IBDataSet1: TIBDataSet; > > BitBtn1: TBitBtn; > > procedure BitBtn1Click(Sender: TObject); > > private > > { Private declarations } > > public > > { Public declarations } > > end; > > > > var > > form_simple_opening_a_table: > Tform_simple_opening_a_table; > > > > implementation > > > > {$R *.dfm} > > > > procedure > Tform_simple_opening_a_table.BitBtn1Click(Sender: > TObject); > > begin > > ibdatabase1.Open; > > with ibdataset1 do begin > > open; > > edit; > > post; > > close; > > end ; > > > > end; > > > > end. > > > > Friendly, Dennis > > > > > > From: [email protected] <mailto:delphi-en%40yahoogroups.com> > [mailto:[email protected] <mailto:delphi-en%40yahoogroups.com> ] On Behalf > Of Marselle > Sent: Friday, December 14, 2007 3:03 PM > To: [email protected] <mailto:delphi-en%40yahoogroups.com> > Subject: RE: [delphi-en] access violation on post, > working on delphi 7 and > firebird 2.0.3.12981 ref/eDN0013816581 > > > > can you post a sample of the code.. perhaps you are > trying to access something that not been created > properly.. to see the code would make it easier to > help you.. > > --- dennis <[EMAIL PROTECTED] <mailto:dennis%40praxi.gr> > <mailto:dennis%40praxi.gr> > wrote: > > > Hello Andries > > > > > > > > I do not make any changes on the data. > > > > I order to find out what is going on, in my new > > project there is no code at > > all by me > > > > It has only one event of the button that doing the > > follow: > > > > > > > > procedure > > Tform_simple_opening_a_table.BitBtn1Click(Sender: > > TObject); > > > > begin > > > > ibdatabase1.Open; > > > > with ibdataset1 do begin > > > > open; > > > > edit; > > > > post; // ß- the access violation is occurred > > right here > > > > close; > > > > end ; > > > > end; > > > > > > > > No other events at all. > > > > > > > > Firently Dennis > > > > > > > > From: [email protected] <mailto:delphi-en%40yahoogroups.com> > <mailto:delphi-en%40yahoogroups.com> > > [mailto:[email protected] <mailto:delphi-en%40yahoogroups.com> > <mailto:delphi-en%40yahoogroups.com> ] > On Behalf > > Of Andries Bos > > Sent: Friday, December 14, 2007 2:16 PM > > To: [email protected] <mailto:delphi-en%40yahoogroups.com> > <mailto:delphi-en%40yahoogroups.com> > > Subject: Re: [delphi-en] access violation on post, > > working on delphi 7 and > > firebird 2.0.3.12981 ref/eDN0013816581 > > > > > > > > I have had the same problem in the past on XP, but > > now I rely on regional > > settings and explicitly 'ask' the system for it's > > regional settings before a > > post : > > > > as a start...: > > > > GetLocaleFormatSettings(LOCALE_SYSTEM_DEFAULT, > > LFormatSettings); > > > > LCurrStr := CurrToStrF(AValue, ffFixed, 2, > > LFormatSettings) > === message truncated === __________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping [Non-text portions of this message have been removed]
