cazerpa
9th October 2004, 03:50
I am using Baan V, but the main.table.io: is not executed. besides, I have used query.extesion and nothing happend. The main table is whinr140.

before.program:
fattr.total.line = true
ret = get.var(parent,"v.item",item)
ret = get.var(parent,"v.oorg",whinh225.oorg)
ret = get.var(parent,"v.orno",whinh225.orno)
ret = get.var(parent,"v.oset",whinh225.oset)
ret = get.var(parent,"v.pono",whinh225.pono)
ret = get.var(parent,"v.seqn",whinh225.seqn)
ret = get.var(parent,"v.cwar",cwar)
ret = get.var(parent,"v.qstr",whinh220.qstr)

select tcibd001.* from tcibd001 where tcibd001._index1 = {:item} selectdo endselect

|****************************** main table io *********************************

main.table.io:
after.read:
if whinr140.cwar <> cwar or whinr140.item <> item then
skip.io("")
endif

|****************************** function section ******************************

mark_h
10th October 2004, 17:25
What type of session is it? Display, print, maintain, etc. My first thought was that the session type was not the correct type to have a main.table.io section. Of course I do not know anything about Baan V.

Mark

NPRao
10th October 2004, 19:22
cazerpa,

Refer to the Tools programmer manual -

Note that main.table.io sections (except the read.view subsection) are ignored when the corresponding DAL hooks are programmed in a DAL script.
4GL main table i/o sections (http://www.baanboard.com/programmers_manual_baanerp_help_4gl_features_4gl_main_table_io_sections)

For query extensions you have to change your code. Refer to -

Query extensions (http://www.baanboard.com/programmers_manual_baanerp_help_functions_dal_query_extensions)

cazerpa
11th October 2004, 17:41
What type of session is it? Display, print, maintain, etc. My first thought was that the session type was not the correct type to have a main.table.io section. Of course I do not know anything about Baan V.

Mark

La session is TYPE 3,

Regards,

Carlos Zerpa

mark_h
12th October 2004, 13:48
Have you checked what NPRao posted? I would expect a maintain session to jump into the maintable io section, but since this is Baan V I have not idea why it would not work.

Mark

cazerpa
12th October 2004, 17:33
Have you checked what NPRao posted? I would expect a maintain session to jump into the maintable io section, but since this is Baan V I have not idea why it would not work.

Mark
I've already chechek what NPRao postes. But I don't indestand why the QUERY.EXTESION and the MAIN,TABLE.OI funcionally is not working.
Besides, Y turned off the DAL on the table whinr140 and the behavior was the same.\

NPRao
12th October 2004, 20:05
cazerpa,

I am not sure where are you using the code. Try to change your code to check - if background then ... endif because the get.var is expecting a parent process id.

Try to debug and see the values of the variables in the get.var() call.

I havent used the main.table.io in our BaaN version but query extend works good.

before.program:
curr.comp = get.compnr()
change.company(MIGRATION.COMPANY)
if check.baaninfra() or check.tsg() or check.superuser() then
flag = 1
else
flag = 0
endif
if not synchronized.reason then
get.updated.info()
if not flag then
query.extend.where("zmadm200.user='"&logname$&"'")
endif
endif
after.program:
change.company(curr.comp)