sql statement for powerhouse

[Viet Nguyen]

Thank you - this worked fine.

Viet.

 

 

-----Original Message-----
From: Joe Boyle [mailto:atla38 at dsl.pipex.com] 
Sent: Monday, May 01, 2006 5:03 PM
To: Viet Nguyen; powerh-l at lists.sowder.com
Subject: RE: sql statement for powerhouse

 

try something like,

 

acc * subfile

sql in sqldb delete from TestFile where TestFile.key = :key of subfile

 

Regards, Joe. 

________________________________

From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On
Behalf Of Viet Nguyen
Sent: 01 May 2006 20:56
To: powerh-l at lists.sowder.com
Subject: sql statement for powerhouse

 

 

Hi All, Could someone help me convert a powerhouse qtp statement to SQL
statement in powerhouse

 

My code is like this:

*subfile has 1 field key = integer

TestFile has 1 field key = integer

Access *subfile link  key viaindex key to TestFile in sqldb

Output TestFile Delete

 

How do I convert this to an SQL statement in powerhouse to accomplish
something like this:

 

Delete from testfile where testfile.key = *subfile.key

 

 

 

Thanks.

Viet.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060502/aa498df3/attachment.htm