We are a Partner of
NetBeans. CROSSFIRE JAPAN is registered HERE.
ComponentSource is the biggest market place of Software Products.
To be a partner
Please vote us !
When you execute the method, your programs have to input data into the
method by argument. (Data is for example, id, name, or numbers in the ügWHEREüh
For example, you designed following SQL
SELECT * FROM TOY WHERE ID = üe$IDüf$ID is a valuable you want to input on executing the method.
The term starting with üe$üf is the valuable and it is replaced automatically on executing the method
You can use the Runtime Valuables in any field of SQL.
||SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
||DELETE FROM, WHERE
You can call other method executing SELECT SQL as sub query.
For example, you design following SQL
UPDATE CHILDREN SET ID = (@selectMax) + 1
üeselectMaxüf is a method name executing SELECT SQL. The term starting with
üe@üf means sub query. If selectMax means SQL below
SELECT MAX(CHILDREN.ID) FROM CHILDREN
The first SQL will be transformed like below
UPDATE CHILDREN SET ID = (SELECT MAX(CHILDREN.ID)
FROM CHILDREN) + 1
adjustment on executing the method
(Pro Edition Only)
This function is very powerful. You can
user valuable in the conditionüfs field. But when you execute the method if the
valuable is unset, what happen?
Then the generated program (Framework) automatically adjusts the
Ex.1. You designed condition below and 1 of 3 conditionüfs valuable
Ex.2. You designed condition below and 1 of 2 conditionüfs valuable is