Help with SYntax
Posted: Thu 12 Jan 2006 14:11
Upgraded from Paradox tables to MYSQL but the following statement does not bring any results back.
How do I resove this please.
Steve W
franchisee :=edit5.Text;
if franchisee = '199' then temp := 'SELECT * FROM Tickets WHERE DATEDIFF(:today,First_Letter_Date) > 30 AND Ticket_Status = "1st DVLA request" ORDER BY Registration_No DESC ';
if franchisee = '199' then temp := 'SELECT * FROM Tickets WHERE Ticket_Status = "Completed" AND Paid_date BETWEEN :startdate1 AND :enddate1 ORDER BY Location_Code';
if franchisee '199' then temp := 'SELECT * FROM Tickets WHERE Belongs_Number = "'+franchisee+'" AND Ticket_Status = "Completed" AND Paid_date BETWEEN :startdate1 AND :enddate1 ORDER BY Location_Code';
Query_Tickets.SQL.Text := temp;
Query_Tickets.ParamByName('startdate1').AsDatetime := DateTimePicker1.Date;
Query_Tickets.ParamByName('enddate1').AsDateTime := DateTimePicker2.Date;
Query_Tickets.Open;
How do I resove this please.
Steve W
franchisee :=edit5.Text;
if franchisee = '199' then temp := 'SELECT * FROM Tickets WHERE DATEDIFF(:today,First_Letter_Date) > 30 AND Ticket_Status = "1st DVLA request" ORDER BY Registration_No DESC ';
if franchisee = '199' then temp := 'SELECT * FROM Tickets WHERE Ticket_Status = "Completed" AND Paid_date BETWEEN :startdate1 AND :enddate1 ORDER BY Location_Code';
if franchisee '199' then temp := 'SELECT * FROM Tickets WHERE Belongs_Number = "'+franchisee+'" AND Ticket_Status = "Completed" AND Paid_date BETWEEN :startdate1 AND :enddate1 ORDER BY Location_Code';
Query_Tickets.SQL.Text := temp;
Query_Tickets.ParamByName('startdate1').AsDatetime := DateTimePicker1.Date;
Query_Tickets.ParamByName('enddate1').AsDateTime := DateTimePicker2.Date;
Query_Tickets.Open;