G'Day,

Env: ADO - SQL7
       BDE - Paradox

I have either a TADOQuery or a TQuery listing some records linked to a db
grid. What is the most elegant way to tell if a record is locked __before__
the user edits the record? A nice to have, but not essential would be to be
able to colour the grid showing any records that are locked. I realise this
is non-trivial given the multitude of cursor options etc. etc. but some
pointers would be really appreciated....

I would prefer not to have to do:

try
  TheDataSet.Edit;
  .....
  TheDataSet.Post;
except
  //Handle exception when posting record and it is locked
end;

------------------------------------------------------------------------
--Donovan [[EMAIL PROTECTED]]
Donovan J. Edye [www.edye.wattle.id.au]
Namadgi Systems, Delphi Developer [www.namsys.com.au]
Voice: +61 2 6285-3460 Fax: +61 2 6285-3459
TVisualBasic = Class(None);
Heard just before the 'Big Bang': "...Uh Oh...."
------------------------------------------------------------------------
GXExplorer [http://www.gxexplorer.org] Freeware Windows Explorer
replacement. Also includes freeware delphi windows explorer components.
------------------------------------------------------------------------

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"

Reply via email to