Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to display the procedure source code from a database.
The problem I'm having is that the database is giving me the source code line by line.
So I currently have something like this..
Name line text
A 1 start
A 2 begin
A 3 blahblahblah
B 1 start
B 2 end
So for example, if I select A
I want it to show in a text box formatted as:
start
begin
blahblahblah
while if i select B:
start
end
Any method would be awesome.
Is there anything i can do maybe even in the script so i can only get
Name Text
A start (newline) begin (newline) blahblahbalh
B start(newline) end(newline)
Thanks!
If the line field determines the order: concat(distinct [Text], chr(10), line)
Try concat(distinct [Text], chr(10))
it doesn't seem to be in order
If the line field determines the order: concat(distinct [Text], chr(10), line)