Topic: Unions

Wed, 17 Dec 2008 23:16:11 GMT

Topic Description: Is there a way to do unions with QO? Looking for something that could produce results similar to this query:

SELECT MyVarCharColumn FROM [TableA] WHERE MyVarCharColumn LIKE @criteria

UNION

SELECT MyOtherVarCharColumn FROM [TableB] WHERE MyOtherVarCharColumn LIKE @criteria

ORDER BY 1

Thanks,

Thomas

Replies: 1
Last Reply: Wed, 17 Dec 2008 23:16:11 GMT
Reply By: Ish Singh

Reply: Re: Unions

Wed, 17 Dec 2008 23:16:11 GMT

Hi Thomas,

UNIONS are not directly handled by QO but you can still very easily do this. I have the sample code below:

using (Customers customer = new Customers()) 
{ 
    customer.ObjectMode = Akal.QuickObjects.ObjectBase.ObjectModes.Search; 
    customer.FirstName.StartsWith("F"); 
    customer.SetVisibleFields(true, customer.FirstName); 
 
    Products product = new Products(customer); // share the connection 
    product.ObjectMode = Akal.QuickObjects.ObjectBase.ObjectModes.Search; 
    product.ProductName.Contains("Q"); 
    product.SetVisibleFields(true, product.ProductName); 
 
    ArrayList ar = new ArrayList(); 
 
    string sql = customer.GetSelectSQL(ref ar); 
    sql = sql + " UNION " + product.GetSelectSQL(ref ar); 
    sql = sql + " ORDER BY 1"; 
    DataSet ds = customer.RunSQLReturnDataset(sql, ar); 
} 
 

Hope this helps.

Thanks,
Ish

Akal Tech RSS Feed

Topic: Unions

Reply: Re: Unions