Hi.

Is it possible to copy the value of a detail field that is "collapsed" with
Group By into a Memo field.
IOW - If the table contains 5 records (query shows the sum of these 5 in one
record) I would like to save/list the "details" of the 5 records in a Memo
field.

Petter
Dbisam 4.30 build 7

"Petter Topp" <petter.topp@atcdata.no> wrote in message
news:B32CFF81-B0C8-4E93-9354-506677E657D4@news.elevatesoft.com...
> Hi.
>
> Is it possible to copy the value of a detail field that is "collapsed"
> with Group By into a Memo field.
> IOW - If the table contains 5 records (query shows the sum of these 5 in
> one record) I would like to save/list the "details" of the 5 records in a
> Memo field.
>

I don't know of a way to do this while you're running the aggregate
function, maybe somebody else does, but you should be able to do it with a
script as in (pseudocode)

select id as gid, sum (amount) as gsum, cast('' as memo) gdetails into
gtable from table group by 1;
create index on gtable;
update gtable set gdetails = gdetails + amount from gtable
join table on id=gidl

Robert

Petter


First a sales pitch for ElevateDB - this is easy using LIST

Back to reality. Until Tim introduced LIST in ElevateDB anytime I needed something like this I ended up using Delphi.

If this is for a report then it may be possible to do something with the main query and a master-detail link.

Roy Lambert [Team Elevate]

Hi Guys.

The need is actaually for an import routine - so I guess that I will go the
scripting way....
As for ElevateDB, I already have the CS license - but never seem to get on
top of my project to start "Elevate it"

Thanks
Petter

"Petter Topp"  skrev i nyhetsmeldingen:
B32CFF81-B0C8-4E93-9354-506677E657D4@news.elevatesoft.com ...

Hi.

Is it possible to copy the value of a detail field that is "collapsed" with
Group By into a Memo field.
IOW - If the table contains 5 records (query shows the sum of these 5 in one
record) I would like to save/list the "details" of the 5 records in a Memo
field.

Petter
Dbisam 4.30 build 7

> First a sales pitch for ElevateDB - this is easy using LIST
>

You could always use the DBISAM 4 LIST Function <bg>

John

John

>You could always use the DBISAM 4 LIST Function <bg>

I wondered about that. My DBISAM is stuck at 4.25 so I don't know about new features.

Roy Lambert

Roy
>
> I wondered about that. My DBISAM is stuck at 4.25 so I don't know about new features.
>

I refer you to a thread 5/5/10 in this group

John

John


>> I wondered about that. My DBISAM is stuck at 4.25 so I don't know about new features.
>>
>
>I refer you to a thread 5/5/10 in this group

Fair enough - I refer you to my reply

"Shows how out of date I am. I didn't know that had been back ported."

Why should I change my mind now?

Roy Lambert

Petter,

<< Is it possible to copy the value of a detail field that is "collapsed"
with Group By into a Memo field. >>

As John indicated, you can use the LIST aggregate function for this:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Functions

--
Tim Young
Elevate Software
www.elevatesoft.com