Re: [Emerald] newhistory
Dale E. Reed Jr. ( (no email) )
Fri, 06 Aug 1999 13:35:52 -0700
Tommy Cheng wrote:
>
> the newshistory.sql cript under ftp directory /emerald/sql/
>
> Select Date, "Payment", Amount, Description =
> CASE
> WHEN CheckNumber = '0' THEN PayInfo
> ELSE 'Check No: ' + CheckNumber + ' ' + PayInfo
> END, PaymentID
> From Payments
> Where CustomerID = @CustomerID
>
> I can't find this "CheckNumber" column from Payments table.
>
> when I looked inside the latest insttab.sql, there is also no "CheckNumber"
> column under table "payments"
>
> Is this something new I have to add???
Its sorta a hidden feature. If you add the CheckNumber field
to the payments table, you'll get a CheckNumber field on the
payments window as well. This query will do it for you:
ALTER TABLE Payments ADD CheckNumber varchar (16) NULL DEFAULT NULL
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart