Record stuck in Pervasive with no KID (Key ID=0)

KID is zero which should never happen. Will always happen to the LEAD pax.

So if you have a lead pax that shows up in every report for trips they are not even on, more than likely these instructions below will fix the issue.

There are 5 KIDs created:

1. Date

2. Time

3. User

4. Mult

5. Comm

When record is created a unique KID is created.

With FOS open on the server, go to Start – Pervasive – Control Center. Expand the computer name – databases- FOS data – Tables

Go to the Trip Passenger Table

Type in this:

With cursor in the space below, right click and choose Execute in Grid

In the bottom there should be a record for the name that was populating, right click and delete row

Once done, exit out and chose NO on the message