Re: table OCX control
От | Mark A. Taff |
---|---|
Тема | Re: table OCX control |
Дата | |
Msg-id | LOBBLBDHPFLLCMMKPMFKEEJKDDAA.mark@libertycreek.net обсуждение исходный текст |
Ответ на | table OCX control (Tim Finch <pgadmin@timfinch.cix.co.uk>) |
Ответы |
Re: table OCX control
(Tim Finch <pgadmin@timfinch.cix.co.uk>)
|
Список | pgadmin-hackers |
I like the control. Some discussion points: 1. I think the control need to be resizable, both by a minimize button and by border dragging. 2. I like the notion of each instance of the control having the appropriate icon (table, view, function, etc). 3. The diagramming pane should also have scroll bars, as required. I don't recall off the top of my head if it is there yet or not. 4. What are your plans/thoughts on linking entities? For example, in a standard diagramming section, I think FK relationships ought to be rendered graphically between objects. In the pane for the view designer though, the user ought to be able to draw the relationship and modify them to show inner, outer, cross joins, etc. Your thoughts? Regards, Mark -----Original Message----- From: pgadmin-hackers-owner@postgresql.org [mailto:pgadmin-hackers-owner@postgresql.org]On Behalf Of Tim Finch Sent: Thursday, March 07, 2002 3:01 AM To: pgadmin-hackers@postgresql.org Subject: [pgadmin-hackers] table OCX control Dear all, Firstly may I apologise to Mark. The work I outline in this message was done before I realised you had already made the first version of the DataWidget ocx control. I had totally missed it. http://www.fosterfinch.co.uk/pgadmin The site has a link to a screen grab of my first table ocx control design. it has absolutely no code in it yet. Things to note, and for discussion - Tables will be able to be themed (blue, red, white, yellow), wher the background colours all change to that theme, if the user wishes to, in order to spot tables quicker in the designer - Bold fieldnames are Primary Keys - italic fieldnames have some form on constraint other than FK on them - underlined fields are FKs - tick boxes on left do what MS SQL designer does, selects fields for display - White boxes at end of fieldname line tell you the column type in abbreviated form (i8 - Int8, Vc - Varchar etc.) - The idea will bwe that when the user hovers over one of these a pop up tells you additional info like Varchar length, or check/FK constraint details Thoughts: - Mark, I see you have fleshed out more on the code side of your datawidgets, I will use these methods/props etc where feasible. I feel that my design of the datatable ocx is a bit more clean and less fussy. As the designer is going to be pressured for screen space at the top for the tables we are going to need to keep the tables small. - I know the wish list for pgAdmin contains the idea of a project file in the future. This is going to be a key requirement, esp where query designing is concerned as the user will position tables and colour them etc. and will want this to be retrieved. Surely one of the best places to keep the project file is actually in a table in database itself? In the meantime, what will we do about storing the non SQL aspects of a view design for retrieval later on - simply save them to a .pvd (PgAdmin View Design) file on the local drive of the user? Hope this input helps get ideas rolling. Tim. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgadmin-hackers по дате отправления: