Hi,
I have a trigger that processes changes to a table called "i_CostosBitacora". Depending on the circumstances, I would like to INSERT a row into another table "iInvKardex" to log what has happened.
If that is the case, meaning that I INSERT t...
Hi,
In version 9 of SQLAnywhere, I used to use code like this to delete all keys of a given table. In this case the table "dba.m_Batch".
BEGIN
DECLARE @DROPINDEX LONG VARCHAR;
IF EXISTS(SELECT * FROM sys.sysindexes where tname='dba.m_Bat...
I have the table below. I need to have a unique index on "IdLoc" and "IdSeq" for those records that have an "IdLoc" and "IdSeq". In other words, some transactions will have an "IdLoc" and "IdSeq" (which is a reference to another table), but some othe...
Hi,
I am having problems creating a foreign key. I am probably doing something fundamentally wrong, but can't figure out what
Below is a script that shows what I am trying to do. I want to link the table "e_dx_QueryParameter" to itself so that ...
Hi,Since this morning we have an ASA9 database terminating abnormally. This below is a portion of the console log right before the database terminates abnormally.E. 06/01 11:17:56. *** ERROR *** Assertion failed: 102203 (9.0.2.3924)E. 06/01 11:17:56...
Thanks to both.You are right Volker, the index works. I have had problems with unique keys that contain NOT NULL values and NULL values. So I assumed this wouldn't work.Thanks again!
Hi Volker,We finished rebuilding today at 5am. We had to do the process manually UNLOAD/LOAD and with some other tables we used proxy tables, and with some smaller ones we used a program called "Cross-database Studio".The system is operational ! ...
