Mike
Have tried this change, now. No better. I assume
the question about Short Date Format is only relevant while I am using the
DateToStr format?
I think there must be something quitye fundamental, that I
have not passed on to you guys.
I assume that I can use a vanilla TQuery with no properties
set; and that setting the ParamByName is ALL I need to. (I have also tried
Params[0].AsDate := CurrentDate.)
Is there some other fundamental aspect that I may not be aware
of?
Mark
|
- Re: [DUG]: SQL and Parameters Mark Howard
- [DUG]: enhanced tchecklist? Matthew Comb
- Re: [DUG]: SQL and Parameters Craig Goodall
- Re: [DUG]: SQL and Parameters Mark Howard
- Re: [DUG]: SQL and Parameters Craig Goodall
- RE: [DUG]: SQL and Parameters Dennis Chuah
- Re: [DUG]: SQL and Parameters Mark Howard
- RE: [DUG]: SQL and Parameters Dennis Chuah
- Re: [DUG]: SQL and Parameters Mark Howard
- Re: [DUG]: SQL and Parameters Mike Osborne
- RE: [DUG]: SQL and Parameters Mark Howard
- RE: [DUG]: SQL and Parameters James Low
- Re: [DUG]: SQL and Parameters Neven MacEwan
- Re: [DUG]: SQL and Parameters Mark Howard
- Re: [DUG]: SQL and Parameters Mark Howard
- Re: [DUG]: SQL and Parameters Neven MacEwan
- Re: [DUG]: SQL and Parameters Neven MacEwan
- Re: [DUG]: SQL and Parameters Bevan Edwards
- RE: [DUG]: SQL and Parameters Dennis Chuah
- RE: [DUG]: SQL and Parameters James Low