-
Frank,
I can get past the error now, but when selecting 'Next' or any of the sorting column names, the SQL command is dropping valiables I have passed to the sql statement previously. ie:
Existing statement ..
Where PF.ACT_DATE >= " & Span & " And PF.SYM_NAME = '" & Sym1 & "'
But after selecting NEXT or a column sort the SQL reads:
Where PF.ACT_DATE >= And PF.SYM_NAME =
As in the variables Span and Sym1 have been reset to nulls or something.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|