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!

fun with ADO and SQL

Status
Not open for further replies.
BKtechie

BKtechie

MIS
Mar 27, 2002
132
US
hello all-
I have written a SQL statement that computes averages of survey scores and works perfectly in Access. To my dismay, when I attempt to open an ADO recordset in Visual Basic 6.0 with the exact same SQL statement, it produces different results on the calculations, by multiples of 1.75. I'm using the DBase 5.0 ODBC driver to open the recordset. Any thoughts?
 
Sort by date Sort by votes
OK, I figured out that the dBase 5 driver doesn't pack the file after deleted records. Anyone know of a way to pass dBase commands from a VB App? It would be helpful in the automation of this process and further application development.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

xanblax
  • Locked
  • Question
How to send a Message to COleControl with m_hWnd = NULL?
Replies
0
Views
419
xanblax
xanblax
MaxDD
  • Locked
  • Question
100$ for help with ActiveX
Replies
0
Views
431
MaxDD
MaxDD
AsapComputerServices
  • Locked
  • Question
Gmail Active X Error with Internet Explorer
Replies
0
Views
396
AsapComputerServices
AsapComputerServices
wau25
  • Locked
  • Question
Create ActiveX control with .net 4.0
Replies
0
Views
388
wau25
wau25
suddenzero
  • Locked
  • Question
Help with ActiveXObject Microsoft.XMLHTTP
Replies
3
Views
846
suddenzero
suddenzero

Part and Inventory Search

Sponsor

Back
Top