Re: [Emerald] SQL errors when changing an MBR to Purchase Order from Renewal
Josh Hillman ( (no email) )
Wed, 11 Aug 1999 13:34:02 -0400
> Josh Hillman wrote:
> > My PayMethods table contains the following:
> > PayMethod GroupID SortOrder
> > --------------- ----------- ---------
> > Cash (null) (null)
> > Check (null) (null)
> > Purchase Order (null) (null)
> > Credit Card (null) 1
> > Invoice (null) 1
> > Other (null) 1
> >
> > I'm guessing the problem has something to do with the space in front of
> > "Purchase Order" in PayMethods.PayMethod. Should the spaces be
preceding
> > any of the PayMethod names?
>
From: Dale E. Reed Jr. <daler@iea-software.com>
> Not anymore. Emerald 2.2 and lower used that notation. The Upgrade to
> 2.5 should have changed them.
The upgrade didn't do it, but I fixed the names and the errors are gone now.
I did notice though, that Emerald 2.5.278 doesn't show the PO Number in the
field where it supposed to be displayed (same area as credit card info)
eventhough it's in the database.
Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart