Re: Database search

This is the code

SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate,
ShippedDate, ShipVia
FROM Orders
WHERE ShipVia = 'varshipvia'


The exact same code works ok with different variables within the same
database, just not that table.

What do you think?
--

"It's all in fun or life isn't worth it!"

You're getting the error on a simple SELECT?
You don't have an INSERT or UPDATE there somewhere?
See:
http://www.macromedia.com/support/ultradev/ts/documents/access_datetime_2752.htm

"ionic" <jase.NOCRAPjason (AT) vispa (DOT) com> wrote

This is the code

SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate,
ShippedDate, ShipVia
FROM Orders
WHERE ShipVia = 'varshipvia'


The exact same code works ok with different variables within the same
database, just not that table.

What do you think?
--

"It's all in fun or life isn't worth it!"