PDA

View Full Version : displaying time fields in delphi.



AssasinDon
10-27-2012, 11:33 AM
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?:unsure::unsure::unsure:

Mark
10-27-2012, 11:37 AM
Try to post your code in question so we can ready what's going wrong and why.

AssasinDon
10-27-2012, 11:39 AM
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;