|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread|
|Messages 1 to 8 of 8 total|
|Tue, Aug 8 2006 6:16 AM||Permanent Link|
Small enhancement suggestion which would no doubt be hell to code (!)
Ability to SELECT MasterTable + Concatenate a Field from Child Table into a memo or blob of the result.
SELECT C.CustomerName, CONCATENATE(O.OrderNumber)
FROM Customer C
LEFT JOIN Orders O ON ...
|Tue, Aug 8 2006 6:33 AM||Permanent Link|
Anything wrong with just doing it like this...
select _Forename, _Surname, _mainphone, _Notes+#13+_MainPhone, cast(_Mainphone as memo)
left join career on _ID = career._fkcontacts
where _id = 7
_Notes is an existing memo field in contacts, _MainPhone is a varchar(25) in career
|Tue, Aug 8 2006 9:33 AM||Permanent Link|
Tim Young [Elevate Software]
Elevate Software, Inc.
<< Small enhancement suggestion which would no doubt be hell to code (!)
Ability to SELECT MasterTable + Concatenate a Field from Child Table into a
memo or blob of the result. >>
As an aggregate operation, correct ? IOW, keep appending to the same result
row BLOB value for all of the child table values ?
|Tue, Aug 8 2006 10:03 AM||Permanent Link|
Ahhh. I totally misunderstood what was wanted.
|Fri, Aug 25 2006 9:14 AM||Permanent Link|
Deqr Roy & Tim,
Sorry to be slack in writing my request ...
What I wanted was the ability to create a "list of children"
OrdersField would be a blob or memo listing all Orders ID fields:
The reason this would be useful for me is I have an TIDFieldList component, which takes a list of integers and displays them as "hot-links" (blue when
Users like it because it shows a whole lot of orders (or other children) in very little space & they just have to click to navigate to the Order.
The Order then has a similar TIDFieldList for OrderItems ...
To make it work at the moment I have to iterate a child query & parse then child query IDs into a variable in Delphi ... which works well, but is a bit
|Fri, Aug 25 2006 10:17 AM||Permanent Link|
I'd use a dbgrid and a master-detail relationship. The "goto order on click" functionality is a doddle.
|Thu, Aug 31 2006 5:11 PM||Permanent Link|
>>Roy Lambert <email@example.com> wrote:
>>I'd use a dbgrid and a master-detail relationship. The "goto order on click"
functionality is a doddle.
That's true Roy, but often the user doesn't really want a big "2 grid master detail" type
GUI for every single situation. With my solution the user "sees" a single record (i.e.
customer X), which contains what looks like a memo field with a simple list, but they can
click on the elements of the list to open a detailed rendition of the data for that element.
Grids are good, but there are often times when other ways of displaying the data give a
much more "sensitive" GUI for the user.
|Fri, Sep 1 2006 3:41 AM||Permanent Link|
Turn off the indicator, titles, grid row lines and column lines and you have a very good resemblance to a memo field. I do that quite a lot to display some forms of tabular data.