BigJohn
14th February 2003, 01:51
Hi,
I had couple of questions.
What is common component architecture?
What is baan series?
What's the purpose of the mode in query.extend.select("<fields
to add>", [mode])?
can somebody give an eg of when one would use
EXTEND_OVERWRITE vs EXTEND_APPEND?
how can external applications use dal.set.error.message and
dal.get.error.message?
Thanks in advance.
John
NPRao
14th February 2003, 02:06
What's the purpose of the mode in query.extend.select("<fields to add>", [mode])?
can somebody give an eg of when one would use EXTEND_OVERWRITE vs EXTEND_APPEND?
|****************************** PROGRAM SECTION ***************************
before.program:
curr.comp = get.compnr() |* Current company
|**********************************************************************
|* Read Company parameters
|**********************************************************************
if not tfgld.dll6001.get.company.parameters(
curr.comp,
error.mess) then
message(error.mess)
stop()
endif
|* Calling program (Invoice inquiry - search criterea) process id
import("pid",import.prid)
if zoomfield$ = "tfzap5505m000"
or zoomfield$ = "selective" then
|* If called from tfzap5505m000, import the temporary table field
import("tfzap505.prid",import.prid)
endif
|* Apply filter if not synchronized (Multi-occurence calling single
|* occurence session for one record)
if not synchronized.reason then
query.extend.where("tfzap505.logn=:logname$ and "&
" tfzap505.prid=:import.prid",EXTEND_OVERWRITE)
endif
|* Fill temporary table
if not synchronized.reason
and zoomfield$ <> "tfzap5505m000"
and zoomfield$ <> "selective" then
fill.temporary.table()
endif
|* If Specific option "Open Selected Loads" is chosen
if zoomfield$ = "selective" then
query.extend.where("tfzap505.selc = tcyesno.yes",EXTEND_APPEND)
endif
fattr.total.line = true
Refer to following links for more info -
query.extend.select() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_sql_query_extensions_query_extend_select)
SQL query extensions overview (http://www.baanboard.com/programmers_manual_baanerp_help_functions_sql_query_extensions_overview)