BorlandTalk.com

Alex · Guest

Hello

I have an SQL statement:
SELECT tblProducts.Name, tblProducts.Description,
tblProducts.SuggestedUsage, tblProducts.PartNumber,
tblProducts.CategoryID, tblProducts.SubCategoryID,
tblProducts.VendorID, tblProducts.VendorPrice,
tblProducts.VendorPartNumber, tblProducts.Precaution,
tblProductsDetail.Size, tblProductsDetail.Price,
tblProductsDetail.Type, tblProductsDetail.QtyOnHand,
tblProductsDetail.IngredientName, tblProductsDetail.IngredientAmount,
tblProductsDetail.AmountType, tblProductsDetail.SuperIngredient,
tblProductsItemDetail.ProductID, tblProductsItemDetail.Size,
tblProductsItemDetail.Price, tblProductsItemDetail.Type
FROM (tblProducts INNER JOIN tblProductsDetail ON tblProducts.ProductID
= tblProductsDetail.ProductID) INNER JOIN tblProductsItemDetail ON
tblProducts.ProductID = tblProductsItemDetail.ProductID;

When I insert this into the ADODataset with a connection and set
active=true

I get a messagebox "Unspecified error"

If I change the statement to a simpler one like "Select * from
tblProducts"
it works and the TDatasetProducer works also

I am guessing its a problem with ADO or something ..
any suggestions on this?

Riki Wiki · Guest

On 22 Jun 2006 07:09:59 -0700, Alex wrote: