Hi everyone... Here is a problem i've been working over today to no avail... I have 2 tables - the first table "A" contains 1 field which I will call 'item' the second table "B" contains 2 fields 'item' and 'OnOrder'.
I need a sql statement that will update the OnOrder Field from a user...
Can you reference a dsn connection table in a SQL query?
I would like to use a stored procedure to do an INSERT INTO query from an odbc dsn connection into my sql database and would like to know if this is possible.
I have a table called PurchaseOrder which contains the header information and a table called PurchaseOrderLine which contains the line information for purchase orders. I have set up an update/insert trigger on PurchaseOrderLine to update 4 different fields in PurchaseOrder - they are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.