Results 1 to 8 of 8

Thread: Can't seem to get keylookup to work

Hybrid View

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Location
    United Kingdom
    Posts
    657
    Display index for dtaxon is showing as blank for some reason. I imported the tables.

    Danimal index shows when I use display index.

    I'll play around and find out what there is no index on that table.

    Would it be possible for the system to create the index on the fly if it was not there ?

  2. #2
    Senior Member
    Join Date
    Apr 2012
    Location
    United Kingdom
    Posts
    657
    select dtaxon
    display index
    Show nothing

    create index dtaxon on dtaxon (ccommon)

    shows
    Production DBX file: dtaxon.dbx
    Master Index TAG: DTAXON
    Key: CCOMMON
    Type: Character
    Len: 158


    create index dtaxon on dtaxon (Primary)

    shows

    Fri Nov 2 14:38:42 2018
    **** Lianja error ****
    create index dtaxon on dtaxon (primary)
    ^
    Expression was expected

    So it looks as though I'll have to alter the primary key name in all my tables, this was imported from VPM

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us