QueryTurnaround

QueryTurnaround.asmx

This web service lets the user execute the SQL query.

 

ExecuteQuery

Usage:

ExecuteQueryResult = A.ExecuteQuery(UserName, UserPassword, query, numberOfRecords)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Type

Detail

query

String

System will automatically add “SELECT ” to the query string. For example, if user wants to execute SQL command “SELECT ORDER_NO FROM CPORDHDR,” he/she needs to set this query string as “ORDER_NO FROM CPORDHDR.”

numberOfRecords

String

Maximum number of returned records.

 

ExecuteQueryResult Structure

Property Name

Type

Detail

ReturnCode

Integer

0 = OK

10001 = missing query

Data

DataSet

Contains a data table (table name “Data”). The rows in data table depends on your query.

ReturnMsg

String

If a database error is encountered, the error number is returned in the ReturnCode property and the error message text is return in the ReturnMsg property.

 

Code Example

The following sample code will make an order inquiry.

 

Dim Service As New webServicesQueryTurnaround.QueryTurnaround()

Dim Result As New webServicesQueryTurnaround.ExecuteQueryResult

Dim query As String = “ORDER_NO, ORDER-DATE, ORDER-TYPE, ORDER-SHIP-TO-NO FROM CPORDHDR WHERE ORDER_NO > 112487 AND ORDER_NO < 115877”

Dim numberOfRecords As String = “999”

Result = Service.ExecuteQuery(“”, “”, query, numberOfRecords)

If Result.ReturnCode = 0 Then

  If Result.Data.Tables(0).Rows.Count > 0 Then

     lblResult.Text = “First Matching Order No. is” & _

      Result.Data.Tables(0).Rows(0).Item("ORDER_NO")

  Else

     lblResult.Text = “No Matching Order.”

  End If

Else

  lblResult.Text = “Error”

  lblErrorCode.Text = Result.ReturnCode.ToString + ': " + Result.ReturnMsg

End If

Developer Documentations

  1. Received Code 9999 with Web Services Call
  2. Received Return Status Code 3 When Using Elilogin Login Method
  3. Elliott Web Service Requirements
  4. Elliott eStore Checklist
  5. LN API
  6. FN API
  7. RN API
  8. IN and DF API Change (V9.0)
  9. FA API Changes (V9.0)
  10. VA API Changes (V9.0)
  11. CartService
  12. EliarachService
  13. ElicshtxService
  14. EliattrbService
  15. ElisyscdService
  16. EliNoteService
  17. El2rstimService
  18. EliOrderService
  19. ItemInquiry
  20. EliitmiqService
  21. EliShiptoService
  22. El2getfrService
  23. Steps Required to Test ReportWriter in V8.2
  24. Installation of ElliottService, NETcellent’s Web Services for Elliott
  25. ResellerFinder
  26. EliaptrxService
  27. VendorInquiry
  28. EliloginService
  29. ElislsmnService
  30. EliserhsService
  31. EliatpobService
  32. ElievprcService
  33. ElihdtrxService
  34. ElicuswlService
  35. QueryTurnaround
  36. InvoiceInquiry
  37. ElicustmService
  38. EligetcdService
  39. OrderInquiry
  40. EliordiqService
  41. EliecontService
  42. EliautdpService
  43. El2CrCrdService
  44. Log-Timer / ElliottTimer.Ini Support
  45. Alpha Document Number Support (V8.5/V9.0)
  46. ElliottService System.TypeInitializationException
  47. Feature - Printing API to Dynamically Set Number of Copies
  48. The Values and Meanings of Distribution Types - ARDISFIL, APDISFIL, IMDISFIL, BMDISFIL
  49. DD API Changes (V9.0)
  50. PA API (8.5)
  51. Validate License API
  52. AP API
  53. TP API: Temporary Path
  54. Data Structures for Report Desk Defaults and Enforcements
  55. COBOL to VB Interface Programs
  56. IN API: Option to Support Files and Folders Validation
  57. FF API: File Functions
  58. ID API
  59. LK: Links API
  60. FFLNearYou
  61. Report Desk Developing and Debugging
  62. Developing a New Elliott V8.6 Report Desk User Defined Report (UDR)
  63. CustomerInquiry
  64. Elliott API (JSON Web Service)
  65. Animating COBOL Code in Elliott V8.5
  66. Preliminary Programming Changes for Elliott 8.6
  67. CV API
  68. System Lock File Requirements
  69. How to Write Test Codes for C# ESS Projects
  70. Solving the Inability to Debug Elliott on a New Server
  71. Report Desk: Developing Custom Reports
  72. Report Desk Tables
  73. Report Desk Database Delivery Strategy

Feedback and Knowledge Base