none
Forum for ODBC questions. RRS feed

  • Question

  • My query returns multiple rows based on a single column. Typically 3-9 rows, but 0 rows is also possible. The ECM script in which the query is embedded expects only a single row in the result set, so I need a way get the result set as a single comma list rather than multiple rows, otherwise I miss all but the first value.

    The interface is ODBC, so I need a forum where I can ask about such a list aggregate function in ODBC syntax.

    Thank you,


    Jon Jacobs, There are 10 kinds of people: those who understand binary and those who don't

    Thursday, July 30, 2020 10:14 PM

Answers

  • Ok, gotcha I used to do a lot with VBA / VB6 back in the day. You could try asking here.

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=isvvba

    also note SQL server is odbc compliant so the transact sql forum could also apply. In both cases I'd recommend asking specifically about the sql required to return the desired result. If you make mention of oracle or ECM they'll likely toss it to off topic

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.



    Thursday, July 30, 2020 11:27 PM
    Moderator

All replies

  • If it were SQL server then I'd try asking here.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=transactsql

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    Thursday, July 30, 2020 10:24 PM
    Moderator
  • Since I am stuck with ODBC, I wouldn't be able to use transact sql specific functions. Actually I am querying an Oracle database, but the ODBC interface would not know about the Oracle LISTACC function. So I have to stick with strictly ODBC compatible functions.

    Jon Jacobs, There are 10 kinds of people: those who understand binary and those who don't

    Thursday, July 30, 2020 10:35 PM
  • There isn't an "ODBC" specific forum here on MSDN. You didn't say if this were application development? If so you could try them over here.

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?category=vslanguages

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/home?category=dataplatformdev

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.


    Thursday, July 30, 2020 10:40 PM
    Moderator
  • Thank you.

    >There isn't an "ODBC" specific forum here on MSDN.

    I suspected as much. Would you know where I could find one? My Google search didn't turn up one.

    >application development

    Well, sort of. The ECM workflow interface uses BASIC, pre-VB. I forget what it is called. Like the BASIC one can use in EXCEL, etc. I am developing the SQL my colleague can use in the workflow step. Strictly ODBC.


    Jon Jacobs, There are 10 kinds of people: those who understand binary and those who don't

    Thursday, July 30, 2020 10:49 PM
  • There's the small basic forum here.

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=smallbasic

    but I've no idea whether its a fit since I know nothing of your basic ecm workflow 

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.


    Thursday, July 30, 2020 10:55 PM
    Moderator
  • Instead of Pre-VB I meant Pre-.net. It's VBA. The ECM is Onbase. Anyway I was hoping someone could point me to a place I could post my ODBC questions. Thank you for trying.

    Jon Jacobs, There are 10 kinds of people: those who understand binary and those who don't

    Thursday, July 30, 2020 11:07 PM
  • Ok, gotcha I used to do a lot with VBA / VB6 back in the day. You could try asking here.

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=isvvba

    also note SQL server is odbc compliant so the transact sql forum could also apply. In both cases I'd recommend asking specifically about the sql required to return the desired result. If you make mention of oracle or ECM they'll likely toss it to off topic

     

     



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.



    Thursday, July 30, 2020 11:27 PM
    Moderator
  • >If you make mention of oracle or ECM they'll likely toss it to off topic

    Good point. I appreciate it.

    >also note SQL server is odbc compliant so the transact sql forum could also apply

    Interesting. I never would have thought it.

    Thanks,


    Jon Jacobs, There are 10 kinds of people: those who understand binary and those who don't

    Thursday, July 30, 2020 11:59 PM
  • Hello,

    in addition, if you only have questions about SQL commands, here is a tutorial:

    https://www.w3schools.com/sql/default.asp

    and you could ask questions here:

    https://w3schools.invisionzone.com/forum/32-sql/

    Regards, Guido


    Friday, July 31, 2020 5:56 AM
    Moderator