Re: [Emerald] Time Banking not Working

Dale E. Reed Jr. ( (no email) )
Thu, 02 Sep 1999 17:03:33 -0700

CPD JR wrote:
>
> I really can't find a solution for this time banking problem, it just
> won't subtract
> the time from timeleft field in subaccounts table.
> I appreciate all help.

Have you tried installing the latest MDAC and SQL SP on the client
and server (if they are different machines)? I recall this was a
problem in the SQL ODBC Driver.

> I'm using:
> Radius NT 2.5.162
> Emerald 2.1.11)
> Windows NT 4 SP5
> SQL 6.5
> 3Com HiperARC...
>
> SQL Statement: UPDATE SubAccounts Set TimeLeft=TimeLeft-17 Where
> TimeLeft<>Null And TimeLeft<>-9999
> And Login='mr614'

-- 

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

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart