|
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] ---------------------------------- |
