Razzak I just got back from the other factory! (thus the delay in reply!) I was dispatched there for half the day... well. Upon my return I have been able to test your response syntax and it does indeed fix it "just like the movies!" thank you very much Razzak.
Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Tuesday, January 08, 2008 10:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: calculated column from view in DB grid At 09:22 AM 1/8/2008, Jeffrey M. Watson wrote: >I have a view using a calculated column, I am trying to show the view in >a read-only db grib but I do not see the calculated column available to >be chosen for the table. I see every non-calculated column. Can I not >use a DBGrid for this task? Jeff, Here's how: 01. Re-Define the view with alias column names. Example: -- Start here ... CONNECT RRBYW14 SET ERROR MESSAGE 677 OFF DROP VIEW LineItemTotals SET ERROR MESSAGE 607 ON CREATE VIEW `LineItemTotals` + (CustID,Company,NetAmount,Freight,Tax,LineItemTotal) + AS SELECT + CustID,BillToCompany,NetAmount,Freight,Tax,(NetAmount+Freight+Tax) + FROM InvoiceHeader COMMENT ON VIEW `LineItemTotals` IS 'Line Item Totals' RETURN -- End here ... 02. Now create a form with DB Grid Control associated with LineItemTotals. Notice that all columns including the calculated column LineItemTotal is also displayed accordingly. And, that's all there is to it! Have fun. Very Best R:egards, Razzak.
