vb with odbc

[jonathandrott]

I'm new to using two databases at the same time with my vb program. I
have a db named InvoiceProcessing that has two fields UPC and ItemDesc.
UPC is populated, but ItemDesc needs to be filled from db2 (ILSA)
(with fields PLU_NUM and PLU_DESC) i need to fill ItemDesc with the
info in PLU_DESC based on the comparison of UPC and PLU_NUM. I don't
even know where to start. Thanks.

[rowe_newsgroups]

Check out the System.Data.ODBC namespace and also lookup the keywords
"dataset" and "dataadapter"

Thanks,

Seth Rowe
[e-mail] wrote:

I'm new to using two databases at the same time with my vb program. I
have a db named InvoiceProcessing that has two fields UPC and ItemDesc.
UPC is populated, but ItemDesc needs to be filled from db2 (ILSA)
(with fields PLU_NUM and PLU_DESC) i need to fill ItemDesc with the
info in PLU_DESC based on the comparison of UPC and PLU_NUM. I don't
even know where to start. Thanks.

[jonathandrott]

I actually know how to connect to the databases through odbc. I need
help with the sql syntax. sorry for being vague :)
rowe_newsgroups wrote:

Check out the System.Data.ODBC namespace and also lookup the keywords
"dataset" and "dataadapter"

Thanks,

Seth Rowe
[e-mail] wrote:

I'm new to using two databases at the same time with my vb program. I
have a db named InvoiceProcessing that has two fields UPC and ItemDesc.
UPC is populated, but ItemDesc needs to be filled from db2 (ILSA)
(with fields PLU_NUM and PLU_DESC) i need to fill ItemDesc with the
info in PLU_DESC based on the comparison of UPC and PLU_NUM. I don't
even know where to start. Thanks.

[rowe_newsgroups]

Just to clarify: Do you have one database with two tables
(InvoiceProcessing and ILSA)? If so what type of database are you using
(SQL Server, Access, Oracle, etc...)?

Thanks,

Seth Rowe
jo***********@gmail.com wrote:

I actually know how to connect to the databases through odbc. I need
help with the sql syntax. sorry for being vague :)
rowe_newsgroups wrote:

Check out the System.Data.ODBC namespace and also lookup the keywords
"dataset" and "dataadapter"

Thanks,

Seth Rowe
[e-mail] wrote:

I'm new to using two databases at the same time with my vb program. I
have a db named InvoiceProcessing that has two fields UPC and ItemDesc.
UPC is populated, but ItemDesc needs to be filled from db2 (ILSA)
(with fields PLU_NUM and PLU_DESC) i need to fill ItemDesc with the
info in PLU_DESC based on the comparison of UPC and PLU_NUM. I don't
even know where to start. Thanks.

[jonathandrott]

two seperate db's and they are both access
rowe_newsgroups wrote:

Just to clarify: Do you have one database with two tables
(InvoiceProcessing and ILSA)? If so what type of database are you using
(SQL Server, Access, Oracle, etc...)?

Thanks,

Seth Rowe
jo***********@gmail.com wrote:

I actually know how to connect to the databases through odbc. I need
help with the sql syntax. sorry for being vague :)
rowe_newsgroups wrote:

Check out the System.Data.ODBC namespace and also lookup the keywords
"dataset" and "dataadapter"
>
Thanks,
>
Seth Rowe
>
>
[e-mail] wrote:
I'm new to using two databases at the same time with my vb program. I
have a db named InvoiceProcessing that has two fields UPC and ItemDesc.
UPC is populated, but ItemDesc needs to be filled from db2 (ILSA)
(with fields PLU_NUM and PLU_DESC) i need to fill ItemDesc with the
info in PLU_DESC based on the comparison of UPC and PLU_NUM. I don't
even know where to start. Thanks.

[rowe_newsgroups]

Since you don't seem to comfortable with SQL, I'll teach you a little
trick. Open up one of the access databases and add a linked table that
points to the other table in the other database. Then build your query
in "design view" making sure you set the query type to update. After
you get what you want then switch to SQL view and voila - you have your
SQL string. Basically, if I read your post right your sql should be
something like:

<pseudocode>

UPDATE InvoiceProcessing
SET ItemDesc = PLU_DESC
WHERE UPC = PLU_NUM
AND UPC = 'Your Condition'

</pseudocode>

Just a warning - I wrote that really quick so be careful. Also you
might want to use the OleDb namespace instead of Odbc for Access
connections.

Thanks,

Seth Rowe
jo***********@gmail.com wrote:

two seperate db's and they are both access
rowe_newsgroups wrote:

Just to clarify: Do you have one database with two tables
(InvoiceProcessing and ILSA)? If so what type of database are you using
(SQL Server, Access, Oracle, etc...)?

Thanks,

Seth Rowe
jo***********@gmail.com wrote:

I actually know how to connect to the databases through odbc. I need
help with the sql syntax. sorry for being vague :)
rowe_newsgroups wrote:
Check out the System.Data.ODBC namespace and also lookup the keywords
"dataset" and "dataadapter"

Thanks,

Seth Rowe


[e-mail] wrote:
I'm new to using two databases at the same time with my vb program. I
have a db named InvoiceProcessing that has two fields UPC and ItemDesc.
UPC is populated, but ItemDesc needs to be filled from db2 (ILSA)
(with fields PLU_NUM and PLU_DESC) i need to fill ItemDesc with the
info in PLU_DESC based on the comparison of UPC and PLU_NUM. I don't
even know where to start. Thanks.

[Steve Long]

Access is so sweet for that. It will usually, at least, get you started in
the right direction.
"rowe_newsgroups" <ro********@yahoo.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...

Since you don't seem to comfortable with SQL, I'll teach you a little
trick. Open up one of the access databases and add a linked table that
points to the other table in the other database. Then build your query
in "design view" making sure you set the query type to update. After
you get what you want then switch to SQL view and voila - you have your
SQL string. Basically, if I read your post right your sql should be
something like:

<pseudocode>

UPDATE InvoiceProcessing
SET ItemDesc = PLU_DESC
WHERE UPC = PLU_NUM
AND UPC = 'Your Condition'

</pseudocode>

Just a warning - I wrote that really quick so be careful. Also you
might want to use the OleDb namespace instead of Odbc for Access
connections.

Thanks,

Seth Rowe
jo***********@gmail.com wrote:

>two seperate db's and they are both access
rowe_newsgroups wrote:

Just to clarify: Do you have one database with two tables
(InvoiceProcessing and ILSA)? If so what type of database are you using
(SQL Server, Access, Oracle, etc...)?

Thanks,

Seth Rowe
jo***********@gmail.com wrote:
I actually know how to connect to the databases through odbc. I need
help with the sql syntax. sorry for being vague :)
rowe_newsgroups wrote:
Check out the System.Data.ODBC namespace and also lookup the
keywords
"dataset" and "dataadapter"

Thanks,

Seth Rowe
[e-mail] wrote:
I'm new to using two databases at the same time with my vb
program. I
have a db named InvoiceProcessing that has two fields UPC and
ItemDesc.
UPC is populated, but ItemDesc needs to be filled from db2
(ILSA)
(with fields PLU_NUM and PLU_DESC) i need to fill ItemDesc with
the
info in PLU_DESC based on the comparison of UPC and PLU_NUM. I
don't
even know where to start. Thanks.