TIA
SQL Statement:
UPDATE Servers AS s,
ServerPorts AS sp
SETUserName='jgray',AcctStatusType=1,FramedAddress='63.68.34.153',Call
Date='2000-03-23 12:37:5'
FROM Servers s,
ServerPorts sp
WHERE sp.ServerID = s.ServerID
AND s.IPAddress='208.247.48.22'
and sp.Port=11267 AND (DateAdd('s', 0-0, '2000-03-23 12:37:5') >=
sp.CallDate OR sp.CallDate IS NULL)
ODBC Error [37000]
-3503:[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in
UPDATE statement.
[UPDATE Servers AS s, ServerPorts AS sp
SETUserName='jgray',AcctStatusType=1,FramedAddress='63.68.34.153',Call
Date='2000-03-23 12:37:5'
FROM Servers s, ServerPorts sp
WHERE sp.ServerID = s.ServerID
AND s.IPAddress='208.247.48.22'
and sp.Port=11267
AND (DateAdd('s', 0-0, '2000-03-23 12:37:5') >= sp.CallDate
OR sp.CallDate IS NULL) ]
Sending Accounting Ack of id 40 to d0f73016 (max-tnt)
James B. Hrdy web: http://www.greensoft.com
email: jhrdy@greensoft.com
Voice: 913.317.8083 x206
"The hardest thing in the world to understand is the income tax."
Albert Einstein
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart