🚀 go-pugleaf

Using locate in C++ Builder can be AGONIZING especially when the user has
some WACKED OUT regional settings like dd-MMM-yy in which LOCATE MERELY
PUKES ON! ShortDateFormat won't help you here either..... the solution.....
Instead of adding the TDateTime variable to your variant array, Pass it as a
formatted date string, but MAKE SURE you set ShortDateFormat to something
you can trust in your constructor like dd'/'mm'/'yyyy then ALSO set
Application->UpdateFormatSettings = false;

Now you can use the code below and it won't care what regional settings the
user swaps too.... VICTORY!!!!


      Variant locvalues[3];
      locvalues[0] = Variant(iEmpID);
      locvalues[1] = Variant(dtExDate.FormatString(ShortDateFormat));
//Variant(dtExDate);
      locvalues[2] = Variant(iExID);
      bFoundShiftMatch =
cdsEmployeeSchedule->Locate("EmpID;Date;ReliefExceptionID",
VarArrayOf(locvalues, 2), TLocateOptions());