Hi Helen,

I have attached a copy of the demo I wrote, I hope this is of help.

I have also placed a date prior to the relevant posts. The original post
started with the subject "IBObject Survey Demo"

Once more thank you for coming to the rescue

Daniel

> I'm not Jason or Lester....but
>
>
> >I am hopping that Jason has had a chance to look at this, as I will have
> to
> >address this issue in a real application very soon.
> >
> >Please let me know if there is anything which I could provide you with
> which
> >will make the question easier to answer.
>
> I've looked back through the messages and can't see any posting from you
> about DMLCaching. Do you want to post the "bones" of your problem to the
> list?
>
> Helen
>
>
> >Thank you
> >
> >Daniel
> >
> > > > I am aware that you asked Jason if he could look in the problems I
> > > > was having with the DMLCache. However, as I have not heard anything
> > > > from
> > > him, I
> > > > was wondering if you have had any feed back from Jason?
>

16/06/2005

> Helen Borrie wrote:
>
> >>>You're saying this doesn't work in Builder?
> >>>
> >>Correct, I am only able to view the About and the FRM_Survey form,
> >>the
> rest
> >>of the forms will not be displayed at Design-time????
> >
> > Lester will fix you up. :-)

10/06/2005

Helen Borrie wrote:

>>>You're saying this doesn't work in Builder?
>>>
>>Correct, I am only able to view the About and the FRM_Survey form, the
>>rest of the forms will not be displayed at Design-time????
>
> Lester will fix you up. :-)

I will ?
Most of the demo stuff needs work to be able to use it properly in Builder
:( You can build the projects, but the forms are created in Delphi, and so
in many cases Builder will not open them. Fixing this up may also be
different between Builder5 and 6 since the form stuff changed between the
two ( I have to fix for 5 and then reopen of 6 ). I have fixed up a number
of samples across IBO and FastReports but they need sorting so that we can
have a separate sample download for Builder.
Daniel are you on BCB5 or 6?
I've got a trashed railway timetable to get sorted today, but I will have a
look at this again later !

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services

14/06/2005

> I will ?
> Most of the demo stuff needs work to be able to use it properly in
> Builder :( You can build the projects, but the forms are created in
> Delphi, and so in many cases Builder will not open them. Fixing this
> up may also be different between Builder5 and 6 since the form stuff
> changed between the two ( I have to fix for 5 and then reopen of 6 ).
> I have fixed up a number of samples across IBO and FastReports but
> they need sorting so that we can have a separate sample download for
> Builder.
> Daniel are you on BCB5 or 6?
> I've got a trashed railway timetable to get sorted today, but I will
> have a look at this again later !
>

Hi Lester

We use BCB 5. I have notice that you have uploaded the Survey demo for BCB 5
and 6 thank you

Daniel

14/16/2005

Hi Daniel,

had you set RequestLive to True?

Greetings
Dirk

> Hi,
>
> I have written a very simple demo to see how the DMLCache works.
>
> The demo works perfectly, however, when I set the IB_Query Property
> PessimisticLcoking = True on one of the two IB_Query (or on both) and
> I try to edit a single record (no other instance of the application or
> form is currently editing the record in question) I get the following
> error:
>
> ISC ERROR CODE: 335544569
> ISC ERROR MESSAGE:
> Dynamic SQL ERROR
> SQL error code =-510
> Cursor not updatable.
>
> The demo consist of a single Form, IB_Connection, IB_Transaction, two
> IB_Grids, each grid has a IB_Query, IB_DataSource and IB_UpdateBar
> respectively.
>
> The two IB_Queries are identical including the SQL and all its
> properties.
>
>
> What have I done incorrectly?
>
>
> I am trying to use the PessimisticLocking property so that a record
> can not be in edited by various forms/grids at the same point in time.
>
>
> Thank you
>
> daniel

14/06/2005

> had you set RequestLive to True?
>
> Greetings
> Dirk
>

Hi Dirk,

I just tried with RequestLive = True and also with RequestLive = False.
Unfortunately I encountered the same error as previously reported.

Thank you

Daniel

14/06/2005

Daniel R. Jimenez wrote:

> I just tried with RequestLive = True and also with RequestLive = False.
> Unfortunately I encountered the same error as previously reported.

Don't use PessimisticLocking myself. If I need to lock records, a 'last
modified' field gets updated, and that tells other users that the record is
'busy' and who it is busy with ( -ve user_id = editing, +ve user_id = last
changed by )

I'm tied up with the Firebird AGM and other stuff at the moment - if your
demo is running on the example databases just zip up a copy and I'll have a
look at it as I don't have time to 'roll my own' ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services

17/06/2005

Daniel R. Jimenez wrote:

> Hi Lester,
>
> Please find attached a super simple demo for the DMLCache.
>
> I am using BCB 5.
>
> Thank you very much for your help

I'm not being much help
All hell broke out here today and I have a major rewrite to cope with - I
WILL have a look at this when I can!

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services

27/08/2005

Daniel R. Jimenez wrote:

> I am aware that you asked Jason if he could look in the problems I was
> having with the DMLCache. However, as I have not heard anything from
> him, I was wondering if you have had any feed back from Jason?

I think we need to rattle the cage a bit harder. I was supposed to be
providing help, but things like this really need Jason's input as it is
beyond the areas that I use :(

Now if it was the basic Builder stuff I'd be OK ;)

--
Lester Caine
-----------------------------


[Non-text portions of this message have been removed]