sql statement for powerhouse

[Joe Boyle]

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/20060501/62558edb/attachment.html