get DB results from inner join update

2 May 2007 12:37 AM

Rick

VS 2005 & Firebird DB 1.5

I have a query for Customer orders that has several inner joins to show
things like Terms name (from termsnum) and Sales Rep name (from repnum) etc.

I have written the custom SQL insert statement and this works with no
problem, but I want to get the updated values back from the DB for the inner
joins. When I add a new row, it appears in a datagridview, but all the inner
join fields are missing. I know I could refresh the entire query, but this
can be several hunded rows so I would rather just refresh the newly added
row and show it. How?

TIA

Rick

2 May 2007 10:43 AM

Rick

Well, I have figured out a way to do this:

I wrote a get method of the adapter to return a datatable with the new row
based on the PK. Then I datatable.merge(<new datatable>).

I'm not sure if this is the best way to acomplish this, so if anyone has a
better method please let me know.

Rick

Show quoteHide quote

"Rick" <R***@LakeValleySeed.com> wrote in message
news:u1skvJFjHHA.4768@TK2MSFTNGP05.phx.gbl...
> VS 2005 & Firebird DB 1.5
>
> I have a query for Customer orders that has several inner joins to show
> things like Terms name (from termsnum) and Sales Rep name (from repnum)
> etc.
>
> I have written the custom SQL insert statement and this works with no
> problem, but I want to get the updated values back from the DB for the
> inner joins. When I add a new row, it appears in a datagridview, but all
> the inner join fields are missing. I know I could refresh the entire
> query, but this can be several hunded rows so I would rather just refresh
> the newly added row and show it. How?
>
> TIA
>
> Rick
>

9 May 2007 2:25 AM

Earl

A better way to do that is without the inner joins, instead using multiple
tables and expression columns. One technique I have used is to put all the
joined data in one read-only table, then use that as the parent for the
expression columns in the datatable where I need the "names" to show.

Show quoteHide quote

"Rick" <R***@LakeValleySeed.com> wrote in message
news:u1skvJFjHHA.4768@TK2MSFTNGP05.phx.gbl...
> VS 2005 & Firebird DB 1.5
>
> I have a query for Customer orders that has several inner joins to show
> things like Terms name (from termsnum) and Sales Rep name (from repnum)
> etc.
>
> I have written the custom SQL insert statement and this works with no
> problem, but I want to get the updated values back from the DB for the
> inner joins. When I add a new row, it appears in a datagridview, but all
> the inner join fields are missing. I know I could refresh the entire
> query, but this can be several hunded rows so I would rather just refresh
> the newly added row and show it. How?
>
> TIA
>
> Rick
>