Re: [Emerald] Mass Updating Payments

Dale E. Reed Jr. ( (no email) )
Tue, 01 Jun 1999 09:55:09 -0700

Darin Spence wrote:
>
> When I go to ISQL/w and paste in:
>
> Update Payments
> Set Date = '6/2/99'
> Where Date = '5/28/99'
>
> the click the Green "play" button (execute script) it comes back and says:
>
> (0 row(s) affected)
>
> What am I doing wrong?

Josh made a followup (correction) to this on the list over the weekend.
Payments have a time associated to them, so my example above will not
work correctly. You need to use something like this:

> Update Payments
> Set Date = '6/2/99'
> Where Date Between '5/28/99' and '6/2/99'

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com