Hi,
I'm coping a bit of code below that I'm getting stuck on. mszDate is a Global SmallInt variable that contains the value of a selection from a MultiList Box, which I obtained using ReadControlValue. The program compiles with no errors but when running it in MapInfo I get and error message of Datatype Mismtach in _expression_ for line 63. I don't understand why the mismatch is a problem in that line, but not in line 61?
60. If mszDate = 1 Then
61. Select * From Emp_Shifts Where Dat_of_Shift LIKE "13/06/2006" Into Emp_Shifts_Dates
62. ElseIf mszDate = 2 Then
63. Select * From Emp_Shifts Where Dat_of_Shift LIKE "14/06/2006" Into Emp_Shifts_Dates
64. Else
65. Select * From Emp_Shifts Where Dat_of_Shift LIKE "13/06/2006" OR Dat_of_Shift LIKE
66. "14/06/2006" Into Emp_Shifts_Dates
67.
68. End If
Can anyone point me in the right direction?
Thanks
Christine
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
