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 IamaSherpa 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. EasyAim

    "BTRCALL" or "XQLCompile()"

    VB 6.0 The BTRCALL requires a lot more coding overhead but you're right - it is fast and stable.
  2. EasyAim

    "BTRCALL" or "XQLCompile()"

    I'm used to using the API calls such as XQLCompile(), XQLFetch(), etc... in my VB6 applications. However, I'm working for a new client who insists on using the BTRCALL() command for everything. QUESTIONS: * What is the underlying difference between the two sets of API commands? [i.e...
  3. EasyAim

    Return a distinct amount only if duplicate

    Thanks Terry, this worked great. You didn't even have any typos in your SQL statement. NEW PROBLEM: My main statement got so convoluted I'm writing the intermediate results to a temp table. How do I write ALL of the unique AgentID's into the temp table, but writing "0" (zero)...
  4. EasyAim

    Return a distinct amount only if duplicate

    We have a table of payments associated with an "agent". tblPayment: AgentID PaymentID Amount AdjustmentID 30101 10001 $40.00 701 30101 10002 $50.00 902 30101 10003 $50.00 902 30101 10004 $50.00 902 30101 10005...

Part and Inventory Search

Back
Top