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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"BTRCALL" or "XQLCompile()"
VB 6.0 The BTRCALL requires a lot more coding overhead but you're right - it is fast and stable.- EasyAim
- Post #3
- Forum: Pervasive: Btrieve
-
"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...- EasyAim
- Thread
- Replies: 4
- Forum: Pervasive: Btrieve
-
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)...- EasyAim
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- EasyAim
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
