0

Hi All,

How i can restrict the numbers of customer from database?
I use adodb with access.
I know how to retrieve customers from database but i don't know how to restrict it to spesific numbers.

Best Regards.
Sturdy

2
Contributors
4
Replies
6
Views
4 Years
Discussion Span
Last Post by Sturdy
Featured Replies
  • 1

    To limit your retrieved data from database you use TOP clause in your sql statement. [You can read in this site](http://en.wikipedia.org/wiki/Select_%28SQL%29#FETCH_FIRST_clause). Select TOP 50 * from Customers Read More

0

Yes, this my query to retrieve data :

Dim rs As New ADODB.Recordset
rs.Open "SELECT * from Customers", Conn,adOpenStatic ,adLockOptimistic 

However, i want to restrict all data to recordset is just only 50 customers.
How i can do this? Please help.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.