Hi, John (and anyone else), I guess what I am wondering is what syntax is used to reference the value of a column cell in a DBGrid through an OnExit DBGrid Column EEP; and if it's possible to update/replace/change a value of a column via the OnExit DBGrid Column EEP. Do you have any sample EEP code where you assign the contents of a DBGrid column cell to a variable; and where you assign the value of a variable to a DBGrid column? That's really what I am trying to figure out - the example I used was just an example. I am new to this version of R:BASE and am not finding the documentation to be particularly helpful in this regard. Looking at your e-mail address - are you based in NZ? If so, I was fortunate enough to spend a month there in the 1980's visiting many national parks, hiking the Routeburn Track and taking lots of pictures. It is one of the most beautiful countries I've ever been to and the people were incredibly friendly. Diane DeMers DeKalb, IL In a message dated 10/3/2008 11:54:44 P.M. Central Daylight Time, [EMAIL PROTECTED] writes:
Diane, As you say you just need to do all of this in the OnExit DBGrid Column EEP. Using you example, (which you are not using ?), and relating that to a form I have, I have a computed column for the total cost; the user enters the quantity and then the unit price can be entered manually, or extracted from another table, via various methods. I use the RBTI_FORM_COLNAME to check the column just exited and then do whatever is required based on that. It all is pretty straightforward – if you would like me to send you more details let me know. (I find the DBGrid an extremely useful object – it has had numerous features added to it which have made it even better in recent years.) Regards, John Docherty From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 3 October 2008 8:55 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Changing Value of DBGrid Column Using Property Hi, all, I have a main table (say, Customers) and a linked subtable (say, Orders) on a form. The subtable is displayed in a DBGrid. When the user enters a value in the column Quantity of the DBGrid, I want to be able to calculate the TotalPrice column in the DBGrid through code in an OnExit DB Grid Column EEP. For example, when I exit the Quantity column, if the Quantity is less than 100, then the price per item is $5.00; if the Quantity is >= 100 and < 500, the price per item is $4.50; if the Quantity >= 500, then the price per item is $4.00. I then compute the TotalPrice and want to pop that value in the column TotalPrice. (This is not what I am really doing; I have a different application where based on the contents of one column, I do a lookup into a table using that column and want to copy the resulting value into another column of the DB Grid.) Any ideas? I am a newbie to R:BASE Turbo V-8; the last version I worked with was 6.5++. Thank you in advance. Thanks, Diane DeMers ____________________________________ Looking for simple solutions to your real-life financial challenges? _Check out WalletPop for the latest news and information, tips and calculators_ (http://pr.atwola.com/promoclk/100000075x1209382257x1200540686/aol?redir=http://ww w.walletpop.com/?NCID=emlcntuswall00000001) . **************New MapQuest Local shows what's happening at your destination. Dining, Movies, Events, News & more. Try it out! (http://local.mapquest.com/?ncid=emlcntnew00000001)
