Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Get tablename from Query
Fri, May 14 2010 12:03 PMPermanent Link

Thomas Grimm

Hello,

in a dbisamquery i load frequently some statements like

UPDATE abc SET ...
UPDATE def SET ...
UPDATE ghi SET ...
DELETE FROM abc WHERE..

and so on. How do i get the name of the table that is target of the operation. i wanna log this in OnAfterPost and OnBeforeDelete events. I need that for component writing in this way

TxxQuery = class(TDBISAMQuery)
 private
 ...
 protected
   procedure DoAfterPost; override;
  ...
 end;

Solution should work in a V2.12 environment Frown

thanks
Mon, May 17 2010 4:01 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Thomas,

<< Solution should work in a V2.12 environment Frown>>

That's going to be an issue for 2.x.  DBISAM 4.x has this property:

http://www.elevatesoft.com/manual?action=viewprop&id=dbisam4&product=d&version=7&comp=TDBISAMQuery&prop=TableName

--
Tim Young
Elevate Software
www.elevatesoft.com
Image