Query on progress data

[ToneSta]

I have a table as below:

Code Text Sequence
------ --------------- -----------

444123 Happy 1
444123 Go 2
444123 Lucky 3

I would like to run a query that will return the following:

Code Text
------ ----------------

222123 Happy Go Lucky

I'm hoping that this is possible, but haven't found a way as yet. I am using VCQ (Visual Cyberquery) application to interogate a progress database.

Anyone have any ideas????

Thanks

 

[richtpt]

Have you tried contacting Cyberscience? I have never used their product, but I have chatted with them and others who use VCQ and have heard excellent things about their support.

I'm not sure how to do this with VCQ, or with some basic 4GL query. Off the top of my head, you'd have to create a variable (say vcText), do a for each by the sequence then add each text to the var, something like this:

def var vcText as char no-undo.

for each table no-lock
by table.sequence:
assign vcText = vcText + table.text + " ".
end.

disp vcText.


Sorry if that's not any help.

Rich