Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. daYorkie

    How many UNIONs can i use in a single query?

    thanks kray - I will run each segment of query and put output of each into a new temp table and select everything from that once done. Pain but'll do the job and avoid the unions.
  2. daYorkie

    How many UNIONs can i use in a single query?

    Hi all, I have a rather long query selecting items out of various unconnected areas of the DB. I have a working query including 20 UNIONs but when I add the 21st I am presented with a syntax error DB Errorcode=-201 (standard general syntax code) each statement in isolation runs fine. Have i...
  3. daYorkie

    Problem with Inline View / TABLE(MULTISET....

    Hi, I have a query with two inline views which is returning the error: Error: Cannot obtain or set serial value. (State:S1000, Native Code: FFFFFD8E) Statement is being run from WinSql client using IBM Informix ODBC driver. SQL: select ACCT_ID, TOT_DEP, LIMIT_VALUE from TABLE(MULTISET...
  4. daYorkie

    Inline View Equivalent in Informix

    Yep you're absolutely right - I'm making it unnecessarily complicated :-) SELECT A.ACCT_ID, A.BALANCE, A.SUM_AP, SUM(J.AMOUNT) AS SUMBALANCE FROM TACCT A, TJRNL J WHERE A.ACCT_ID=J.ACCT_ID AND J.CR_DATE=CURRENT GROUP BY A.ACCT_ID, A.BALANCE, A.SUM_AP For some reason the simple solution didn't...
  5. daYorkie

    Inline View Equivalent in Informix

    Hi, Thanks for the reply. Removing the AS keyword still returns the same error, however I think I've cracked it - not seen syntax like this before! SELECT A.ACCT_ID, A.BALANCE, A.SUM_AP, NEWPAY.SUMBALANCE FROM TACCT A, TABLE( MULTISET (SELECT ACCT_ID, SUM(AMOUNT) AS SUMBALANCE FROM TJRNL WHERE...
  6. daYorkie

    Inline View Equivalent in Informix

    I'm new to Informix and I'm unable to get a working inline view as per OracleSql. I'm executing the following statement: SELECT A.ACCT_ID, A.BALANCE, A.SUM_AP, NEWPAY.SUMBALANCE FROM TACCT A, (SELECT ACCT_ID, SUM(AMOUNT) AS SUMBALANCE FROM TJRNL WHERE CR_DATE=CURRENT GROUP BY ACCT_ID) AS...
  7. daYorkie

    Start Access when starts PC

    Just add the shortcut to the access file to your startup menu. [pipe]

Part and Inventory Search

Back
Top