Question

[Rock Ridge Farm (Larry)]

I have looked at all the examples and post, now I am ready to start.
I want to build a window that contains 3 browse objects.
The first object will be filled from a database, the second filled from a database based
on the current selection from the first, The third filled from a database based on the
current selection in the second.
This will be a list of systems, list of users on the system, and list of systems that the
user has access to.

Now I understand that the database functions are not ready yet - I am just trying to
get a head start on the windows and controls.

So - the question - how do I create the main window container and the three containers
for the browse objects. Assume 10 lines per browse object.

Is this understandable to anyone other than me?

[Zen]

The Color controls demo is a good one to study at. Also the editor example. These both show prety much what you need to get youself started off.

I guess you will just use 3 listview controls to display your data.

Lewis

[Zen]

Im a bit buys at the moment and its late here in the UK, 1am. But if you are stuck then id be glad to help tomorrow.

Lewis

[Ionic Wind Support Team]

I want to build a window that contains 3 browse objects.

What exactly do you mean by 'browse objects' ?

[Rock Ridge Farm (Larry)]

A browse object is associated with a query. These are the terms I am use to from
4GL programming.
The broswe object is a container that contains list of records that are selectable triggering an action. A query is the object that fills the browse object.
For example I would define a query (browse) that would retreive selected records from the database - they would be displayed as a list within the associated browse
object, frame, form or window.

An example in 4gl:

DEFINE BROWSE BROWSE-6
  QUERY BROWSE-6 NO-LOCK DISPLAY
      Systems.SystemName COLUMN-LABEL "System Name" FORMAT "x(20)":U
            WIDTH 30.57
      Systems.Classification FORMAT "x(20)":U WIDTH 32.57
      Systems.CpuType COLUMN-LABEL "Cpu Type" FORMAT "x(10)":U
            WIDTH 19
      Systems.lastupdate COLUMN-LABEL "Last Updatee" FORMAT "99/99/99":U
    WITH NO-ROW-MARKERS SEPARATORS SIZE 108 BY 5.27 ROW-HEIGHT-CHARS .56 EXPANDABLE.

A frame (window) using the browse:
DEFINE FRAME fMain
     sel_usr AT ROW 2.77 COL 18 COLON-ALIGNED NO-LABEL
     BUTTON-3 AT ROW 3 COL 58
     BUTTON-1 AT ROW 3 COL 86.57
     BROWSE-6 AT ROW 4.5 COL 1.57
     BROWSE-7 AT ROW 10 COL 1
     BROWSE-9 AT ROW 16.23 COL 1
     "OS Account Admin System/User Viewer" VIEW-AS TEXT
          SIZE 38 BY 1 AT ROW 1 COL 33
     "Search User ID" VIEW-AS TEXT
          SIZE 15.57 BY .88 AT ROW 2.77 COL 3.57
    WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
         SIDE-LABELS NO-UNDERLINE THREE-D
         AT COL 1 ROW 1.13 SCROLLABLE .

I am sure this does not help much but it is my atempt to reach a common ground.

[Ionic Wind Support Team]

Interesting language.  A bit verbose for my taste

I have an idea of what you want to do, but no way to show how to implement it yet until the database library is finished.  Aurora wil be a bit more low level than that.  You'll have to create a layout for the data you want to display, and then use the database library to generate a result set.  The database library uses SQL statements, if your familiar with them.

Once a successful query is made with the database library you need to scroll through the result set, reading the data, and display it in your window.

Paul.

[Zen]

Paul, as regards to the database library. Will you support native connections to popular database servers such as MySQL MSSQL etc. Or will you just use ODBC? I just want to know because if you are then i dont have to add it to my Common Classes library im making.

Lewis

[Ionic Wind Support Team]

Just ODBC for the moment.  Since I already have a vast code library for it.

I've used MySQL through ODBC quite successfully as well.

[Zen]

Ive used MySQL through ODBC with IBasic but its quite a lot slower, espessialy if you want to do high-end web applications.

Lewis

[Ionic Wind Support Team]

I could look into doing native MySQL like php does.  But that would be a future project.

Right tool for the right job and all.  Nothing beats a linux server running Apache, MySQL and PHP for web based applications

[Zen]

So true. I do design all my web apps on windows but i always use Linux servers with apache when i am not hosting on my own server. Ive tried using windows server 2003 and it is good but it still doesnt compare to any form of Linux. Give me good old Red Hat any day!!!

Lewis

[Rock Ridge Farm (Larry)]

Is there an example program using listview?

[Ionic Wind Support Team]

The listview control class will be in the next update.  The last alpha added all of the base windows controls.  Alpha2 will have all of the common controls by the time it is completed.

Paul.

[Rod]

Curiousity question for Larry: is that 4GL language sample from "Progress"?

[Rock Ridge Farm (Larry)]

Yup - it is Progress.

[Rod]

WARNING: Opinion ahead!

Progress' browse control, and PowerBuilder's datawindow, are very sophisticated data-bound controls, a long step ahead of what I would reasonably expect to see in most programming languages. They are awesome controls if and when you have them, but may be more of a candidate for an add-on package than a part of the base language.

Anybody wanna take on the project???

[Rock Ridge Farm (Larry)]

I understand that - I was just trying to explain what I want to do.
I wrote the application in Progress and in VB using Access.
VB with Access did not work well and Progress has too much bagage.
I will do it in ibasic or Aruora - most likely Aurora since I still do not have ibasic.
The ibasic team has been a little slow in responding to my order.
So with all that said - I will be building a system administrators system/user
package. I need to keep track of 700+ servers and the associated users.
About 200 are AIX or Sun, 5 are AS400, 20 or so Linux and the rest Windows.
We have about 6000+ users with many on multiple systems.

[Zen]

Anybody wanna take on the project???

Yeh ill do it. Never used them before but i suppose i could give it a go in my spare time.

Lewis

[Ionic Wind Support Team]

VB with Access did not work well

Access is not meant for multi user concurrent queries.  It is best suited for a monolithic application.  ODBC can use any driver, including MSSQL.

Paul.

[Rock Ridge Farm (Larry)]

It was being used single user. I did it to prove the concept.
Progress works well but has much baggage and is not the corporate db standard.
It must use sql, oracle, or sybase. The ODBC component should allow me to use
one of these databases.
Due to auditing requirements we need to be able to show every system a user has
access and every user for every system in which ever order the auditor request it.
This is why the screen has 3 sub windows. Systems -> Users on the system -> Other
systems any selected user in the mid window has access.
Auditors are happy when you can provide information they request quickly - they usually
only start digging in areas where you can't.