Re: [Emerald] SQL Database Transfers

Glen Harvy ( )
Wed, 25 Nov 1998 10:11:53 +1100

At 23:28 23/11/98 -0800, you wrote:
>IF @ast = 2
>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'
>The problem will be with the above. Make sure your CallDetails
>table has the same columns (the original one did). The columns should
>CallDate, Username, AcctSessionTime, FramedAddress, NASIdentifier,

You forgot about ConnectInfo. I added that to the SQL Script and it appears
to have fixed it.

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 <>