RE: [DUG]: A TADOCommand question

2001-07-22 Thread Dennis Chuah 


Catch the exception that it raises when there is an error.

Regards,
Dennis.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, 22 July 2001 02:22
 To: Multiple recipients of list delphi
 Subject: [DUG]: A TADOCommand question
 
 
 well im trying to run a quick update on a TADOCommand,
 but in case there is an error i want to retrieve the
 error message (i.e.  Violation of PrimaryKey et al),
 much like the OnReconcileError of the clientdataset
 
 is it possible to do it with a tadocommand? i dont
 want to use a table because i only need to update say
 1 in 6,
 
 tia
 
 moises
 
 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/
 --
 -
 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
 Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
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
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

RE: [DUG]: A TADOCommand question

2001-07-22 Thread Moises Lopez 

yeap, i tried, but i couldnt get that message to a
string variable

anyways, apparently the errors are stored in the
adoconnection component,


  try
adoCommand1.execute;
  except
   
ShowMessage(adoConnection1.Errors.Item[0].Description);
  end;


so, that traps the message

thnks

moises lopez





__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
---
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
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

Re: [DUG]: A TADOCommand question

2001-07-22 Thread Neven MacEwan 

Moises

Be careful because in my experiance the errors ADO returns
are very dependant on ADO Version and provider type you
may get a lot of errors occurred messages

Regards
Neven

- Original Message -
From: Moises Lopez [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Monday, 23 July 2001 12:55
Subject: RE: [DUG]: A TADOCommand question


 yeap, i tried, but i couldnt get that message to a
 string variable

 anyways, apparently the errors are stored in the
 adoconnection component,


   try
 adoCommand1.execute;
   except

 ShowMessage(adoConnection1.Errors.Item[0].Description);
   end;


 so, that traps the message

 thnks

 moises lopez





 __
 Do You Yahoo!?
 Make international calls for as low as $.04/minute with Yahoo! Messenger
 http://phonecard.yahoo.com/
 --
-
 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
 Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/


---
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
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/