Recent content by Andretix

I am trying to migrate an informix database to sql server. I ran the dts and it returns with an error stateing that it cannot recognize the date format. the reason is because informix has a precision of 5 digits to the left of the decimal point for fractional time, where sql server only uses...

Here is my trigger and procedure both were created successfully on the database via dbaccess. This trigger is meant to run when a new record is added to the table. All I want it to do it update a separate field on the same table that the trigger is on. Can this not be done? [b]CREATE...

I can easily drop a trigger....but how do you delete a procedure?

below I have added the trigger that I created. Everything is working fine except the table is not updated. What I think is happening is the table has not created the record the trigger is trying to update. If i use the same trigger and hard code the apkey # it works fine. But when I use the...

I dont know what else to do....everything seems to work. The trigger created ok and the procedure was ok as well. if i query the DB the systribody table shows the trigger....but when I add records to program....nothing happens here is the trigger CREATE TRIGGER licno_trig INSERT ON aplic...

Hello everyone... Let me set the scenario Im trying to mimick an autonumber type function by creating a trigger that will populate a database field when ever a new record is added to the database. What it should do is read a table holding the next value for the field and update the...