EDBEngineErro "Number is out of range" what is this?

EDBEngineErro "Number is out of range" what is this?

Post by Sande' R. Jones Jr » Sat, 21 Dec 1996 04:00:00

I am trying to create a table using TTable.CreateTable but when I run this
I get the following error EDBEngineErro "Number is out of range".   This
only happens when building the secondary indexs.  Any help would be great

Sample of my code:

     ShowInfo('Creating ACTION.DB');
     With FieldDefs do
          Add('AK', ftInteger,0,True);
          Add('USERID', ftInteger,0,True);
          Add('AP', ftInteger,0,False);
          Add('ASA', ftInteger,0,False);
          Add('AU', ftInteger,0,False);
          Add('ADU', ftDate,0,False);
          Add('ADT', ftDate,0,False);
       end; { End with Field Defs }

    { Create index AAT }
     With IndexDefs do
          Add('AK', 'AK', [ixPrimary, ixUnique]);
          Add('AAT', 'AAT', [ixPrimary]);
          Add('ADT', 'ADT', [ixPrimary]);
          Add('AP', 'AP', [ixPrimary]);
          Add('ASA', 'ASA', [ixPrimary]);
          Add('AU', 'AU', [ixPrimary]);
          Add('Action Send to', 'STATUS;USERID', [ixPrimary]);
          Add('USERID', 'USERID', [ixPrimary]);
          Add('Names', 'SENDERNAME', [ixPrimary]);
          Add('SenderIndex', 'SENDER', [ixPrimary]);
       end; { End with Index Defs }



1. request help "Number out of Range"

  This really looks like the table does NOT have a long integer field type.
  Long integers are specified with "I", logicals with "L", and short ints
  with "S"

  In OPAL, when I try to put 38200 into a smallint, I get a long
  message telling me the data is nuerically too large ... not the
  one you mention.


  Coupled Climate Dynamics Group/971
  NASA Goddard Space Flight Center
  Greenbelt, MD

  Envision Whirled Peas

2. Rumor: SCO UNIX slowly trashes disks at 166+ Mhz

3. max of ("...","...","..")

4. Oracle 8 on NT

5. "Unknown error message number "16118"

6. Strings as Parameters containing &

7. "Unknown error message number "16118".

8. sp_addlinkedserver

9. I am getting this message when i am tring to export or import anything using

10. Use of @am, Am I dumb?

11. Busy Day = Slowdown from 12 AM - 5 AM

12. error ORA-01855: AM/A.M. or PM/P.M. required

13. meaning of "unexpected error: link range"