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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Accpac to get distinct values from SQL DB

Status
Not open for further replies.
kwagz

kwagz

Programmer
Oct 11, 2004
10
ZA
Hey guys

I would like to get distinct values from a specified field in the SQL database using Accpac. What I'd like is Accpac to return a recordset with distinct values of a specific field.

Your help will be highly appreciated.

kwagz
 
Sort by date Sort by votes
Your best bet is to use regular ADO/ADODB SQL statements. Accpac's .Browse doesn't have any ORDER BY or GROUP BY capability.

Jay Converse
IT Director
Systemlink, Inc.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ExtraLean
  • Question
ACCPAC VisionPoint 10 - Need workstation installer or another way to put on new machines
Replies
0
Views
177
ExtraLean
ExtraLean
hushman
  • Locked
  • Question
Deleting quotes from Sage 300
Replies
2
Views
187
ettienne
ettienne
Hemanth3526
  • Locked
  • Question
80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
Replies
2
Views
345
Hemanth3526
Hemanth3526
vbdbcoder
  • Locked
  • Question
Is there a good way to complete an order line with qty backordered?
Replies
2
Views
172
vbdbcoder
vbdbcoder
jsh8286
  • Locked
  • Question
Default Values in Parameter Not Updating
Replies
1
Views
90
jsh8286
jsh8286

Part and Inventory Search

Sponsor

Back
Top