Re: Row cannot be located for updating

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 08/17/04


Date: Mon, 16 Aug 2004 21:42:01 -0500


>In this instance, I'm just building a desktop application. Would some other
>settings be more appropriate?
Insufficient information
> Should I use a server side cursor?
For Access Server side cursors are Ok

>Is there a
>way to set the SQL generation to just use the key?
ADODataSet1.Properties['Update Criteria'].value :=adCriteriaKey;
http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q190727&GSSNB=1
You need AdoInit in your USES clause
>
>I've also seen some problems with "delete". I delete one record and when I
>reopen my app I find that two have been deleted instead. What would cause
>this?
I don't know any reason for this to happen

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