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

Can you show here the result of this command (in SQL*Plus):

  DESCRIBE my_table;

And probably Forms by FRM_40508 error informs you about incorrectly defined block in your form.

Hope this helps.

TMSFRED wrote:
>
> 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
> > >
> >
> >
> >

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru