the attached stored procedure should return a long string (field TEXT) according to the customer's specs.
Ev works ok but some data belongs to the record that cames next :)
the pseudocode is :
a. for each record in table
b. store up to 6 records data in field TEXT
c. when the total of 6 records are reached, return TEXT or
d. when field ID_ORD changes, return TEXT
The logics should be clear, albeit many fields are involved.
Please follow field SPTSER and SPTSER_ to understand what probably needs to be done.
The selected coder received the database with data.
SQL is for Firebird 1.5 .
Even if the code is easy, we prefer a well experienced coder.
The coder will try to follow the current SQL style and will return well debugged code.