Is It possible to execute direct SQL statement with Adapter generated by LLBL? I could not find anything in docs. I know this is discouraged but some update with subquery is needed and i don't want to write a stored proc for just one SQL statement.

BTW I am using SQL server

Please refer to this thread:

http://www.sd.nl/TinyForum/Messages.aspx?ThreadID=3720

If this thread does not address your question or if you still have questions please get back to us.

Walaa wrote:

Please refer to this thread:

http://www.sd.nl/TinyForum/Messages.aspx?ThreadID=3720

If this thread does not address your question or if you still have questions please get back to us.

Not much help... Code I want execute is like:

update SomeTable
set SomeTable.QuantityOrderedByPurchase=SubSelect.PurchaseOrderQuantity
FROM (
SELECT poi.ArticleID as ArticleID , SUM(poi.PurchaseOrderQuantity) as PurchaseOrderQuantity
FROM PurchaseOrderItem poi
GROUP BY poi.ArticleID 
) SubSelect
Where SomeTable.ArticleID =SubSelect.ArticleID 
GO

Currently that's not supported.

Otis wrote:

Currently that's not supported.

Are there any plans to support direct SQL execution using the same transaction in Adapter?

Andrius wrote:

Otis wrote:

Currently that's not supported.

Are there any plans to support direct SQL execution using the same transaction in Adapter?

Yes, subselects in update statements and subselects in from clauses are planned.