Forums

by JADE News Administrator >> Thu, 29 Oct 1998 2:25:32 GMT

Hi
Enclosed is a zip file containing scm/ddb schema files called WebDemo together with a Word document with complete installation and operating instructions.

The WebDemo schema is a JADE schema (working with JADE release 4.0.14 or later!!) designed to demonstrate some of the capabilities of running an application over the WWW. It is intended for use by sales people or anyone wanting to demonstrate the web-enabling capabilities of JADE.

This demonstration can be run as a normal JADE client and then as a web client in your browser.
It currently facilitates the following functionality in both environments :

· Addition, changing and deletion of customer records via a table interface · Display and selection of customer entries from a listbox
· Updating of single instances via an entry form using text boxes, drop down selection boxes, option buttons and checkboxes

It currently facilitates the following functionality in the browser environment :

· incorporation and use of a Java applet (Rubik’s cube puzzle!!)
· use of hot links to Internet URL’s and linking to those sites

Please submit any suggestions, comments to myself asap.

All donations gratefully received.

Ciao .................
Alan J.Thomson
ph...Auckland 09-277-7961 x 744
http://home.clear.net.nz/pages/athomson

by Paul Mathews >> Mon, 14 Dec 1998 7:13:01 GMT

Hi Alan, I have checked your work out in Windows and the WEB.
In March I wrote a TimeSheet system for the WEB, my first Jade Application, in JUly we got our own WEBSERVER, and we went to use the TimeSheets app. We came undone on the ComboBoxes in Tables, there was
a bug. When 4.19 arrived we upgraded and lo and behold still the same bug. It did not affect your application though. Regardless we received
a Patch from Jade Support yesterday from Paul Daigneault.

Testing your app yesterday, it appeared to me that the Toggle Boxes
DID not work over the Web. (I have not put in a report on this).

Also in my simplicity, I did not realise till the other day the stark difference in visualisation between Netscape and Explorer. Explorer
good for buttons, lousy for Tables, Netscape the reverse.

There have been two key approaches I have learnt to use for the WEB,

1) Have duplicate attributes between YourApplication and
TourWebSession such as myUser, but have a Mapping method on app.myUser such as
if currentSession <> null then
if set = false then
value := currentSession.SCMBase.myUser;
endif;
endif;

2) Use showLastForm to handle redisplaying a FormA after the FormB closes.

eg FormA is the Menu Form, with nothing much enabled, FormB is the
logon Form.
When FormA closes, want to enable and display new information based on the fact the person is now logged on.

SCMTimeSheet::showLastForm()updating;begin

openForms[openForms.size].reDisplayForm();
inheritMethod();
end;

addedMethod reDisplayForm to Form;

Locally implemeneted in WFMenuTimeSheets and WFMaintenance, which is inherited a number of times.

NB used jiggery pokery to get a localised version of showLastForm, bacically added a method showLastForms, extracted that method, edited
the .scm file, removed the s and loaded the method, viola, tres bien.

The final corespondence from Paul Daigneault was
//
Paul,

As per our discussion I have converted the contact to a new feature suggestion requesting either that showLastForm be able to be reimplemented
by the user or that JADE provide two methods, one that is executed
before
the HTML is generated and one that is executed after the HTML is generated.
NFS # 10074.

thanks,
Paul Daigneault,
JADE Support.
//

in the CMSchema there are two jadescripts which are invaluable for
this sort of stuff,

propertyNDict();

// Date: 20 October 1998
// User: paulm
// Copyright: C&M Systems Group

// Original Code was provided by Paul Daigneault of Jade Support, I
have tampered with it.
// Very Usefull to find out what goes on behind the scenes

vars
vCurrentClass : Class;
vPropertyNDict : PropertyNDict;
vProperty : Property;begin


// Simple
/*
vPropertyNDict := TcpIpConnection.getProperties();
foreach vProperty in vPropertyNDict do
write vProperty.name & ' ' & vProperty.type.name;
endforeach;
*/
// Inherited

vCurrentClass := Schema; // TcpIpConnection;
while vCurrentClass <> null
do
vPropertyNDict := vCurrentClass.getProperties();

foreach vProperty in vPropertyNDict do
write vCurrentClass.name & ' '& vProperty.name
& ' ' & vProperty.type.name & ' ' &
vProperty.type.access.Integer.String & ' ' & vProperty.type.subAccess.Integer.String;
endforeach;

vCurrentClass := vCurrentClass.getSuperclass;

if vCurrentClass = Object then
vCurrentClass := null;
endif;

endwhile;

end;

AND

methodNDict();

// Date: 20 October 1998
// User: paulm
// Copyright: C&M Systems Group

// Original Code was provided by Paul Daigneault of Jade Support, I
have tampered with it.
// Very usefull to find out what goes on behind the Scenes !

vars
vMethodNDict : MethodNDict;
vMethod : Method;begin

create vMethodNDict transient;
Inverse.getMethods(vMethodNDict);
foreach vMethod in vMethodNDict do
write vMethod.display;
endforeach;
delete vMethodNDict;
end;

by Anonymous >> Mon, 9 Jan 2006 14:45:23 GMT

Hi,

I am Jay here.
I would like to know more about Jade programming with External Databases. How can i write and read data to the external databases like SQL server, oracle or any other ?

Can anybody help me out in this please.
you can also mail me to jprashanth_ar@yahoo.com

regards

Jay

by dcooper@jade.co.nz >> Mon, 9 Jan 2006 19:21:56 GMT

Hi Jay,

Have a look at Chapter 8 (Transforming an External Relational Database) in the JADE Developer's Reference Manual (DevRef.pdf).

If you don't already have this PDF, you can download it from here:

http://www.jadeworld.com/jade/doc.htm

Cheers,
Dean.