sql statement for powerhouse

Viet Nguyen VNguyen at wsboces.org
Mon May 1 14:55:54 CDT 2006


 

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/73e1becf/attachment.html


More information about the powerh-l mailing list