Trigger and ODBC Questions

Posted in 1998

Topics: Installation, Setup & Upgrades, Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Triggers, Constraints & Referential Integrity

Vince Bryden — Wed, 11 Mar 1998 06:21:45 -0500 — source: Informix-list mailing list archive (1991-1998)

Hello there all... Just a couple of questions...I downloaded the developer release of the INFORMIX 7.22 for NT from the Interware site but have these questions... 1. Is there any way to incorporate multiple action lines in a trigger statement? I thought there would be something like a begin...end statement in SQL but I keep ending up with SQL syntax errors. I assume that this would be able to be done by stored procedure but I would like to just put the multiple lines in the trigger 2. I installed the ODBC driver and go into Access to try and attach the tables that I have recently created. The dialog comes back allowing me to select the tables but when I hit OK it states that it can't find the tables ?!?!? Any hints, thoughts, etc? 3. I am a recent convert from the FABULOUS (insert sarcasm here) world of MS-SQL Server. One thing that is great about SQL Server though is the Enterprise Manager that comes with it. It is well laid out, easy to use, makes assigning permissions a breeze, etc..etc... Anything like that out there for INFORMIX? Thanks in advance for the help everyone... Vince