Hi there
I am really going mad now! Please help I really need some advice I have read loads of the help and videos and still struggling
I am using http_post/http_post_page2 in the after insert event and it is not working
I have tested the code by building a user defined function and this works...
I dont think the after insert event is running...
How can I call the udf from a button on grid component OR ANY OTHER IDEAS I AM GOING AROUND IN CIRCLES
MUCH APPRECIATED!!
-------------
FUNCTION call_url AS C (pid AS N )
http_post_page2("http://localhost:8080/TrueServlet/Genius?","&deployementCode=01&server=localhost&user=sa&password=R0bin&db=TelecommsQuoting&wsurl=http://localhost:8080/KPRepositoryDemo_TQ_Test_Rules/WSKPRepositoryDemo_TQ_Test_RulesService&sql=SELECT PolicyID ,Name ,Surname ,ContactNumber ,EmailAddress ,BusinessOrPrivate ,statusreason,RequirePhone ,PhoneType ,NumberOfPhones ,InternetGigs ,InstallationAddress ,InstallationSuburb ,InstallationPostalCode ,Discount ,TotalCost ,AgentID ,Status ,ObtiquaGrid ,ObtiquaGridAmount ,Obox ,OboxAmount ,NetworkSwitch ,NetworkSwitchAmount ,MicrotikGrid ,MicrotikGridAmount ,IPPBx ,IPPBxAmount ,IPPhone ,IPPhoneAmount ,AnaloguePhone ,AnaloguePhoneAmount ,CableMeter ,CableMeterAmount ,Bracket ,BracketAmount ,ADSLGSRouter ,ADSLGSRouterAmount ,GatewayPort ,GatewayPortAmount ,PoleMeter ,PoleMeterAmount ,RequiredDeposit ,InstallationHours ,InstallationCost ,ConnectionFee ,AirtimeCallChargesPeak ,AirtimeCallChargesOffPeak ,IncomeCategory ,InternetCost FROM PolicyRequest where policyid = "+pid+"&insert= INSERT INTO RuleMessage ( RuleRunDateTime , PcgDesc , RuleNo , MessageCode , Severity , LongMsgDescription , ShortMsgDescription , adslgsrouteramount_1_policyrequest , agentid_1_policyrequest , analoguephone_1_policyrequest , analoguephoneamount_1_policyrequest , bracket_1_policyrequest , bracketamount_1_policyrequest , cablemeter_1_policyrequest , cablemeteramount_1_policyrequest , discount_1_policyrequest , gatewayport_1_policyrequest , gatewayportamount_1_policyrequest , internetcost_1_policyrequest , ippbx_1_policyrequest , ippbxamount_1_policyrequest , ipphone_1_policyrequest , ipphoneamount_1_policyrequest , microtikgrid_1_policyrequest , microtikgridamount_1_policyrequest , networkswitch_1_policyrequest , networkswitchamount_1_policyrequest , obox_1_policyrequest , oboxamount_1_policyrequest , obtiquagrid_1_policyrequest , obtiquagridamount_1_policyrequest , polemeter_1_policyrequest , polemeteramount_1_policyrequest , PolicyID_1_policyrequest , ADSLGSRouter_1_policyrequest , requireddeposit_1_policyrequest , internetgigs_1_policyrequest , installationhours_1_policyrequest , installationcost_1_policyrequest , connectionfee_1_policyrequest , airtimecallchargespeak_1_policyrequest , airtimecallchargesoffpeak_1_policyrequest )VALUES")
END FUNCTION
I am really going mad now! Please help I really need some advice I have read loads of the help and videos and still struggling
I am using http_post/http_post_page2 in the after insert event and it is not working
I have tested the code by building a user defined function and this works...
I dont think the after insert event is running...
How can I call the udf from a button on grid component OR ANY OTHER IDEAS I AM GOING AROUND IN CIRCLES
MUCH APPRECIATED!!
-------------
FUNCTION call_url AS C (pid AS N )
http_post_page2("http://localhost:8080/TrueServlet/Genius?","&deployementCode=01&server=localhost&user=sa&password=R0bin&db=TelecommsQuoting&wsurl=http://localhost:8080/KPRepositoryDemo_TQ_Test_Rules/WSKPRepositoryDemo_TQ_Test_RulesService&sql=SELECT PolicyID ,Name ,Surname ,ContactNumber ,EmailAddress ,BusinessOrPrivate ,statusreason,RequirePhone ,PhoneType ,NumberOfPhones ,InternetGigs ,InstallationAddress ,InstallationSuburb ,InstallationPostalCode ,Discount ,TotalCost ,AgentID ,Status ,ObtiquaGrid ,ObtiquaGridAmount ,Obox ,OboxAmount ,NetworkSwitch ,NetworkSwitchAmount ,MicrotikGrid ,MicrotikGridAmount ,IPPBx ,IPPBxAmount ,IPPhone ,IPPhoneAmount ,AnaloguePhone ,AnaloguePhoneAmount ,CableMeter ,CableMeterAmount ,Bracket ,BracketAmount ,ADSLGSRouter ,ADSLGSRouterAmount ,GatewayPort ,GatewayPortAmount ,PoleMeter ,PoleMeterAmount ,RequiredDeposit ,InstallationHours ,InstallationCost ,ConnectionFee ,AirtimeCallChargesPeak ,AirtimeCallChargesOffPeak ,IncomeCategory ,InternetCost FROM PolicyRequest where policyid = "+pid+"&insert= INSERT INTO RuleMessage ( RuleRunDateTime , PcgDesc , RuleNo , MessageCode , Severity , LongMsgDescription , ShortMsgDescription , adslgsrouteramount_1_policyrequest , agentid_1_policyrequest , analoguephone_1_policyrequest , analoguephoneamount_1_policyrequest , bracket_1_policyrequest , bracketamount_1_policyrequest , cablemeter_1_policyrequest , cablemeteramount_1_policyrequest , discount_1_policyrequest , gatewayport_1_policyrequest , gatewayportamount_1_policyrequest , internetcost_1_policyrequest , ippbx_1_policyrequest , ippbxamount_1_policyrequest , ipphone_1_policyrequest , ipphoneamount_1_policyrequest , microtikgrid_1_policyrequest , microtikgridamount_1_policyrequest , networkswitch_1_policyrequest , networkswitchamount_1_policyrequest , obox_1_policyrequest , oboxamount_1_policyrequest , obtiquagrid_1_policyrequest , obtiquagridamount_1_policyrequest , polemeter_1_policyrequest , polemeteramount_1_policyrequest , PolicyID_1_policyrequest , ADSLGSRouter_1_policyrequest , requireddeposit_1_policyrequest , internetgigs_1_policyrequest , installationhours_1_policyrequest , installationcost_1_policyrequest , connectionfee_1_policyrequest , airtimecallchargespeak_1_policyrequest , airtimecallchargesoffpeak_1_policyrequest )VALUES")
END FUNCTION
Comment