|
| |
|
|
pd_it_guy
Posts: 97
Joined: 3/4/2008
Status: offline
 |
complex sql with database results region - 3/27/2008 16:42:24
We recently completed a project to do a relatively straightforward offload of a single table from the Informix database. All well and working OK. Now, the boss has a new task where he wants multiple tables downloaded and linked for a slightly more complicated results set. What we are finding is that the FP Database Results Wizard seems to be just fine for finding the dat asources and for the basic queries, but is a little constrained when we want to add multiple tables and work on what joins to what. Also we cannot find the greater than or equal to operator. Try to edit the bot directly to get out of doing an awkward OR statement and it wont take it. There is a proviso for custom SQL but that is a sort of a hit or miss operation and runs the very real risk of undoing all the previous formatting and column selection.
So the question is, should we even be using the DRW for the more complex queries. Can we just script them directly in. We notice that the bot script (for the data field items) is just formatting and we prefer to call the variable directly to work on.
Can anyone point us to some non DRW queries and we will see if we can make them work and incorporate them.
Thank you all very much.
|
|
|
|
pd_it_guy
Posts: 97
Joined: 3/4/2008
Status: offline
|
RE: complex sql with database results region - 3/27/2008 19:01:40
That sounds exactly like what I need to do, but unclear what you mean and how to put it on the diet??? Did not find any links.
pd_it_guy
| |
|
|
|
pd_it_guy
Posts: 97
Joined: 3/4/2008
Status: offline
|
RE: complex sql with database results region - 3/27/2008 19:06:01
Never mind I found it. Exactly what we needed to do! Thanks SO MUCH!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 