Re: [Emerald] SQL Database Transfers
Glen Harvy ( glen@aquarius.com.au )
Wed, 25 Nov 1998 10:11:53 +1100
At 23:28 23/11/98 -0800, you wrote:
>IF @ast = 2
>BEGIN
>Insert INTO CallDetails
>Select DateAdd(Second, 0-i.AcctDelayTime, i.CallDate), i.UserName,
>i.AcctSessionTime, i.FramedAddress, i.NASIdentifier, i.CallerID
>>From inserted i
>WHERE i.UserName is not NULL and i.UserName <> 'NULL'
>END
>
>The problem will be with the above. Make sure your CallDetails
>table has the same columns (the original one did). The columns should
>be:
>
>CallDate, Username, AcctSessionTime, FramedAddress, NASIdentifier,
>CallerID
You forgot about ConnectInfo. I added that to the SQL Script and it appears
to have fixed it.
Glen.
--------------------------------------------------------------------
AQUARIUS Communications for all your Internet<>Fidonet needs
<>Full ISP services<>FrontDoor Commercial<>TransX Internet/FTSC Mailer
voice(02)9977-3788<>fax(02)9977-3844<>bbs(02)9977-2855<>3:714/930
http://www.aquarius.com.au <> mailto:sales@aquarius.com.au