Hello,
Is there a way to code a different "Group By" depending on the value of a
parameter. For example when :My_PARAM = 1 then Group By Col1. When :My_PARAM
= 2 Then Group By Col2 etc. I have seen examples for SQL Server when I
google it but these codes don't work on DBISam. Does DBISam have an
implementation for this ?

I know that I can dynamically construct it in Delphi using the SQL.ADD but I
would prefer to do it within the SQL text property with the use of
Parameters if possible.

Regards
Gregory Sebastian
DBISam 4.27

Gregory,

<< Is there a way to code a different "Group By" depending on the value of a
parameter. >>

No, parameters can only be used in joins or the WHERE clause.

--
Tim Young
Elevate Software
www.elevatesoft.com