Skip to main content

Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #203099
    bearhead
    Participant

    This is probably a rather unique situation, but hopefully someone has come across a similar situation before.

    I have a mysql table that is populated with records dependent on data from another program (deltek vision). Every so often, the data from this other program is updated, and subsequently the mysql table is automatically updated as well.

    If I were to manually add a record to the mysql table, would that record get wiped out when deltek vision runs its update?

    Unfortunately I can’t test this myself, because I don’t have admin access to deltek vision. The person who does is on vacation for the next week. ><

    #203102
    shaneisme
    Participant

    This reply has been reported for inappropriate content.

    No, if you add a new record it will advance the key count and the next record will be added after. I’m making a pure assumption considering we don’t know your schema or code, but if it’s set up properly that should take place.

    #203156
    __
    Participant

    This reply has been reported for inappropriate content.

    My off-the-cuff reaction would also be “no,” but if their code does something weird… : )

    I have seen people who “update” their DB by truncating it and re-inserting everything.

Viewing 3 posts - 1 through 3 (of 3 total)
  • The forum ‘Back End’ is closed to new topics and replies.