Board index » delphi » Multi users and updates!

Phil

Delphi Developer
Fri, 27 Jun 2003 02:22:16 GMT

Multi users and updates!

    I'm making a software that uses an Access Database,  I've come arross 1
serious problem.  Using a Grid, I'm posting a record that was already
changed by someone else,  my problem is that because it was changed by
someone else in a different software, the program {*word*99}s out and says that I
could not locate the row to update.  I suppose its trying to do a SQL that
matchs the entire row information, and since its no longer the same has
before it complains.
Using the BDE I was able to see the where clause to Key only, but I don't
seem to have this option with ADO,  How to I get around this problem.

Thank you.

Phil C.

 
Brian Bushay Team

Delphi Developer
Fri, 27 Jun 2003 10:28:02 GMT

Re:Multi users and updates!


Quote
>Using the BDE I was able to see the where clause to Key only, but I don't
>seem to have this option with ADO,  How to I get around this problem.

Try
ADODataSet1.Properties['Update Criteria']:=adCriteriaKey;

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Phil

Delphi Developer
Fri, 27 Jun 2003 20:53:58 GMT

Re:Multi users and updates!


It says that its readonly, I cannot left assign.    Too bad, it looked
right!

Phil C.

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:k79i5tgvks43dhmlhfrl0renbp4oosbkns@4ax.com...

Quote

> >Using the BDE I was able to see the where clause to Key only, but I don't
> >seem to have this option with ADO,  How to I get around this problem.

> Try
> ADODataSet1.Properties['Update Criteria']:=adCriteriaKey;

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

arsradi

Delphi Developer
Sat, 28 Jun 2003 07:06:48 GMT

Re:Multi users and updates!


Brian,

What event do you write this code for. When I try to do a before post event,
I get "133. Cannot assign to a read-only property"

If fact when I try to run this code any where I still get
'133. Cannot assign to a read-only property'

If you could give us some examples, it would help out alot of people here.

Many Thanks,

RF - ARS Motorola
"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:k79i5tgvks43dhmlhfrl0renbp4oosbkns@4ax.com...

Quote

> >Using the BDE I was able to see the where clause to Key only, but I don't
> >seem to have this option with ADO,  How to I get around this problem.

> Try
> ADODataSet1.Properties['Update Criteria']:=adCriteriaKey;

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Brian Bushay Team

Delphi Developer
Sat, 28 Jun 2003 14:23:13 GMT

Re:Multi users and updates!


Quote
>What event do you write this code for. When I try to do a before post event,
>I get "133. Cannot assign to a read-only property"

>If fact when I try to run this code any where I still get
>'133. Cannot assign to a read-only property'

>If you could give us some examples, it would help out alot of people here.

here is a Microsoft reference
http://support.microsoft.com/support/kb/articles/Q190/7/27.ASP

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Brian Bushay Team

Delphi Developer
Sat, 28 Jun 2003 14:23:14 GMT

Re:Multi users and updates!


Quote
>It says that its readonly, I cannot left assign.    Too bad, it looked
>right!

Maybe if I had given you the correct syntax.
Try
ADODataSet1.Properties['Update Criteria'].value := adCriteriaKey;
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com
Phil

Delphi Developer
Sat, 28 Jun 2003 22:33:29 GMT

Re:Multi users and updates!


AH, Darn,, I should have figured that out...  Damn....  *lowers head in
shame*

Thank you, it works greate!  Thats exactly what I wanted!!  *bows infront of
the master*

Now if only I could figure out how you can read Microsoft's SDK :)

Thanks again,

Phil C.

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:hv8l5t4n2nq8a59gmlr8gaabq8pf0a460n@4ax.com...

Quote

> >It says that its readonly, I cannot left assign.    Too bad, it looked
> >right!

> Maybe if I had given you the correct syntax.
> Try
> ADODataSet1.Properties['Update Criteria'].value := adCriteriaKey;
> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

David Scheid

Delphi Developer
Mon, 30 Jun 2003 08:52:52 GMT

Re:Multi users and updates!


Ok, this works for Access (Jet Engine), but does it work for SQL Server
2000?

Thanks,
- David Scheidt

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:k79i5tgvks43dhmlhfrl0renbp4oosbkns@4ax.com...

Quote

> >Using the BDE I was able to see the where clause to Key only, but I don't
> >seem to have this option with ADO,  How to I get around this problem.

> Try
> ADODataSet1.Properties['Update Criteria']:=adCriteriaKey;

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

Brian Bushay Team

Delphi Developer
Tue, 01 Jul 2003 11:18:57 GMT

Re:Multi users and updates!


Quote
>Ok, this works for Access (Jet Engine), but does it work for SQL Server
>2000?

I don't have SQL Server 2000 to test it but I don't see anything in Microsoft's
documentation to indicate it is not supported.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

David Scheid

Delphi Developer
Tue, 01 Jul 2003 22:31:25 GMT

Re:Multi users and updates!


Ok, I set up a simple test.  It works fine for Access using the Jet 4.0
engine.  SQL Server gives the error 'Can't find record'.  It appears to be
ignoring the properity.

- David Scheidt

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:q8ns5t8e7dii8gefdnrl64opducignr300@4ax.com...

Quote

> >Ok, this works for Access (Jet Engine), but does it work for SQL Server
> >2000?
> I don't have SQL Server 2000 to test it but I don't see anything in
Microsoft's
> documentation to indicate it is not supported.

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

arsradi

Delphi Developer
Wed, 02 Jul 2003 00:09:01 GMT

Re:Multi users and updates!


Brian,

I agree with David,

This will work with Access, but will not work with SQL2000.

Are there any other settings that we need to be aware of ???

Thanks

RF - ARS Motorola

Quote
"David Scheidt" <dsche...@hotmail.com> wrote in message

news:3a5f15ad$1_1@dnews...
Quote
> Ok, I set up a simple test.  It works fine for Access using the Jet 4.0
> engine.  SQL Server gives the error 'Can't find record'.  It appears to be
> ignoring the properity.

> - David Scheidt

> "Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
> news:q8ns5t8e7dii8gefdnrl64opducignr300@4ax.com...

> > >Ok, this works for Access (Jet Engine), but does it work for SQL Server
> > >2000?
> > I don't have SQL Server 2000 to test it but I don't see anything in
> Microsoft's
> > documentation to indicate it is not supported.

> > --
> > Brian Bushay (TeamB)
> > Bbus...@NMPLS.com

Brian Bushay Team

Delphi Developer
Thu, 03 Jul 2003 01:48:16 GMT

Re:Multi users and updates!


Quote
>I agree with David,
>This will work with Access, but will not work with SQL2000.
>Are there any other settings that we need to be aware of ???

All I can tell you is that it works fine with MSSQL 7.0

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Delphi 2.0: Multi-User Paradox Table updating problem....

2. Multi-user application database updates...

3. Cached updates and multi-user

4. Errors with Multi User Update...

5. Multi-user paradox table updates.

6. Problem with table updates in a multi-user environment

7. Updating Paradox Table views for multi-user application

8. Multi-user updates

9. Multi-user Paradox app not updating

10. Multi-user, update notification, which record changed ?