Shulou(Shulou.com)06/03 Report--

Description

At the beginning, the record connection component encountered a problem. There were corresponding records in both AB collections, but the data field in the B collection could not be fetched after the connection.

As shown in the following figure:

Master table record set output A

Secondary table record set output B

Recordset connection output

You find that the actual records do not get the corresponding value.

Solution

After troubleshooting the SQL problem, I suddenly realized that there might be something special about this component, so I clicked on tips and found the problem: the input streams of even join must be sorted by associated key.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.