Results 1 to 3 of 3

Thread: displaying time fields in delphi.

  1. #1
    Join Date
    Oct 2012
    Posts
    2
    Mentioned
    0 Post(s)
    Quoted
    0 Post(s)

    Default displaying time fields in delphi.

    i need help with my project it gives me this error:
    parameter is improperly defined. inconsistent or incomplete information was provided. what do i do?

  2. #2
    Join Date
    May 2007
    Location
    England/Liverpool
    Posts
    1,004
    Mentioned
    9 Post(s)
    Quoted
    106 Post(s)

    Default

    Try to post your code in question so we can ready what's going wrong and why.

  3. #3
    Join Date
    Oct 2012
    Posts
    2
    Mentioned
    0 Post(s)
    Quoted
    0 Post(s)

    Default

    procedure TfrmZoo.rdgTimesClick(Sender: TObject);
    begin
    ADOQuery1.Active:=false;
    case rdgTimes.ItemIndex of

    0: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    1: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    2: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    3: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    4: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    5: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    6: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    7: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    8: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    9: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';

    10: ADOQuery1.SQL.Text:= 'SELECT Table1.Animal, Table1.[Fedding Time] FROM Table1 WHERE (((Table1.[Fedding Time])=#12/30/1899 9:0:0#))';
    end;
    ADoQuery1.Active:=true;
    end;

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •