nash
Guest
|
 Posted:
Wed May 05, 2004 8:09 am Post subject:
Re: Trigger not functioning |
|
|
fire_mail@rediffmail.com (nash) wrote in message news:<984e1fa2.0405030116.55e570cc@posting.google.com>...
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
| Quote: | 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 |
|
|
sworna vidhya
Guest
|
| Posted:
Thu May 06, 2004 5:48 am Post subject:
Re: Trigger not functioning |
|
|
fire_mail@rediffmail.com (nash) wrote in message news:<984e1fa2.0405042009.7a40789d@posting.google.com>...
| Quote: | fire_mail@rediffmail.com (nash) wrote in message news:<984e1fa2.0405030116.55e570cc@posting.google.com>...
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
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in