Forums

by micc >> Mon, 23 Jun 2008 7:48:53 GMT

Hello People

Somebody know about DML or OQL in JADE Database ?
Please give me some clue !

Thanks a lot
micc

by Dean Cooper >> Mon, 23 Jun 2008 8:23:49 GMT

JADE doesn't support OQL.

JADE has its own language that is used to manipulate data, so in this sense it is a procedural Data Manipulation Language (DML).

For example, the following JADE code would add 100 to the balance of a customer named "Fred", where customers are held in a dictionary (allCustomers) on a singleton Company object:

vars
coy : Company;
cust : Customer;begin

coy := Company.firstInstance;
cust := coy.allCustomers["Fred"];
beginTransaction;
cust.balance := cust.balance + 100;
commitTransaction;
end;

Dean.

by micc >> Tue, 24 Jun 2008 11:39:37 GMT

Dear Dean Cooper and All

Thanks for your answer and example
this is very good example
and make me clear
---------

It is such difficult to migrate my knowledge from DDL ( SQL query ) to JADE language.
then ..
do you have some literature or ebook that explain some comparison between SQL and JADE ?

thanks a lot

Grüß
micc

by micc >> Tue, 24 Jun 2008 11:40:32 GMT

Dear Dean Cooper and All

Thanks for your answer and example
this is very good example
and make me clear
---------

It is such difficult to migrate my knowledge from DDL ( SQL query ) to JADE language.
then ..
do you have some literature or ebook that explain some comparison between SQL and JADE ?

thanks a lot

Grüß
micc

by micc >> Tue, 24 Jun 2008 11:41:10 GMT

Dear Dean Cooper and All

Thanks for your answer and example
this is very good example
and make me clear
---------

It is such difficult to migrate my knowledge from DDL ( SQL query ) to JADE language.
then ..
do you have some literature or ebook that explain some comparison between SQL and JADE ?

thanks a lot

Grüß
micc