Member Avatar for Sturdy

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
  • 211 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Sturdy
Member Avatar for Jx_Man

Can you show your sql query to retrieve customers from database?

Member Avatar for Sturdy

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.

Member Avatar for Jx_Man

To limit your retrieved data from database you use TOP clause in your sql statement.
You can read in this site.

Select TOP 50 * from Customers
commented: Worked Perfectly +1
Member Avatar for Sturdy

Wow...That code worked perfectly.
Thank you sir.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.