Good morning all.
I cannot seem to figure out how to export a set from a xbasic script. I created an operation to export the set and it works like a champ. I copied the xbasic to a script, changed the the pointer and cannot seem to get it to work.
original xbasic:
a_tbl = table.current()
query.order = "Adcode"
query.filter = "Adadrc=\"CM\".AND.Adtype=\"99\".AND.(Adcode=\"10\".OR.Adcode=\"330\")"
query.options = "I"
a_tbl.query_create()
export.type = 0
export.names = .T.
export.file = "c:\prime_dms\temp\mpad_mpcm_set.csv"
export.options = "LT"
export.field_sep = ","
export.record_sep = "<CR><LF>"
export.fields = 5
export.field1 = "adadrc"
export.field2 = "adtype"
export.field3 = "adcode"
export.field4 = "dmf010_mpcm->cmname"
export.field5 = "dmf010_mpcm->cmempl"
a_tbl.export()
modified xbasic:
DIM A_TBL AS P
A_TBL=SET.open("dmf010_mpad_mpcm.set")
query.order = "Adcode"
query.filter = "Adadrc=\"CM\".AND.Adtype=\"99\".AND.(Adcode=\"10\".OR.Adcode=\"330\")"
query.options = "I"
a_tbl.query_create()
export.type = 0
export.names = .T.
export.file = "c:\prime_dms\temp\mpad_mpcm_set.csv"
export.options = "LT"
export.field_sep = ","
export.record_sep = "<CR><LF>"
export.fields = 5
export.field1 = "adadrc"
export.field2 = "adtype"
export.field3 = "adcode"
export.field4 = "dmf010_mpcm->cmname"
export.field5 = "dmf010_mpcm->cmempl"
a_tbl.export()
it doesn't like the query. Take it out and it doesn't like the export. I have read about people combining the export table into one, but that defeats the purpose of the set.
Thanks!!
I cannot seem to figure out how to export a set from a xbasic script. I created an operation to export the set and it works like a champ. I copied the xbasic to a script, changed the the pointer and cannot seem to get it to work.
original xbasic:
a_tbl = table.current()
query.order = "Adcode"
query.filter = "Adadrc=\"CM\".AND.Adtype=\"99\".AND.(Adcode=\"10\".OR.Adcode=\"330\")"
query.options = "I"
a_tbl.query_create()
export.type = 0
export.names = .T.
export.file = "c:\prime_dms\temp\mpad_mpcm_set.csv"
export.options = "LT"
export.field_sep = ","
export.record_sep = "<CR><LF>"
export.fields = 5
export.field1 = "adadrc"
export.field2 = "adtype"
export.field3 = "adcode"
export.field4 = "dmf010_mpcm->cmname"
export.field5 = "dmf010_mpcm->cmempl"
a_tbl.export()
modified xbasic:
DIM A_TBL AS P
A_TBL=SET.open("dmf010_mpad_mpcm.set")
query.order = "Adcode"
query.filter = "Adadrc=\"CM\".AND.Adtype=\"99\".AND.(Adcode=\"10\".OR.Adcode=\"330\")"
query.options = "I"
a_tbl.query_create()
export.type = 0
export.names = .T.
export.file = "c:\prime_dms\temp\mpad_mpcm_set.csv"
export.options = "LT"
export.field_sep = ","
export.record_sep = "<CR><LF>"
export.fields = 5
export.field1 = "adadrc"
export.field2 = "adtype"
export.field3 = "adcode"
export.field4 = "dmf010_mpcm->cmname"
export.field5 = "dmf010_mpcm->cmempl"
a_tbl.export()
it doesn't like the query. Take it out and it doesn't like the export. I have read about people combining the export table into one, but that defeats the purpose of the set.
Thanks!!
Comment