mail-question wrote:
QUOTE:
delete from powercounter_arch_enterpoint_month
where
id_enterpoint = &OLD_id_enterpoint and
putdate = &OLD_putdate and
page = &OLD_page and
total = &OLD_total
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and putdate = and page = and total =' at line 3
MySQL Server 5.0.45-community-nt
MySQL Client 4.1.3 Direct
Charset
License Mentat Technologies
Hardware 34-47-51-37-07-88-28-BE
OS Version WinNT, full 32-bit 5 Build : 2600 Service Pack 3
Mail question : ruslan
The delete statement is valid , but maybe you entered a not valid charter in the parameter manager.
Choose the right data type in the parameter manager and try to execute again the SQL.
Regards,
Peter
