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 Mike Lewis 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. nthg2say

    Automatically shut down a form with no records

    before activating form: if {ActiveDocument.Sections["myResultSection"].RowCount ==0) { Alert("Yo...Sorry No Records Found") } else { ActiveDocument.Section["MySecondForm"].Activate() Blah Blah... }
  2. nthg2say

    Importing SQL into Brio Report Builder

    Insert a new query section. From the Command Window, File/Import/SQL
  3. nthg2say

    Append Query - How to union seperate queries

    add ALL the tables you need to the first query from the command menus choose DataModel/DataModel Options/ go to the Joins tab and select 'use the minimum number of topics' If the topic(s) columns needed for the second union query are/is not in the limits and not in the requests it will not be...
  4. nthg2say

    no access to table

    Also look for Unique Rows and/or Row limits in the Query Options/properties
  5. nthg2say

    Union and Intersect

    bqUnion(=1) bqUnionIntersection(=2) bqUnionMinus(=3) bqUnionAll(=4)
  6. nthg2say

    NEWBIE: Need help querying survey results

    are you in Oracle? (in sybase look up the 'case' statement) select sum(decode(QuestionResponse,a,1,0)) Q1a, sum(decode(Question1Response,b,1,0)) Q1b, sum(decode(Question1Response,c,1,0)) Q1c, sum(decode(Question2Response,a,1,0)) Q2a, sum(decode(Question2Response,b,1,0)) Q2c, etc, etc... Then...
  7. nthg2say

    how to insert sql statement in Brio query

    use Brio 6.5 DataModel/ Audit /preProcess SQL

Part and Inventory Search

Back
Top