You have an invalid table number as the error message says.

Perhaps I don’t fully understand the issue.



On Mon, 11 Jun 2018 at 6:22 am, Jody Bevan via 4D_Tech <[email protected]>
wrote:

> Pat:
>
> Thanks for the pointer to this. We have never used the unique field
> checkbox in any of our projects. I looked through the table, and as I hoped
> - no field has the unique attribute set on.
>
> Thanks
>
> Jody
>
>
> > On Jun 10, 2018, at 2:10 PM, Pat Bensky via 4D_Tech <
> [email protected]> wrote:
> >
> > If there are any Unique fields in that table (I'm sure there are!) check
> > that you aren't trying to save a duplicate value in one of them.
> >
> > PB
> >
> > On 10 June 2018 at 21:02, Jody Bevan via 4D_Tech <[email protected]>
> > wrote:
> >
> >> Hi Doug:
> >>
> >> I wrote this code in the method with the problem line:
> >>
> >> If (Table name($vptr_Table)="StandardOrder")
> >>                SAVE RECORD([StandardOrder])
> >> Else
> >>                SAVE RECORD($vptr_Table->)
> >> End if
> >>
> >> The line traces and knows to use the correct branch. Therefore it does
> not
> >> seem to be the pointer. It is like 4D is having problems with the
> structure
> >> - guessing.
> >>
> >> We have not used any triggers in this project thus far. I did check and
> >> nothing checked off for a trigger, and no code in the trigger.
> >>
> >> The same err comes up with the Save Record command with the table
> directly
> >> identified '-1'
> >>
> >> Jody.
> >>> On Jun 10, 2018, at 1:54 PM, Douglas von Roeder <[email protected]>
> >> wrote:
> >>>
> >>> Jody:
> >>>
> >>> Try using the actual table name. What’s in//disable the trigger.
> >>>
> >>> On Sun, Jun 10, 2018 at 12:50 PM Jody Bevan via 4D_Tech <
> >> [email protected] <mailto:[email protected]>> wrote:
> >>> The method that this err occurs in is used hundreds of time throughout
> >> the system. All record saves go through it.
> >>>
> >>> I have a record I used Add Record which opened up our ‘Input’ form.
> >> Within the Form Method On Load I update information in the record, and
> from
> >> the User Interface I update information in the record. I then call our
> >> STD_Save method.
> >>>
> >>> In the Debugger window I can see the Records in selection for the table
> >> = 0. I can also see that there is the record that I am currently
> modifying
> >> that I got there with the Add Record, that I am trying to save.
> >>>
> >>> I pass in a pointer to the table I am working in, to our STD_Save
> >> method. As I follow it through the pointer dereferences correctly. This
> >> permits us to do some house keeping in the record. All is good until the
> >> line indicated in the Subject line is executed.
> >>>
> >>> Just before that line is executed $vptr_Table-> dereferences to the
> >> correct table.
> >>>
> >>> When this line runs the following Err message comes up:
> >>>
> >>> 4D Engine#: -1 Invalid table number requested by a Plug-In.
> >>>
> >>> I have run MSC and no errs are reported. All is good.
> >>>
> >>> I have retyped the line several times. I have copied the method,
> deleted
> >> it, and created it again. No luck.
> >>>
> >>> Obviously this method is running successfully for saving record for
> >> other tables as it will be run many times in just getting to where I am
> in
> >> our application.
> >>>
> >>> Ideas?
> >>>
> >>> Thanks.
>
> **********************************************************************
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:[email protected]
> **********************************************************************

-- 

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:[email protected]
**********************************************************************

Reply via email to