User login
|
|
|
|
Frontpage Sponsor
|
|
|
|
Baanboard at LinkedIn
|
|
|
Poll
|
What actions do you take to ensure compliance with the sanction/embargo lists published by the EU and the US? don't know what you are talking about 55% we are scanning customers, suppliers and employees using own programs on a regular basis 12% each delivery/purchase adress is checked immediately with own programs 2% we are using third party software for this purpose 10% we simply don't bother 20% Total votes: 49 |
|
|
|
Query extensions sample program
|
|
By patvdv at 26 Feb 2008 - 21:57
|
Query extensions sample program
This is an example of a simple query extension programmed in the DAL for the main table 'qmptc015'. The unit (qmptc021.cual) of the algorithm (qmptc015.algo) must have the same physical quantity as the unit defined in the table (qmptc015.chun).
function extern long before.open.object.set()
{
query.extend.select("qmptc021.cual")
query.extend.from("qmptc021")
query.extend.where(":qmptc015.algo refers to qmptc021")
}
function extern long qmptc015.algo.check(long has_changed)
{
if has_changed then
tcibd.dll0003.read.mcs001.tccu(qmptc015.chun,
qmptc021.cual, basu.tccu, unit.tccu)
if basu.tccu <> unit.tccu then
dal.set.error.message("qmptcs011526")
|* Algorithm and characteristic units must have the
|* same physical quantity
return(DALHOOKERROR)
endif
endif
}
An example of a simple query extension programmed in the UI script.
field.tejzw101.orno:
selection.filter:
query.extend.where.in.zoom("tejzw100.item = " & quoted.string(tejzw101.item))
| quoted.string() is used here, because the value of tejzw101.item might contain (double) quotes.
Related topics
|
|
All times are GMT +2. The time now is 01:36.
