concate on field vfp

[WedHouse]

i have data like this.. utility.dbf..
user(c,5) departement(c,25) inventory(c,50) date(date) trxid(n,6)
RON supply PC sparepart 11/03/2024 112003
RON supply MOUSE 11/03/2024 113001
RON supply PC sparepart 11/03/2024 113019
RON supply KEYBOARD 15/03/2024 114021
i used indexkey on date and trxid..

i wanna ask SQL statement like excel concate function ??
user departement inventory date
RON supply PC SPAREPART, MOUSE 11/03/2024

i use SQL statement like this..
select utility.user, utility.departement, utill.inventory, utility date from utility join select(utility.inventory, utility.date from utility ;
where not empty(utility.date) group by 1,2) utill where not empty(utility.date) group by 1,2,3,4 order by 2 into cursor mutill readwrite

any sugesstion for my SQL statement above..

 

[TamarGranor]

You can't do this with just SQL in VFP. It doesn't have a way to consolidate that data. So you'll need to run the query and then use some Xbase code to loop through and consolidate. I wrote about that here:

http://www.tomorrowssolutionsllc.com/Articles/Consolidate data from a field into a list.pdf

Tamar