..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: DNS Management for Emerald?
From: "Dale E. Reed Jr." <daler@iea-software.com>
Date: Fri, 05 Jun 1998 01:58:00 -0700
Peter A. Sang wrote:
>
> I'm thinking about some extensions to the Emerald DB scheme, holding DNS
> entries for some customers with webservers.
> Anyone else tried this and wants to share his experience? I don't like
> inventing the wheel twice ;)
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Current balanceFrom: "Bill Bongiorno" <bill@systec.com>Date: Fri, 5 Jun 1998 09:24:35 -0400
The amount owed by a customer shows as a bracketed (negative?) amount. Thisconflicts with page 66 of the user documentation where the amount owed of12.23 shows without brackets. Is this the way it is supposed to be, or do Ihave a problem? Thanks for any help.
Bill BongiornoSysTec Computer Associates, Inc.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald won't run today, Take IIIFrom: Jeff Woods <jwoods@delta.com>Date: Fri, 05 Jun 1998 09:44:28 -0400
At 02:12 PM 6/4/98 -0700, you wrote:
>> After rebooting, I got "Error loading from file" when trying to load>> Emerald. I can't get into Emerald at all now. (I also rebooted the SQL>> server at the same time, just in case).>>The typical cause of this problem is that the SQL Client tools are not>installed.
Wasn't it -- remember, I *could* use SQL Enterprise Manager from thisworkstation, and could perform queries to the Emerald database just fine --it was in Emerald, not in SQL tools.
>I would try re-installing both the SQL Client Utilities>and Emerald. The program you instaled most likely overwrote a file>needed by the client with an older version.
The first re-install of Emerald (before I wrote the original message) didnot fix it. The SECOND one, strangely, did. Thanks.
>> RadiusNT is still running fine, authenticating and accounting. I can run>> SQL Enterprise Manager, and view the databases and make queries from this>> workstation. Emerald is not installed on any other workstations, but I>> imagine that it WOULD work from there.>>Maybe just re-installing Emerald itself then?
I had thought that, but it didn't work the first time, hence my urgentmessages. Turns out that was the solution, but it took a second re-installfor some reason. Perhaps it couldn't replace a .DLL in use during thefirst re-install/reboot.... In any case, it is working now.
>> Dale, can you tell me which library being replaced could cause this error,>> and where I can find the one YOU require, before Friday morning when I have>> to finish this billing cycle?
I first manually went through my backup files, looking at date comparisons,and replacing all the questionable .DLL's with the older copies. Thatdidn't solve it, either. But the re-install AFTER that DID, so I imagineit was a COMBINATION of something that Emerald's install would havereplaced, PLUS something I manually found in my three-hour search. <sigh>
>Emerald doesn't use jet or any of the DB support of VB5. So I don't know>if any of those are the issue. You can look at the Emerlad distribution>to see if any of these files are in that. You might also take this time>to install Emerald 2.2, which may work with those program better, since>it is VB5 based, whereas Emerald 2.1 is VB4 based.
Emerald 2.2 was not available to any but those who specifically neededsomething in it -- and I wasn't one of them, so I never have had access tothe Emerald 2.2 distribution files, as far as I know. The last fullversion I have is 2.1.11.
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Current balanceFrom: "Josh Hillman" <admin-maillist@talstar.com>Date: Fri, 5 Jun 1998 10:13:26 -0400
> From: Bill Bongiorno <bill@systec.com>> The amount owed by a customer shows as a bracketed (negative?) amount.This> conflicts with page 66 of the user documentation where the amount owed of> 12.23 shows without brackets. Is this the way it is supposed to be, or doI> have a problem? Thanks for any help.
Go into your Control Panel on the machine running Emerald and double-clickon Regional Settings. Click on the Currency tab and change it to be -$1.1(or whatever you want).
I don't know if you have to restart Emerald after making that change. It'sjust a display setting--not something that's stored in the database
Josh Hillmanhillman@talstar.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SELECT DISCTINCT ability in Crystal Reports 5?From: "Josh Hillman" <admin-maillist@talstar.com>Date: Fri, 5 Jun 1998 10:51:29 -0400
> From: Dale E. Reed Jr. <daler@iea-software.com>> You need to create a second group to show the distinct, and hide the> details section. I modified your report to output what I believe is> what you are looking for. Its a CR 6.0, but it should work find on> CD 5.0 as well. Its in /emerald/contrib/reports.
Thanks for taking the time to look at that. I downloaded your editedversion and it appears that the output is pretty close to the original(except yours doesn't repeat everything for multiple InvoiceItems, whichwas what I was trying to prevent it from doing). I noticed that thegroup/grand totals are incorrect, but that's probably still totallingtotalling Invoice.Amount (while repeating some of the Invoice.Items): inv. 1234 AmountDue: $60.00 (3 $20.00 InvoiceItems) inv. 1235 AmountDue: $15.00 (1 $15.00 InvoiceItem) Total: $195.00 (instead of $75)
Since I don't have CR5 on any machines in the office, I'll have to fiddlewith the totals when I get home tonight.
Thanks again!
Josh Hillmanhillman@talstar.com
> Josh Hillman wrote:> > > > Does anyone know if there's a way to implement the "DISTINCT" featureof a> > SQL SELECT statement in Crystal Reports 5.0 reports? I created a CR5> > report that displays the following payment information for anyrequested> > date:> > -- > Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald would not issue a Renewal-InvoiceFrom: "Josh Hillman" <admin-maillist@talstar.com>Date: Fri, 5 Jun 1998 11:55:10 -0400
Dale,
Thanks for looking into this. I didn't realize that anInvoice.Type=Invoice interferred with the generation of Renewal invoices. I thought only mismatched Renewal invoices / maExpireDates could causeproblems. Anyway, the problem is fixed and this is what I did to fix it:
There were two invoices (Type=Invoice), one paid, and the other was createda few days ago. The start/end dates WERE 3/5/98 - 6/5/98 and 6/5/98 -9/5/98 (while the current maExpireDate = 6/1/98, which coincides with theregular Renewal invoices). I changed the start/end dates on those twoinvoices so that they were the first of the month instead of the 5th, justto be consistent with the normal billing cycle. Then, I ran the followingfor the most recent Invoice (Type=Invoice) to temporarily void it: UPDATE Invoices SET Type='Void' WHERE InvoiceID = 7543After that, I was able to create the next normal Renewal invoice (6/1 -9/1). After creating it, I changed invoice 7543 back to Type=Invoice sothat both can be paid.
Josh Hillmanhillman@talstar.com
----------> From: Dale E. Reed Jr. <daler@iea-software.com>> To: emerald@iea-software.com> Subject: Re: Emerald would not issue a Renewal-Invoice> Date: Friday, June 05, 1998 1:53 AM> > Josh Hillman wrote:> > > > As far as invoices go, isn't this only relevant if the invoice is oftype> > "Renewal" and not "Invoice"? I just found out today that one of our> > No. The issue with this account is that the start/end dates are not> the same. Emerald will ignore invoices that have the same start/enddate,> but and invoice or renewal that does not have the same start/end date > is considered overlapping.> > MasterAccounts:> maExpireDate = 6/1/98> Active = 1> PayPeriod = Quarterly> PayMethod = Invoice> SubAccounts:> Active = 1> > Date InvoiceID StartDate EndDate Amount > Login Description > --------- --------- ----------- --------- -----------------------------------> ------------ -------------------------------------------------- > Invoice.Type=Invoice> 05/29/98 Item 7543 > -360.00 Negotiated by > 05/29/98 Item 7543 > 30.00 Virtual Domain> Hosting > 05/29/98 Item 7543 > 250.00 Website> Development > 05/29/98 Item 7543 > 300.00 Banner> Ad > 05/29/98 Total Due 7543 06/05/98 09/05/98 > 750.00 > > This is the one that is causing the problem, since the enddate is higher> than the expire date.> > -- > Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Some SQL help please?From: "Greg Keys" <greg@loclnet.com>Date: Fri, 5 Jun 1998 12:08:41 -0400
Well, I am beating my brains out on the floor now :)Can anyone tell me/show me, or even give me a hint as to an SQL script thatwill show me a list of MasterAccounts that have NO invoices in the Invoicetable?
Gregory E. KeysSystem AdministratorLoclNet (A Division of ESC Inc.)Electro-data Systems Company Inc.Voice: (704)861-1251Fax: (704)861-1870E-Mail: greg@loclnet.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Some SQL help please?From: Laslo Orto <laslo@cpol.com>Date: Fri, 05 Jun 1998 12:39:51 -0400
select * from masteraccounts where customerid not in (select customeridfrom invoices)
At 12:08 PM 6/5/98 -0400, you wrote:>Well, I am beating my brains out on the floor now :)>Can anyone tell me/show me, or even give me a hint as to an SQL script that>will show me a list of MasterAccounts that have NO invoices in the Invoice>table?>>>Gregory E. Keys>System Administrator>LoclNet (A Division of ESC Inc.)>Electro-data Systems Company Inc.>Voice: (704)861-1251>Fax: (704)861-1870>E-Mail: greg@loclnet.com>
Laslo Orto Computer Pages / Better.NetSystems Administrator 253 Sheppard Ave. Westlaslo@cpol.com / laslo@Better.net Toronto, Canada M2N 1N2www.cpol.com / www.better.net Ph: +1 416 225 3030 Fax: +1 416 225 6737
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Current balanceFrom: "Bill Bongiorno" <bill@systec.com>Date: Fri, 5 Jun 1998 12:57:12 -0400
The currency symbol in regional settings is $ as it should be. All of thechoices for negative number format have either brackets of a minus sign.What I can't understand is why it is being treated as a negative, instead ofa positive, number.
Bill BongiornoSysTec Computer Associates, Inc.
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> Sent: Friday, June 05, 1998 10:13 AM> To: emerald@iea-software.com> Subject: Re: Current balance>>> > From: Bill Bongiorno <bill@systec.com>> > The amount owed by a customer shows as a bracketed (negative?) amount.> This> > conflicts with page 66 of the user documentation where the> amount owed of> > 12.23 shows without brackets. Is this the way it is supposed to> be, or do> I> > have a problem? Thanks for any help.>> Go into your Control Panel on the machine running Emerald and double-click> on> Regional Settings. Click on the Currency tab and change it to be -$1.1> (or whatever you want).>> I don't know if you have to restart Emerald after making that> change. It's> just a display setting--not something that's stored in the database>> Josh Hillman> hillman@talstar.com>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Current balanceFrom: "Josh Hillman" <admin-maillist@talstar.com>Date: Fri, 5 Jun 1998 13:45:29 -0400
> From: Bill Bongiorno <bill@systec.com>> The currency symbol in regional settings is $ as it should be. All of the> choices for negative number format have either brackets of a minus sign.> What I can't understand is why it is being treated as a negative, insteadof> a positive, number.
It will show a negative if you received more money than was invoiced to acustomer or if you have an "outstanding" invoice for a customer that has atotal amount due of something less than zero (indicating a credit).
I don't use the Balance field in Emerald because it's not tracked properly(at least with Emerald 2.1.11 and below). Quite a few of my masteraccountshave oddball balances listed for no apparent reason. I think when invoicesare voided, for example, the balance is not readjusted. There are probablyother things that cause the discrepencies too...
Josh Hillmanhillman@talstar.com
> > -----Original Message-----> > From: emerald-request@iea-software.com> > [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> > Sent: Friday, June 05, 1998 10:13 AM> > To: emerald@iea-software.com> > Subject: Re: Current balance> >> >> > > From: Bill Bongiorno <bill@systec.com>> > > The amount owed by a customer shows as a bracketed (negative?)amount.> > This> > > conflicts with page 66 of the user documentation where the> > amount owed of> > > 12.23 shows without brackets. Is this the way it is supposed to> > be, or do> > I> > > have a problem? Thanks for any help.> >> > Go into your Control Panel on the machine running Emerald anddouble-click> > on> > Regional Settings. Click on the Currency tab and change it to be -$1.1> > (or whatever you want).> >> > I don't know if you have to restart Emerald after making that> > change. It's> > just a display setting--not something that's stored in the database> >> > Josh Hillman> > hillman@talstar.com> >
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Some SQL help please?From: "Greg Keys" <greg@loclnet.com>Date: Fri, 5 Jun 1998 13:58:07 -0400
:) Very straight forward, and just obvious enough after the fact to provehow tunnel visioned I can get sometimes! Thanks
Greg
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Laslo Orto> Sent: Friday, June 05, 1998 12:40 PM> To: emerald@iea-software.com> Subject: Re: Some SQL help please?>>> select * from masteraccounts where customerid not in (select customerid> from invoices)>>> At 12:08 PM 6/5/98 -0400, you wrote:> >Well, I am beating my brains out on the floor now :)> >Can anyone tell me/show me, or even give me a hint as to an SQL> script that> >will show me a list of MasterAccounts that have NO invoices in> the Invoice> >table?> >> >> >Gregory E. Keys> >System Administrator> >LoclNet (A Division of ESC Inc.)> >Electro-data Systems Company Inc.> >Voice: (704)861-1251> >Fax: (704)861-1870> >E-Mail: greg@loclnet.com> >>>> Laslo Orto Computer Pages / Better.Net> Systems Administrator 253 Sheppard Ave. West> laslo@cpol.com / laslo@Better.net Toronto, Canada M2N 1N2> www.cpol.com / www.better.net Ph: +1 416 225 3030> Fax: +1 416 225 6737>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Current balanceFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 5 Jun 1998 11:09:55 -0700 ()
On Fri, 5 Jun 1998, Bill Bongiorno wrote:
> The currency symbol in regional settings is $ as it should be. All of the> choices for negative number format have either brackets of a minus sign.> What I can't understand is why it is being treated as a negative, instead of> a positive, number.
You can ignore the balance field in Emerlad 2.2 and lower. Itsnot used. This has been completely re-done in Emerald 2.5.
Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Current balanceFrom: "Bill Bongiorno" <bill@systec.com>Date: Fri, 5 Jun 1998 14:15:16 -0400
It shows a negative as soon as the initial invoice is issued to a customer.Before any payments were received. Unless Dale can shed some light on this Iguess I'll live with positives showing negative and negatives showingpositive. Thanks for your help.
Bill BongiornoSysTec Computer Associates, Inc.
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> Sent: Friday, June 05, 1998 1:45 PM> To: emerald@iea-software.com> Subject: Re: Current balance>>> > From: Bill Bongiorno <bill@systec.com>> > The currency symbol in regional settings is $ as it should be.> All of the> > choices for negative number format have either brackets of a minus sign.> > What I can't understand is why it is being treated as a> negative, instead> of> > a positive, number.>> It will show a negative if you received more money than was invoiced to a> customer or if you have an "outstanding" invoice for a customer that has a> total amount due of something less than zero (indicating a credit).>> I don't use the Balance field in Emerald because it's not tracked properly> (at least with Emerald 2.1.11 and below). Quite a few of my> masteraccounts> have oddball balances listed for no apparent reason. I think> when invoices> are voided, for example, the balance is not readjusted. There> are probably> other things that cause the discrepencies too...>> Josh Hillman> hillman@talstar.com>> > > -----Original Message-----> > > From: emerald-request@iea-software.com> > > [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> > > Sent: Friday, June 05, 1998 10:13 AM> > > To: emerald@iea-software.com> > > Subject: Re: Current balance> > >> > >> > > > From: Bill Bongiorno <bill@systec.com>> > > > The amount owed by a customer shows as a bracketed (negative?)> amount.> > > This> > > > conflicts with page 66 of the user documentation where the> > > amount owed of> > > > 12.23 shows without brackets. Is this the way it is supposed to> > > be, or do> > > I> > > > have a problem? Thanks for any help.> > >> > > Go into your Control Panel on the machine running Emerald and> double-click> > > on> > > Regional Settings. Click on the Currency tab and change it to be> -$1.1> > > (or whatever you want).> > >> > > I don't know if you have to restart Emerald after making that> > > change. It's> > > just a display setting--not something that's stored in the database> > >> > > Josh Hillman> > > hillman@talstar.com> > >>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: More SQL QuestionsFrom: "Greg Keys" <greg@loclnet.com>Date: Fri, 5 Jun 1998 14:11:29 -0400
Well, as long as I am asking simpleminded questions and people are takingpity on my feeble state....... here is another one....I just added the CallDetails table and appropriate trigger as per info fromDale.As I watch Radius I see an occasional failure to update the calls onlinedata via the trigger. It seems, after a little study, that the CallDetailtable has 18 characters for the username whilst the rest of the tablessupport 32. I have one user who has 19 characters in there username.Is there any way to modify the size of a item in a table without droppingthe table and recreating it?I know I can write a table that creates another table, copies the data,drops the original table, create the table again and copy the data back, butI am hoping for more simple solution.....
Gregory E. KeysSystem AdministratorLoclNet (A Division of ESC Inc.)Electro-data Systems Company Inc.Voice: (704)861-1251Fax: (704)861-1870E-Mail: greg@loclnet.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Current balanceFrom: "Greg Keys" <greg@loclnet.com>Date: Fri, 5 Jun 1998 14:14:42 -0400
In accounting, a negative balance indicates an amount owed by the customer,and a positive balance indicates an amount owed to the customer (as in anoverpayment or a credit) Break out the Accounting 101 book and join me in amassive headache caused by massive confusion :)
Greg Keys
> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Bill Bongiorno> Sent: Friday, June 05, 1998 2:15 PM> To: emerald@iea-software.com> Subject: RE: Current balance>>> It shows a negative as soon as the initial invoice is issued to a> customer.> Before any payments were received. Unless Dale can shed some> light on this I> guess I'll live with positives showing negative and negatives showing> positive. Thanks for your help.>>> Bill Bongiorno> SysTec Computer Associates, Inc.>> > -----Original Message-----> > From: emerald-request@iea-software.com> > [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> > Sent: Friday, June 05, 1998 1:45 PM> > To: emerald@iea-software.com> > Subject: Re: Current balance> >> >> > > From: Bill Bongiorno <bill@systec.com>> > > The currency symbol in regional settings is $ as it should be.> > All of the> > > choices for negative number format have either brackets of a> minus sign.> > > What I can't understand is why it is being treated as a> > negative, instead> > of> > > a positive, number.> >> > It will show a negative if you received more money than was> invoiced to a> > customer or if you have an "outstanding" invoice for a customer> that has a> > total amount due of something less than zero (indicating a credit).> >> > I don't use the Balance field in Emerald because it's not> tracked properly> > (at least with Emerald 2.1.11 and below). Quite a few of my> > masteraccounts> > have oddball balances listed for no apparent reason. I think> > when invoices> > are voided, for example, the balance is not readjusted. There> > are probably> > other things that cause the discrepencies too...> >> > Josh Hillman> > hillman@talstar.com> >> > > > -----Original Message-----> > > > From: emerald-request@iea-software.com> > > > [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> > > > Sent: Friday, June 05, 1998 10:13 AM> > > > To: emerald@iea-software.com> > > > Subject: Re: Current balance> > > >> > > >> > > > > From: Bill Bongiorno <bill@systec.com>> > > > > The amount owed by a customer shows as a bracketed (negative?)> > amount.> > > > This> > > > > conflicts with page 66 of the user documentation where the> > > > amount owed of> > > > > 12.23 shows without brackets. Is this the way it is supposed to> > > > be, or do> > > > I> > > > > have a problem? Thanks for any help.> > > >> > > > Go into your Control Panel on the machine running Emerald and> > double-click> > > > on> > > > Regional Settings. Click on the Currency tab and change it to be> > -$1.1> > > > (or whatever you want).> > > >> > > > I don't know if you have to restart Emerald after making that> > > > change. It's> > > > just a display setting--not something that's stored in the database> > > >> > > > Josh Hillman> > > > hillman@talstar.com> > > >> >>
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: More SQL QuestionsFrom: Laslo Orto <laslo@cpol.com>Date: Fri, 05 Jun 1998 14:38:42 -0400
Unfortunately you are SOL.
At 02:11 PM 6/5/98 -0400, you wrote:>Well, as long as I am asking simpleminded questions and people are taking>pity on my feeble state....... here is another one....>I just added the CallDetails table and appropriate trigger as per info from>Dale.>As I watch Radius I see an occasional failure to update the calls online>data via the trigger. It seems, after a little study, that the CallDetail>table has 18 characters for the username whilst the rest of the tables>support 32. I have one user who has 19 characters in there username.>Is there any way to modify the size of a item in a table without dropping>the table and recreating it?>I know I can write a table that creates another table, copies the data,>drops the original table, create the table again and copy the data back, but>I am hoping for more simple solution.....>>Gregory E. Keys>System Administrator>LoclNet (A Division of ESC Inc.)>Electro-data Systems Company Inc.>Voice: (704)861-1251>Fax: (704)861-1870>E-Mail: greg@loclnet.com>
Laslo Orto Computer Pages / Better.NetSystems Administrator 253 Sheppard Ave. Westlaslo@cpol.com / laslo@Better.net Toronto, Canada M2N 1N2www.cpol.com / www.better.net Ph: +1 416 225 3030 Fax: +1 416 225 6737
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald won't run today, Take IIIFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 5 Jun 1998 11:35:54 -0700 ()
On Fri, 5 Jun 1998, Jeff Woods wrote:
> I had thought that, but it didn't work the first time, hence my urgent> messages. Turns out that was the solution, but it took a second re-install> for some reason. Perhaps it couldn't replace a .DLL in use during the> first re-install/reboot.... In any case, it is working now.
I've seen situations (especially with the tabctl32.ocx nightmare)where tyhe system had the tab cached, and even after replacingand re-registering the new one, the problem still persisted.A reboot cleared it and everything worked. > Emerald 2.2 was not available to any but those who specifically needed> something in it -- and I wasn't one of them, so I never have had access to> the Emerald 2.2 distribution files, as far as I know. The last full> version I have is 2.1.11.
Emerald 2.2 has been on the ftp site for well over a year, publiclyaccessible.
Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Current balanceFrom: "Dale E. Reed Jr." <daler@iea-software.com>Date: Fri, 5 Jun 1998 12:00:10 -0700 ()
On Fri, 5 Jun 1998, Greg Keys wrote:
> In accounting, a negative balance indicates an amount owed by the customer,> and a positive balance indicates an amount owed to the customer (as in an> overpayment or a credit) Break out the Accounting 101 book and join me in a> massive headache caused by massive confusion :)
Thats how we were going to do Emerald 2.5, but decided on theopposite. A negative is a credit and a positive is a balanceowed. > Greg Keys> > > -----Original Message-----> > From: emerald-request@iea-software.com> > [mailto:emerald-request@iea-software.com]On Behalf Of Bill Bongiorno> > Sent: Friday, June 05, 1998 2:15 PM> > To: emerald@iea-software.com> > Subject: RE: Current balance> >> >> > It shows a negative as soon as the initial invoice is issued to a> > customer.> > Before any payments were received. Unless Dale can shed some> > light on this I> > guess I'll live with positives showing negative and negatives showing> > positive. Thanks for your help.> >> >> > Bill Bongiorno> > SysTec Computer Associates, Inc.> >> > > -----Original Message-----> > > From: emerald-request@iea-software.com> > > [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> > > Sent: Friday, June 05, 1998 1:45 PM> > > To: emerald@iea-software.com> > > Subject: Re: Current balance> > >> > >> > > > From: Bill Bongiorno <bill@systec.com>> > > > The currency symbol in regional settings is $ as it should be.> > > All of the> > > > choices for negative number format have either brackets of a> > minus sign.> > > > What I can't understand is why it is being treated as a> > > negative, instead> > > of> > > > a positive, number.> > >> > > It will show a negative if you received more money than was> > invoiced to a> > > customer or if you have an "outstanding" invoice for a customer> > that has a> > > total amount due of something less than zero (indicating a credit).> > >> > > I don't use the Balance field in Emerald because it's not> > tracked properly> > > (at least with Emerald 2.1.11 and below). Quite a few of my> > > masteraccounts> > > have oddball balances listed for no apparent reason. I think> > > when invoices> > > are voided, for example, the balance is not readjusted. There> > > are probably> > > other things that cause the discrepencies too...> > >> > > Josh Hillman> > > hillman@talstar.com> > >> > > > > -----Original Message-----> > > > > From: emerald-request@iea-software.com> > > > > [mailto:emerald-request@iea-software.com]On Behalf Of Josh Hillman> > > > > Sent: Friday, June 05, 1998 10:13 AM> > > > > To: emerald@iea-software.com> > > > > Subject: Re: Current balance> > > > >> > > > >> > > > > > From: Bill Bongiorno <bill@systec.com>> > > > > > The amount owed by a customer shows as a bracketed (negative?)> > > amount.> > > > > This> > > > > > conflicts with page 66 of the user documentation where the> > > > > amount owed of> > > > > > 12.23 shows without brackets. Is this the way it is supposed to> > > > > be, or do> > > > > I> > > > > > have a problem? Thanks for any help.> > > > >> > > > > Go into your Control Panel on the machine running Emerald and> > > double-click> > > > > on> > > > > Regional Settings. Click on the Currency tab and change it to be> > > -$1.1> > > > > (or whatever you want).> > > > >> > > > > I don't know if you have to restart Emerald after making that> > > > > change. It's> > > > > just a display setting--not something that's stored in the database> > > > >> > > > > Josh Hillman> > > > > hillman@talstar.com> > > > >> > >> >> >
Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com
..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: unsubscribe emeraldFrom: "Habib Zaatar" <habibz@visitus.net>Date: Fri, 5 Jun 1998 17:55:20 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_0026_01BD90AB.1B4D4CA0Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
unsubscribe emerald
------=_NextPart_000_0026_01BD90AB.1B4D4CA0Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
unsubscribe =emerald
------=_NextPart_000_0026_01BD90AB.1B4D4CA0--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: IMail from IPSwitchFrom: Duane Schaub Date: Fri, 05 Jun 1998 17:54:48 -0500Dale,Do you know if NTMail plans to support this new method... especially sinceyou may have some input to the developement. Respond in private if youwould like.Duane.At 01:35 PM 6/4/98 -0700, you wrote:>Chris A. Christopher wrote:>> >> When will Emerald interface with IMail?>>Rather than chase down every possible vendor that could work with>Emerald and do all the grunt work, we are going to be using a new>approash with Emerald 2.5. Emerald 2.5 will include a fully>extensive DLL that currently has the proprietary extensions for==========================================================================Duane Schaub, President |Terra World, Inc - Connecting The PlanetTerra World, Inc. |Southeast Kansas' Leading Provider200 Arco Place, Suite 252 |Flat Fee - Never an hourly ChargeIndependence, Kansas 67301 |Where Service is Top Priority!Voice (316) 332-1616 |http://www.terraworld.netFAX: (316) 332-1451 |dschaub@terraworld.net===========================================================================