Strict Standards: Non-static method utf_normalizer::nfc() should not be called statically in /www/htdocs/w006661d/anddev/includes/utf/utf_tools.php on line 1781
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/session.php on line 1007: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)

Strict Standards: Non-static method utf_normalizer::nfc() should not be called statically in /www/htdocs/w006661d/anddev/includes/utf/utf_tools.php on line 1781
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4362: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4364: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4365: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 4366: Cannot modify header information - headers already sent by (output started at /includes/utf/utf_tools.php:1781)
anddev.org • View topic - Problem with trigger

Problem with trigger

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

Problem with trigger

Postby sabrine » Mon Aug 17, 2009 5:21 pm

Hello,

In a java code, I create a trigger which acts after insert in a table named contact.
This is the code:
private static final String DB_CREATE_TICONTACT =
"CREATE TRIGGER ti_contact after INSERT ON contact " +
"begin" +
" INSERT INTO tracestable VALUES ( 'contact','insert', new._idcontact, datetime());" +
" end; ";


public void addticontact(){mDb.execSQL(DB_CREATE_TICONTACT);}

The trigger is created, but when I try to insert a new values in the contact table I couldn’t, however if the trigger is deleted (or before creating it) I could!!

Could someone help me?

Thank you in advance.
sabrine
Freshman
Freshman
 
Posts: 2
Joined: Wed Jul 08, 2009 12:52 pm

Top

Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 3 guests