Trigger not functioning

Hi all,

I use an MDL application to update some work measurements in the
design file.
The values are gettting updated perfectly, but the triggers which are
supposed to get fired on this update is not getting fired.

Has anyone come across this situation? Can anyone help me arrive at a
solution?

Best Regards,
nash

 

(nash) wrote in message Hi all,

Let me rephrase my posting:

I use an MDL application to update some values in the database.The
values are gettting updated perfectly, but the triggers which are
supposed to get fired on this update are failing.

Has anyone come across this situation? Can anyone help me arrive at a
solution?

Best Regards,
nash

 

Hai Nash,
Here We are using some updations with database values. May this
following snip helps you.

sprintf(temStr, "select VIDHYA from %s where COLVALUE =
%s",tabName,columvalue);
queryFieldStatus = mdlDB_sqlQuery(tabName, temStr);
if (queryFieldStatus == SUCCESS)
{
printf(updStr, "Update TABLENAME set FIELDTOUPDATE = '%s' where
LINKCOLUMN = %d",tableName, "fieldupdatingvalue", linkcolValue);
if (mdlDB_processSQL(gSql) == SUCCESS)
{
sprintf(gUpdateFlow,"succeeded");
}
else
{
sprintf(gUpdateFlow,"failed");
}
}

Regards,
M.Sworna Vidhya