Thanks for the info. I though some setting like that may be there, but
I was not familiar with the commitaction
property. It was set at caInvalidatecursor. I will try the setting of
refresh and that will probably take care of
my problem.

Thanks for the info and prompt response.

Best Regards

Jack Engleman


Alan McDonald wrote:

>
> > > > I have converted my application over from BDE to IBOojects and I am
> > > > running into a problem. I used data from my query after doing a post
> > > > on the data. I then use the data in the Query for some other
> functions
> > > > before finishing my task. With the BDE this worked OK. Now I notice
> > > > that once I post the data, my data is not retained in the Query. In
> > > > the example below Message 4 is OK and Message 5 is Blank( no data ).
> > > >
> > > > ShowMessage('4 Res OK: ' + FieldByName('PICKUPDATE').AsString);
> > > > Post;
> > > > ShowMessage('5 Res OK: ' + FieldByName('PICKUPDATE').AsString);
> > > >
> > > > Is there an option to allow this behavior or do I have to change my
> > > > code. Changing the code could be a ardous process in that I have a
> > > > lot of code and I would have to check every place I am doing a
> post to
> > > > fix the problem.
> > > >
> > > > Thanks in Advance
> > > >
> > > > Jack Engleman
> > > I'm not sure how you have setup your transactions. Do you call
> > commit after
> > > post? do you have a caClose action as your CommitAction?
> > > Alan
> > >
> > AFter the Post, then I have some other routines I call with the
> > FieldByName('PICKUPDATE').AsString as a paremeter and those functions
> > and procedures do not see a null pickupdate and after those procedures
> > I was calling a commit transaction. That commit is working since all
> > of the rest of the program runs correctly as far as I can tell from my
> > beta sites. That statement is good until I hear from one of my
> > customers about another error.
> >
> > I have been going into the code and I have changed this area by
> > creating a variable to hold the values to use in those routines where
> > the field values worked before.
> >
> > I am still somewhat concerned that I have other areas of the program
> > where the code worked with the BDE and may not with IBOojects due to
> > this discrepency, so I am going through about 148,000 of application
> > code to find other areas of I may posting data and using the values
> > from a query as I did before.
> >
> > Best Regards
> >
> > Jack
>
> so in short, you are calling transaction.commit in the after post event of
> the query?
> In which case you should check the Query Commit Action so it's not set to
> caClose which will close the query - make it caRefresh so you still
> have the
> query open til you manually close it.
> Also set the Transaction AutoCommit to False if you've mistakenly set
> it to
> True
> Alan
>
>