We are converting our Client / Server Application and trying to implement our Custom Data Query Tool that allows our clients to Generate a dataset from a SQL query and display the results in a dynamic datawindow with the SyntaxFromSQL method. This allows our clients alot of flexibility to gather data easily through our application.
Looking to see if anyone has implemented the SyntaxFromSQL in a Cloud Application or has any kind of work around.
The code for our Client/Server Application looks like this:
String ls_sql
string ERRORS, sql_syntax
string presentation_str, dwsyntax_str
String ls_sysidSyntax
Long ll_trows
ls_sql = mle_query.Text
presentation_str = "style(type=grid)"
dwsyntax_str = SQLCA.SyntaxFromSQL(ls_sql, presentation_str, ERRORS)
If Len(ERRORS) > 0 Then
MessageBox("Error", "SyntaxFromSQL caused these errors: " + ERRORS)
Return
End If
dw_data.Create( dwsyntax_str, ERRORS)
IF Len(ERRORS) > 0 THEN
MessageBox("Caution","Create cause these errors: " + ERRORS)
RETURN
END IF
dw_data.SetTransObject(SQLCA)
ll_trows = dw_data.Retrieve()
st_rows.text = String (ll_trows ) + ' Rows Retrieved'
dw_data.Modify("DataWindow.Export.PDF.Method = NativePDF! ")
dw_data.BringToTop = TRUE
Thanks
Jim Beck