VetLink PRO

Connecting Veterinary Professionals with Smarter Solutions

Skip to content
English - Australia
  • There are no suggestions because the search field is empty.

SQL - Multibook set on column incorrectly

v7,v6

If multibook has been set on a column incorrectly; Check the roster is no configured for multibook Open staff record and go to staff tab Click on roster Check if multi book configured for that day If it is and they don't want it then unset it. If roster set correctly then check that there are no appointment in the staff column that have overlapping start/finish times. If there are then the column should be multibooking. If first two steps are not the problem then run query below to see if any appointment have DoubleUp set to 1; select * from "Diary_Main" where "DoubleUp" = 1 and "Date" = '?? ??? ????' and "Stf_Num" = 10000000??? If results from 3 find results, and are top two steps are not the problem; update "Diary_Main" set "DoubleUp" = 0 where "DoubleUp" = 1 and "Date" = '?? ??? ????' and "Stf_Num" = 10000000??? Close and open Vetlink and see if column no longer multi-booked. If above queries don't work you can also try query below update "Diary_Main" set "Multi_Book" = 'N' where "Date" = '?? ??? 20??' //change date here and "Stf_Num" = 10000000??? //change staff number here and "Dry_Num" = 1 and "Site_Ref" = ? // change site ref here and "Multi_Book" = 'Y'