Halenger

OLEDB Table Queries in AF

Discussion created by Halenger Champion on Dec 10, 2012
Latest reply on Dec 10, 2012 by Asle Frantzen

This may need to be with TechSupport instead of here, but I'm wondering if I'm missing something when it comes to writing OLEDB table queries in AF??  Does the query have to be written as one line?  Or is there another place to input/write the code to link the query with the table?  This piscture might help explain what I'm getting at:

 

2555.AF_5F00_OLEDB-Table-Query.png

 

I like to write the queries in PI SQL Commander to verify they work before creating the table (template(s)), but then I have to go make the code all one line...  Am I missing something??  Thanks in advance!

Outcomes