Is there a way to use user defined SQL and not have the columns defined in the column descriptor. The reason I ask is, we are using some custom sequel and find it a pain to manually type the column names and datatypes. Is there a simpler way.
Thanks
Column Description
Moderators: chulett, rschirm, roy
Column Description
Jim Stewart
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Re: Column Description
Build your sql in two steps: First step is to build your sql ( Using Read Method) using SQL Builder generated SQL; this step will provide you with columns so you do not have to type them manually. Second step is to change the Read Method to User-defined SQL, then keep the columns part and modify the rest of the sql statement.