SPT cursor info

[davidllittle]

Is there a way to determine from the SPT cursor what underlying SQL column/tables are being affected?

Example:

Select * from Invoice I, Detail D where I.invno=D.invno

Currently looking at the result of the cursor you get duplicate fields resulting (INVNO, INVNO1) but have no way to determine what underlying SQL tables they derived from?
Did INVNO come from invoice or did INVNO1 come from invoice?
The example is bad but the idea is here.

Is there a parser or something that will associate the column back to the underlying table resulting from a SPT.

 

[tlbroadbent]

I'm not aware of any way to determine the underlying tables. For sake of avoiding this problem and increasing efficiency, it is recommended that you name the columns and only list those needed in your process. Where you have a duplicate, you can assign an alias to one or both of the columns. Terry

http://members.home.net/tlbroadbent/index.htm