Re: Help! I cant get anything to INSERT INTO . . .

[Quoted] I am able to insert records from the SQL*plus prompt and from linked tables in MS Access just not from my code.

wozi <wozi_at_dhc.net> wrote in article
<E1610871110D56D5.6E5C7295AC7BAF52.379D113F0A5F2B90_at_library-proxy.airnews.ne t>...
> Have you tried to manually insert into the same table from SQL*Plus?
>
> TMSFRED wrote in message <01be8ff0$d4ffa7c0$d73aa8c0_at_tms2backup-012>...
> >I am new to Developer 2000 and I am trying to develop a small program in
> >Developer 2000. Everything works fine except when I attempt to INSERT
INTO
> >the table it gives me the following error:
> >
> >FRM_40508 UNABLE TO INSERT RECORD
> >
> >I attempt to insert from a Procedure. My code looks something like
this.
> >
> >if (...) then
> > INSERT INTO my_table (colmn1, colmn2, colmn3, colm4) VALUES(val1,
val2,
> >val3, val4);
> > COMMIT;
> >
> > Can anybody tell me what I am doing wrong.
> >
> >Thanks in Advance, TMSFRED
> >
>
>
>
Received on Mon Apr 26 1999 - 20:00:47 CEST