SELECT DisplayName, LIST(License)
FROM "Memory\TempRep"
GROUP BY DisplayName

to display:

<displayName> ; <LIST(License)>
John Doe ; 24, 63, 7, Insurance

\TempRep contains
JohnDoe ; 24
JohnDoe ; 63
JohnDoe ; 7
JohnDoe ; Insurance

Regards,
Scott.

No way that I know of, though I only use DBISAM 3.3. I use procedures within Delphi to
create the types of data you are talking about.

It would be great if DBISAM could do that.

Adam

Scott,

<< SELECT DisplayName, LIST(License) >>

A custom SQL function called LIST() could do the trick for you.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wow, thanks!

Scott.

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:7C2BD8F3-572B-446F-BCBF-074FED8F102C@news.elevatesoft.com...
> Scott,
>
> << SELECT DisplayName, LIST(License) >>
>
> A custom SQL function called LIST() could do the trick for you.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Hi Tim,

> << SELECT DisplayName, LIST(License) >>
>
> A custom SQL function called LIST() could do the trick for you.

That'd be some sort of custom function wouldn't it? Aren't we talking about
a pivot statement, or have I missed something?

If so - I'd be very happy. I've had to use TXQuery so far to perform pivot
statements on DBISam.

Cheers

Adam.

Scott,

<< Wow, thanks! >>

Okay, as soon as I read your response and Adam's I knew that I said
something wrong.  I read your example too quickly and thought that you
were just wanting to dump out a comma-separated list, when in actuality what
you want is an aggregate function, and those cannot be done with custom
functions, unfortunately.

Sorry about that.

--
Tim Young
Elevate Software
www.elevatesoft.com