Hi Folks
There is something wrong in the 2nd last line because of which the insert statement is not coming out right, can someone please help me
Thanks
my $SQL_Insert ="INSERT INTO summary VALUES ('" .
$LastDayOfMonth . "', " .
$summrow{'id'} . ',' .
$summrow{'alimit'} . ',' .
$summrow{'mlimit'} . ',' .
$summrow{'threshold'} . ',' .
"NEXTVAL('_seq_summary_'),' .
$summrow{'ttsls'})";
There is something wrong in the 2nd last line because of which the insert statement is not coming out right, can someone please help me
Thanks
my $SQL_Insert ="INSERT INTO summary VALUES ('" .
$LastDayOfMonth . "', " .
$summrow{'id'} . ',' .
$summrow{'alimit'} . ',' .
$summrow{'mlimit'} . ',' .
$summrow{'threshold'} . ',' .
"NEXTVAL('_seq_summary_'),' .
$summrow{'ttsls'})";