Dear all

Don't be afraid of the long post. Please!

I use the CommandTable-Object in my java-code. The settet command-Text shows different reactions.

!!! The text in the brackets is crucial!!! => see below: alias (2) + alias (x) + alias (text)

CommandTable table = new CommandTable();
...

If possible, I want to use case 1 and case 2

----------
1)
String columns = "ANZAHLGLEISE_________001004FN6 AS \"alias (2)\"";
table.setCommandText("SELECT " + columns + " FROM " + tableName);
=>

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: failed to bind columns.---- Error code:-2147467259 Error code name:failed
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:2285)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:2305)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:737)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)
    at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)
    at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)
    at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)
    at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)
    at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)
    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)
    at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186)
    at com.crystaldecisions.sdk.occa.report.application.an.a(SourceFile:108)
    at com.crystaldecisions.sdk.occa.report.application.b0.if(SourceFile:148)
    at com.crystaldecisions.sdk.occa.report.application.b0.b(SourceFile:95)
    at com.crystaldecisions.sdk.occa.report.application.bb.int(SourceFile:96)
    at com.crystaldecisions.proxy.remoteagent.UndoUnitBase.performDo(SourceFile:151)
    at com.crystaldecisions.proxy.remoteagent.UndoUnitBase.a(SourceFile:106)
    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:2159)
    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:543)
    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.addTable(SourceFile:464)

------------------
2) String columns = "ANZAHLGLEISE_________001004FN6 AS \"alias (x)\"";
table.setCommandText("SELECT " + columns + " FROM " + tableName);
=>

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: For input string: "x"---- Error code:-2147467259 Error code name:failed
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:741)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)
    at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)
    at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)
    at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)
    at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)
    at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)
    at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)
    at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)
    at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186)
    at com.crystaldecisions.sdk.occa.report.application.an.a(SourceFile:108)
    at com.crystaldecisions.sdk.occa.report.application.b0.if(SourceFile:148)
    at com.crystaldecisions.sdk.occa.report.application.b0.b(SourceFile:95)
    at com.crystaldecisions.sdk.occa.report.application.bb.int(SourceFile:96)
    at com.crystaldecisions.proxy.remoteagent.UndoUnitBase.performDo(SourceFile:151)
    at com.crystaldecisions.proxy.remoteagent.UndoUnitBase.a(SourceFile:106)
    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:2159)
    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.a(SourceFile:543)
    at com.crystaldecisions.sdk.occa.report.application.DatabaseController.addTable(SourceFile:464)


--------
3) String columns = "ANZAHLGLEISE_________001004FN6 AS \"alias (text)\"";
table.setCommandText("SELECT " + columns + " FROM " + tableName);
=> everything OK

best regards

Thomas

Edited by gipsy - 09 Feb 2011 at 8:08pm