[RBG7-L] - Re: Questions about Note columns in DBGrids and theDataBrowser

[David M. Blocker]

Temp tables are real gift!   David   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Alastair Burr To: RBG7-L Mailing List Sent: Wednesday, June 01, 2005 1:04 PM Subject: [RBG7-L] - Re: Questions about Note columns in DBGrids and the DataBrowser Hi David,   Yes, I tried the CTXT on the view definition - actually, while searching to confirm Bill Downall's Union Select solution to ensure that I had remembered it correctly, I found a reply of mine to "Bill, Dennis & James" in which I acknowledged James' suggestion to try the same thing for a problem back in December 2000. I confirmed then that it worked for an integer but it doesn't work now for a note value - and I don't think that I'm too surprised as note to text is really only a question of size.   I have also wondered whether the width of a note column is the deciding factor on whether the data is displayed but I've not been able to demonstrate any pattern. Strangely, for my current question the Data Browser shows the info but the DBGrid shows (memo).   I guess that I'll go for the temp table solution - it's easy enough and might even have some advantages - temp tables often seem to surprise me with how useful they are.   Regards, Alastair.     ----- Original Message ----- From: David M. Blocker To: RBG7-L Mailing List Sent: Wednesday, June 01, 2005 12:39 PM Subject: [RBG7-L] - Re: Questions about Note columns in DBGrids and the DataBrowser Alastair   Just a thought but have you tried in your view definition applying a CTXT functoin to the note column in the SELECT?   I too will be interested in learning what algorithm R:Base uses to determine when you get the MEMO and when you get the data.   Have you tried maximizing the width of that column iin the GRID?   David   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Alastair Burr To: RBG7-L Mailing List Sent: Wednesday, June 01, 2005 3:10 AM Subject: [RBG7-L] - Questions about Note columns in DBGrids and the Data Browser Following on from my question yesterday about using an Outer Join in a view I now have that working - thanks again. My intention had been to use the view to drive a DBGrid on a form but the view includes a Note column which appears as "(memo)" rather than as the contents.   I've been meaning to ask for clarification for a while on how R:Base determines when to display the full data or only to indicate that the additional viewer is needed.   As I see it, the Data Browser seems able to display the underlying data for Note columns in some cases but in others it shows the "(memo)" indicator but I haven't been able to work out when I'll get which.   My questions are these:   Can anybody explain how the Data Browser decides which to show? Is there a way to force a DBGrid to display the data?   In answer to that second question I have tried to force my view to produce a text column by selecting a single row of data from another table with the correct data types but I kept getting an error when I added in the Union Select to get my required data: Column Type Mismatch In Union (2372).   Assuming that I have got all the other columns typed correctly (and, obviously, I think that I have) is there a way around this if the DBGrid cannot be set to display the data?   The solution that I can see is to use a temporary table for my form and populate it with the data as required but I'd rather avoid the extra steps if it's possible.   Thanks in advance for any insights, Regards, Alastair.   ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ----------------------------------