Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
>>I don't think so. With GROUP BY you can combine results from several records in a group, including sums, but I don't think that string concatenation is possible. I suggest you write UDF, which you then invoke from the query.
>
>Thanks for the reply!
>
>
>I didn't expect to have one. Thought, I would pick the brains of VFP gurus. No luck there.
>
>I've resorted to select the records into an array, then the array into a string.
You could also use the "TO MyFile.txt" clause in the SQL and then use FileToStr() to put into a variable.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only