Re: Do not get data!!!!!
From: John Leavey (johnl_at_[no_spam)
Date: 06/09/04
- Next message: Ricard David: "eOleException running in debug mode"
- Previous message: Matthew Pascoe: "Re: Do not get data!!!!!"
- In reply to: Peet Koekemoer: "Do not get data!!!!!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 9 Jun 2004 07:14:34 -0700
Peet Koekemoer wrote:
> Hi all,
>
> It's me again. Well I have the following problem. I'm trying to
> extract data from the db and load it into a Grid but I get no
> records. But I know there are three records for the date selected. I
> do get the records when I do a normal select in Query Analyzer.
>
> I'm using D5, TADOQuery and MSSQL2000
>
> This is my Procedure to get the data.
>
> With DataModuleForm.ADOQuery do
> begin
> SQL.Clear;
> SQL.Add('Select * from SundayLabour where WorkDate = :WorkDate');
> Paramaters.ParamByName('WorkDate').Value := WorkDate.Date
SQL.Text := 'Select * from SundayLabour ' +
'where DateDiff( D, WorkDate, ' +
QuotedStr( FormatDateTime( 'd mmm yyyy', WorkDate.Date ) ) +
' ) = 0';
John Leavey
- Next message: Ricard David: "eOleException running in debug mode"
- Previous message: Matthew Pascoe: "Re: Do not get data!!!!!"
- In reply to: Peet Koekemoer: "Do not get data!!!!!"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
