OnlineHours Problem

[mytzu]

Helo guyz, i`m using 11.11.82 files, and i have a problem in MEM_STAT with Online Hours.
Heres My Table:


I have made MinutesOnline by this topic:
http://forum.ragezone.com/f82/mucore...orking-847278/
And it works perfectly. But i need OnlineHours to work because i have an exchange online hours module.

I need a query or something to fix my HoursOnline start counting online Hours of Users.

[MentaL]

[daezugun]

Changed the "int: to "real" and unchecked "Allow Null" for OnlineHours

[mytzu]

Yes, but how to change that ?
Because if i edit in Enterprise and then try to save, it wont let me.

'MEMB_STAT' table
- Unable to modify table.  
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'OnlineHours', table 'MuOnline.dbo.Tmp_MEMB_STAT'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. 

And you have done that? It works for you ?

[varcush]

search for wz_disconnect_memb procedure and change (DATEDIFF(hh,ConnectTM,getdate()) with (DATEDIFF(mi,ConnectTM,getdate())

[mytzu]

But where and how to search and change that ?

[ScriptKid]

MuOnline Tables

[mytzu]

Yes, but how to change that ?
Because if i edit in Enterprise and then try to save, it wont let me.

'MEMB_STAT' table
- Unable to modify table.  
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'OnlineHours', table 'MuOnline.dbo.Tmp_MEMB_STAT'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. 

And you have done that? It works for you ?

I know that is in Tabels.. but i already told you that i dont know how to change those values, after i edite table and i try to save, i get this error :-s
So can someone tell me what i need to edit ?

[mytzu]

I used this comand

ALTER TABLE [MEMB_STAT]
ALTER COLUMN [OnlineHours] [int] NOT NULL

But i recieve this error

Server: Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'OnlineHours', table 'MuOnline.dbo.MEMB_STAT'; column does not allow nulls. UPDATE fails.
The statement has been terminated.

So please someone fix this for me? I really need those OnlineHours To count!

[varcush]

MuOnline Tables

not in mu online tables --- in procedures

search for wz_disconnect_memb procedure and change (DATEDIFF(hh,ConnectTM,getdate()) with (DATEDIFF(mi,ConnectTM,getdate())



There are stored procedure

you need to searchfor wz_disconnect_memb

[mytzu]

Its fixed now. Thank you all!