Is GROUP BY Concatenated fields possible in Paradox SQL??? 
Author Message
 Is GROUP BY Concatenated fields possible in Paradox SQL???

Eg:

Select (Emp.Title||''||Emp.Name) as EmpName, sum(Amount) from Emp
Group By (Emp.Title||''||Emp.Name) as EmpName

Above is my Paradox SQL Query and I only get the message that capability
not supported (where as the same works smoothly with SQL Server 2000).

( Same message even if i change it to:

Select (Emp.Title||''||Emp.Name), sum(Amount) from Emp
Group By (Emp.Title||''||Emp.Name)

)

Has any one come across this situation? I would appreciate some
suggestions on getting this to work

Thanx in advance,
Shafeeq.
--
Direct access to this group with http://www.***.com/
http://www.***.com/



Mon, 19 Dec 2005 17:04:46 GMT
 Is GROUP BY Concatenated fields possible in Paradox SQL???

I see the exact same post in paradox-discussions, crossposting is not a
good idea.

- Veronica

Quote:

> Eg:

> Select (Emp.Title||''||Emp.Name) as EmpName, sum(Amount) from Emp
> Group By (Emp.Title||''||Emp.Name) as EmpName

> Above is my Paradox SQL Query and I only get the message that capability
> not supported (where as the same works smoothly with SQL Server 2000).

> ( Same message even if i change it to:

> Select (Emp.Title||''||Emp.Name), sum(Amount) from Emp
> Group By (Emp.Title||''||Emp.Name)

> )

> Has any one come across this situation? I would appreciate some
> suggestions on getting this to work

> Thanx in advance,
> Shafeeq.



Mon, 19 Dec 2005 17:45:04 GMT
 Is GROUP BY Concatenated fields possible in Paradox SQL???
Hi
Im sorry about the cross posting,
but I still couldnt locate any such article. Would you mind pointing me
to that one. Guess there is some solution to that behaviour.

Thnx
Shafeeq.

Quote:

> I see the exact same post in paradox-discussions,
> crossposting is not a
> good idea.

> - Veronica


>> Eg:

>> Select (Emp.Title||''||Emp.Name) as EmpName, sum(Amount) from Emp
>> Group By (Emp.Title||''||Emp.Name) as EmpName

>> Above is my Paradox SQL Query and I only get the message
>> that capability
>> not supported (where as the same works smoothly with SQL
>> Server 2000).

> etc..

--
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.paradox


Tue, 20 Dec 2005 13:44:32 GMT
 Is GROUP BY Concatenated fields possible in Paradox SQL???
It was you that posted in paradox-discussion as well? I was trying to
point out that posting in two forums generally is not helpful for either
you or the people that try to answer your questions.
Quote:

> Hi
> Im sorry about the cross posting,
> but I still couldnt locate any such article. Would you mind pointing me
> to that one. Guess there is some solution to that behaviour.

> Thnx
> Shafeeq.


>>I see the exact same post in paradox-discussions,
>>crossposting is not a
>>good idea.

>>- Veronica


>>>Eg:

>>>Select (Emp.Title||''||Emp.Name) as EmpName, sum(Amount) from Emp
>>>Group By (Emp.Title||''||Emp.Name) as EmpName

>>>Above is my Paradox SQL Query and I only get the message
>>>that capability
>>>not supported (where as the same works smoothly with SQL
>>>Server 2000).

>>etc..



Tue, 20 Dec 2005 15:15:59 GMT
 Is GROUP BY Concatenated fields possible in Paradox SQL???
Three forums if you include the BDE newsgroup.


Quote:
> It was you that posted in paradox-discussion as well? I was trying to
> point out that posting in two forums generally is not helpful for either
> you or the people that try to answer your questions.



Wed, 21 Dec 2005 14:34:30 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Group an SQL Stored Procedure concatenating a text field

2. concatenate varchar field from multiple rows into one row as a group

3. SQL statement grouping by a field , and ordering within a group

4. Help -- Grouping qry ---- Sub Grouping -Is this possible?

5. Concatenating datetime field and int field to make a date time

6. Merging fields - - is it possible in Paradox?

7. Concatenating fields in an SQL statement

8. Concatenate Fields in SQL Query

9. How do I concatenate fields in Interbase SQL?

10. SQL - Concatenated fields

11. grouping on a logical field in Paradox 7

12. concatenate strings in a GROUP BY select statement


 
Powered by phpBB® Forum Software