--- In
vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> >
> > I figured it out after many googling and furrowing of the brow.
> >
> > I added a doc file to the files section under Tutorials with my
> > notes. Hopefuly this will help someone.
>
> Did you get the screen shots I sent you offline?
>
> Mark W.
>
Got them thanks. If I was still stuck they would have gotten me what I
needed. What got me final bit of the info was a post on psdn.com.
Actually I was able to do nearly the same things with the ODBC to JDBC
connections in SQUirrel and RazorSQL without the progress specific
info. What I was missing with the ODBC to JDBC connections was the
ability to make procedures, but it looks like that is somewhat useless
for me at the current stage, I was hoping to make sql/dml procedures,
and it looks the progress procedures are in java. For my current
project I'm skipping java and do what I need to do in visual basic.
I'm working on a application that will generate sql/dml code to update
the QuoteOpDtl table. After our conversion from 6 to 8.3 all the quotes
have had their "over ride rates" check box checked. I'm going to
generate a bunch of sql/dml (need to alter 100,000 rows) to uncheck
that box and re-set the rates from using the default rates in the
resource group.
Here's what it will end up looking like:
What I get out of SQUirrel
10|1002|1|0|40|10|MILL|250|300|250|300
What I kick out of visual basic
UPDATE MFGSYS.PUB.QuoteOpDtl SET SetupBurRate = 250, SetupLabRate =300,
ProdBurRate = 250, ProdLabRate = 300, OverrideRates = 0 WHERE Company
= '10' and QuoteNum = 1002 AND QuoteLine = 1 AND AssemblySeq = 0 AND
OprSeq = 40 AND OpDtlSeq = 10;
Simple stuff but will save a lot of time, now to do testing to make
sure it doesn't blow up the database.