C1Schedule : indexmapping sequence

C1Schedule : indexmapping sequence

Posted by: fsegui on 27 September 2021, 8:34 am EST

• 

  fsegui

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 September 2021, 8:34 am EST

  Hi,
  
  I’m using C1Schedule linked to a database.
  
  Appointments are mapped with IndexMapping (integer).

  I’m having an issue with index sequence.
  
  For example, the last index in database is 856. The event with 856 is then deleted by a user but not directly in the schedule.

  Then the user adds an appointment using the C1Schedule, the appointment is well added in the database with index 857. But if I try to open it, the key returned by C1Schedule is 856.
  
  Is there a way to refresh the sequence in C1Schedule ?

  Thanks

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 28 September 2021, 4:56 am EST

  Hi,

  Could you please share a sample with a dummy database(.mdb file )? It will really help us investigate the situation at our end and help you better.
  
  Are you deleting the event in the database or the DataTable? If you are changing anything in the data table then the changes should reflect in the C1Schedule and it should work accordingly.

  Regards
  
  Avnish

• 

  fsegui

  • Post Options:
  • Link
    Copy

  Posted 29 September 2021, 5:33 am EST

  Hi,
  
  Actually, when I tried to set up a dummy sample, I’ve seen that update/delete commands for my table adapter where still referencing an old database name.

  Now it works fine.

• 

  avnish.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 30 September 2021, 4:42 am EST

  Good to hear that your issue has been resolved.

  Regards.
  
  Avnish