• 0

ODBC and triggers


Question

Howdy all,

I need to create a trigger any time an item gets added or updated on the following table:

--
-- Table structure for table `PWPRD`
--

`PRD_ID` int(11) NOT NULL COMMENT 'Product ID',
`PRD_NAME` varchar(255) NOT NULL COMMENT 'Product Name',
`PRD_DESC` text NOT NULL COMMENT 'Product Definiition',

The trigger should take the PRD_ID and add a new row into this table:

TABLE modified_products

prd_id - int(11)
source_table varchar(10)

I use php to connect to the system using ODBC. The system inquestion is an IBM AS/400.

Do you guys have any ideas on this one ? Never had to right a trigger before, and it seems if you are doing it via ODBC the syntax is different from MySQL (for obvious reasons).

Thanks.

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.