Mark
Have you tried -
ParamByName('SaveDate').AsDate := CurrentDate;
as opposed to
ParamByName('SaveDate').AsString :=
DateToStr(CurrentDate);
What is your Short Date Format - dd/mm/yy or
mm/dd/yy?
DateToStr may not be giving you a valid date for
SQL
Why you would get "could not find object", I don't
know.
HTH
Mike
|
- [DUG]: SQL and Parameters Mark Howard
- 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