Error in event handler code for OnClick event for 'POSTORDER': Error 0
POSTORDER POSTORDER
I have the following code but do not know what the above error means.
I believe me issue is coming from the fact that I need to export from a set or
two tables.
here is the code I have it inside a web dialog fire from the an "advancedbutton"
events server fires xbasic when clicked!
************code **********************
a_tbl = table.open("[PathAlias.ADB_Path]\temphdr")
a_tbl = table.open("[PathAlias.ADB_Path]\templine")
query.order = ""
query.filter = ".T."
query.options = "I"
a_tbl.query_create()
export.type = 0
export.names = .F.
export.file = "C:\A5JOBS\mcni\10000.TIK"
export.options = ""
export.field_sep = ""+chr(13)+chr(10)
export.record_sep = "<CR><LF>"
export.fields = 80
export.field1 = "temphdr->h0001invoice"
export.field2 = "temphdr->h0002n0"
export.field3 = "temphdr->h0003valid"
export.field4 = "temphdr->h0004custno"
export.field5 = "temphdr->h0005custname"
export.field6 = "temphdr->h0006"
export.field7 = "temphdr->h0007addr1"
export.field8 = "temphdr->h0008city"
export.field9 = "temphdr->h0009state"
export.field10 = "temphdr->h0010zip"
export.field11 = "temphdr->h0011tel1"
export.field12 = "temphdr->h0012"
export.field13 = "temphdr->h0013"
export.field14 = "temphdr->h0014shipto"
export.field15 = "temphdr->h0015shiptoname"
export.field16 = "temphdr->h0016"
export.field17 = "temphdr->h0017saddr1"
export.field18 = "temphdr->h0018scity"
export.field19 = "temphdr->h0019sstate"
export.field20 = "temphdr->h0020szip"
export.field21 = "temphdr->h0021stel2"
export.field22 = "temphdr->h0022typei"
export.field23 = "temphdr->h0023netsale"
export.field24 = "temphdr->h0024saletac"
export.field25 = "temphdr->h0025totalsale"
export.field26 = "temphdr->h0026salenotax"
export.field27 = "temphdr->h0027"
export.field28 = "temphdr->h0028"
export.field29 = "temphdr->h0029"
export.field30 = "temphdr->h0030"
export.field31 = "temphdr->h0031totsale"
export.field32 = "temphdr->h0032"
export.field33 = "temphdr->h0033"
export.field34 = "temphdr->h0034"
export.field35 = "temphdr->h0035date"
export.field36 = "temphdr->h0036"
export.field37 = "temphdr->h0037"
export.field38 = "temphdr->h0038"
export.field39 = "temphdr->h0039"
export.field40 = "temphdr->h0040"
export.field41 = "temphdr->h0041"
export.field42 = "temphdr->h0042"
export.field43 = "temphdr->h0043"
export.field44 = "temphdr->h0044"
export.field45 = "temphdr->h0045tax"
export.field46 = "temphdr->h0046"
export.field47 = "temphdr->h0047"
export.field48 = "temphdr->h0048"
export.field49 = "temphdr->h0049"
export.field50 = "temphdr->h0050"
export.field51 = "temphdr->h0051"
export.field52 = "temphdr->h0052"
export.field53 = "temphdr->h0053"
export.field54 = "temphdr->h0054"
export.field55 = "templine->l0101no"
export.field56 = "templine->l0102desc"
export.field57 = "templine->l0103qty"
export.field58 = "templine->l0104price"
export.field59 = "templine->l0105"
export.field60 = "templine->l0106"
export.field61 = "templine->l0107"
export.field62 = "templine->l0108"
export.field63 = "templine->l0109"
export.field64 = "templine->l0110"
export.field65 = "templine->l0111"
export.field66 = "templine->l0112"
export.field67 = "templine->l0113"
export.field68 = "templine->l0114"
export.field69 = "templine->l0115"
export.field70 = "templine->l0116"
export.field71 = "templine->l0117"
export.field72 = "templine->l0118"
export.field73 = "templine->l0119"
export.field74 = "templine->l0120"
export.field75 = "templine->l0121"
export.field76 = "templine->l0122"
export.field77 = "templine->l0123"
export.field78 = "templine->l0124"
export.field79 = "templine->l0199"
export.field80 = "templine->h0001invoice"
a_tbl.export()
a_tbl.close()
POSTORDER POSTORDER
I have the following code but do not know what the above error means.
I believe me issue is coming from the fact that I need to export from a set or
two tables.
here is the code I have it inside a web dialog fire from the an "advancedbutton"
events server fires xbasic when clicked!
************code **********************
a_tbl = table.open("[PathAlias.ADB_Path]\temphdr")
a_tbl = table.open("[PathAlias.ADB_Path]\templine")
query.order = ""
query.filter = ".T."
query.options = "I"
a_tbl.query_create()
export.type = 0
export.names = .F.
export.file = "C:\A5JOBS\mcni\10000.TIK"
export.options = ""
export.field_sep = ""+chr(13)+chr(10)
export.record_sep = "<CR><LF>"
export.fields = 80
export.field1 = "temphdr->h0001invoice"
export.field2 = "temphdr->h0002n0"
export.field3 = "temphdr->h0003valid"
export.field4 = "temphdr->h0004custno"
export.field5 = "temphdr->h0005custname"
export.field6 = "temphdr->h0006"
export.field7 = "temphdr->h0007addr1"
export.field8 = "temphdr->h0008city"
export.field9 = "temphdr->h0009state"
export.field10 = "temphdr->h0010zip"
export.field11 = "temphdr->h0011tel1"
export.field12 = "temphdr->h0012"
export.field13 = "temphdr->h0013"
export.field14 = "temphdr->h0014shipto"
export.field15 = "temphdr->h0015shiptoname"
export.field16 = "temphdr->h0016"
export.field17 = "temphdr->h0017saddr1"
export.field18 = "temphdr->h0018scity"
export.field19 = "temphdr->h0019sstate"
export.field20 = "temphdr->h0020szip"
export.field21 = "temphdr->h0021stel2"
export.field22 = "temphdr->h0022typei"
export.field23 = "temphdr->h0023netsale"
export.field24 = "temphdr->h0024saletac"
export.field25 = "temphdr->h0025totalsale"
export.field26 = "temphdr->h0026salenotax"
export.field27 = "temphdr->h0027"
export.field28 = "temphdr->h0028"
export.field29 = "temphdr->h0029"
export.field30 = "temphdr->h0030"
export.field31 = "temphdr->h0031totsale"
export.field32 = "temphdr->h0032"
export.field33 = "temphdr->h0033"
export.field34 = "temphdr->h0034"
export.field35 = "temphdr->h0035date"
export.field36 = "temphdr->h0036"
export.field37 = "temphdr->h0037"
export.field38 = "temphdr->h0038"
export.field39 = "temphdr->h0039"
export.field40 = "temphdr->h0040"
export.field41 = "temphdr->h0041"
export.field42 = "temphdr->h0042"
export.field43 = "temphdr->h0043"
export.field44 = "temphdr->h0044"
export.field45 = "temphdr->h0045tax"
export.field46 = "temphdr->h0046"
export.field47 = "temphdr->h0047"
export.field48 = "temphdr->h0048"
export.field49 = "temphdr->h0049"
export.field50 = "temphdr->h0050"
export.field51 = "temphdr->h0051"
export.field52 = "temphdr->h0052"
export.field53 = "temphdr->h0053"
export.field54 = "temphdr->h0054"
export.field55 = "templine->l0101no"
export.field56 = "templine->l0102desc"
export.field57 = "templine->l0103qty"
export.field58 = "templine->l0104price"
export.field59 = "templine->l0105"
export.field60 = "templine->l0106"
export.field61 = "templine->l0107"
export.field62 = "templine->l0108"
export.field63 = "templine->l0109"
export.field64 = "templine->l0110"
export.field65 = "templine->l0111"
export.field66 = "templine->l0112"
export.field67 = "templine->l0113"
export.field68 = "templine->l0114"
export.field69 = "templine->l0115"
export.field70 = "templine->l0116"
export.field71 = "templine->l0117"
export.field72 = "templine->l0118"
export.field73 = "templine->l0119"
export.field74 = "templine->l0120"
export.field75 = "templine->l0121"
export.field76 = "templine->l0122"
export.field77 = "templine->l0123"
export.field78 = "templine->l0124"
export.field79 = "templine->l0199"
export.field80 = "templine->h0001invoice"
a_tbl.export()
a_tbl.close()
Comment