Gossamer Forum
Home : Products : DBMan SQL : Discussion :

DbMan and SQL Triggers

Quote Reply
DbMan and SQL Triggers
I have a standard database addition script that works correctly (record is added to SQL and a return "add_success" screen appears). When I add a field trigger to the MSSQL database the data is inserted into the DB and the trigger completes (it does what it is supposed to do) but then I get an error screen back from DbMan (See below).

My Question: Does DbMan require some type of "completion OK" back from the SQL server and could my DB trigger be preventing that? Can I just have my trigger respond back with the data that DbMan needs (eg. a return value)?

Code:
A fatal error has occured:

Can't use an undefined value as a HASH reference at Dbsql::Home::add_success line 21.

Stack Trace
======================================
Dbsql (2756): Dbsql::Home::add_success called at Dbsql::Home::add_record line 30 with arguments
(Dbsql::Home=HASH(0x80fba1c), 27).
Dbsql (2756): Dbsql::Home::add_record called at /users/a/allied/public_html/code/admin/GT/Plugins.pm line 165 with arguments
(Dbsql::Home=HASH(0x80fba1c)).
Dbsql (2756): GT::Plugins::dispatch_method called at /users/a/allied/public_html/code/admin/Dbsql/Home.pm line 82 with arguments
(GT::Plugins, /users/a/allied/public_html/code/admin/Plugins/Dbsql, add_record, Dbsql::Home=HASH(0x80fba1c), add_record).
Dbsql (2756): Dbsql::Home::process called at /users/a/allied/public_html/code/db.cgi line 29 with arguments
(Dbsql::Home=HASH(0x80fba1c), in, GT::CGI=HASH(0x848980c), sql, GT::SQL=HASH(0x84a32fc), cfg, Dbsql::Config=HASH(0x81f6978)).
Dbsql (2756): main::main called at /users/a/allied/public_html/code/db.cgi line 22 with no arguments.


System Information
======================================
Perl Version: 5.006001
DBMan SQL Version: 2.1.0
DBI.pm Version: 1.32
@INC =
/users/a/allied/public_html/code/admin
/usr/lib/perl5/5.6.1/i386-linux
/usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i386-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.6.1/i386-linux
/usr/lib/perl5/vendor_perl/5.6.1
/usr/lib/perl5/vendor_perl
.

CGI INPUT
======================================
Confirm => true
Diagnosis => 844.8
FName => Alyssa
FirstTreatment => 05/10/2003
Goals =>
History =>
LName => Wilson
Onset => 05/07/2003
PatientID => 000000-alyssawil
Progress => Processing Initial Visit...
Rationale =>
Username => 000000
Visitscomplete => 2
Visitsreason =>
db => Claims
do => add_record
sid => 46f1b979affec90c9f7082c72fe0a010
submit.x => 63
submit.y => 17
Subject Author Views Date
Thread DbMan and SQL Triggers LanceWilson2 3030 May 27, 2003, 9:09 AM
Thread Re: [LanceWilson2] DbMan and SQL Triggers
604 2903 May 30, 2003, 9:53 AM
Thread Re: [TheStone] DbMan and SQL Triggers
LanceWilson2 2906 May 30, 2003, 10:05 AM
Thread Re: [LanceWilson2] DbMan and SQL Triggers
604 2889 May 30, 2003, 11:23 AM
Thread Re: [TheStone] DbMan and SQL Triggers
LanceWilson2 2900 May 30, 2003, 12:02 PM
Post Re: [LanceWilson2] DbMan and SQL Triggers
604 2901 May 30, 2003, 12:09 PM