VFP 8 SP1 on XP Pro SP1
This is the most bizarre thing I've seen in a long time. I had some
code in a form that constructed a SQL SELECT statement as a string,
then runs the command via macro substituion (&). This was working fine.
I decided to move this code into a class. Now, when the macro
substitution line is executed, nothing happens. Here is the string
that is supposed to be executed:
SELECT Employee_name AS fld1, UPPER(Employee_name), Ssn AS fld2, UPPER(Ssn),
Employee_id AS fld3, UPPER(Employee_id), Dob AS fld4, UPPER(Dob) INTO CURSOR
rptCurs FROM empGrpCurs ORDER BY 2, 4, 6, 8
The source cursor (empGrpCurs) exists and contains data. After
this instruction is executed (or not executed in this case), the
destination cursor (rptCurs) does not exist and _TALLY has not been
updated from the prior value. No error is raised. It's like this
instruction never happened. I then placed the actual SQL SELECT
statement (rather than the macro version) in this same method a
few lines lower and the result was exactly the same - no error,
no cursor created, _TALLY unchanged.
I'm convinced I'm just missing something very obvious, but lack
of sleep must be blinding me.
Any ideas?
-- TRW
_______________________________________
t r w 7
at
i x dot n e t c o m dot c o m
_______________________________________