Hi… I created a jdbc select adapter on a table of type “SYNONYM”. here i am not getting the option of “fill in all columns” in select tab. when i inquired about this I got two solutions.
- For table type SYNONYM, use custom SQL only
- create the select adapter on the original table, fill in all the columns in ‘select’ tab later point the adapter to the SYNONYM table.
Advice me if these are the only solutions available? or which is the best practice.
I am using 6.5 version.