G'day Paul,
I was first going to suggest what Mike Young did but since he beat me to the
punch (AND it did not resolve your problem) I would recommend the following
and see what happens as maybe the NULL being set to other than the default
is causing the gliche.
SET NULL -0-
>INSERT INTO scbcrse (scbcrse_subj_code,scbcrse_crse_numb,scbcrse_csta_code,
>+
> scbcrse_repeat_lim, scbcrse_tuiw_ind,+
> scbcrse_add_fees_i, scbcrse_actv_date,
>scbcrse_reps_code,scbcrse_max_rpt_u,+
> scbcrse_capp_ind ) +
> VALUES (.vnewprefix,.vcourse,.vactive, +
>.breplimit,.vprereqs, .vsfeecode,+
>.#DATE,.brepcode,.brepunits,.vbareaflag)
SET NULL ' '
-- or whatever you have it set to.
At 19:03 15/05/01 -0500, you wrote:
>does. The problem part in in larger type.
>
>INSERT INTO scbcrse (scbcrse_subj_code,scbcrse_crse_numb,scbcrse_csta_code,
>+
> scbcrse_repeat_lim, scbcrse_pwav_code, scbcrse_tuiw_ind,+
> scbcrse_add_fees_i, scbcrse_actv_date,
>scbcrse_reps_code,scbcrse_max_rpt_u,+
> scbcrse_capp_ind ) +
> VALUES (.vnewprefix,.vcourse,.vactive, +
>.breplimit,.vprereqs,, .vsfeecode,+
>.#DATE,.brepcode,.brepunits,.vbareaflag)
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 61 (0)2 9552 3311
fax: 61 (0)2 9566 2164
email: [EMAIL PROTECTED]
mobile: 0414 675 903
street: 3/66 Wentworth Park Rd Glebe NSW 2037
post: PO Box 470 Glebe NSW 2037 Australia
temp web site: 210.9.46.35
_/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/ _/ _/_/_/_/_/
_/ _/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/_/_/_/ _/ _/_/_/_/_/
_/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/ _/ _/_/_/_/_/
