Restrict number of customer from database

Question

Sturdy 11

6 Years Ago

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

customer limit sql vb6 visual-basic-6

2 Contributors
4 Replies
6 Views
6 Years Discussion Span
Latest Post 6 Years Ago by Sturdy

Jx_Man 987

6 Years Ago

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

Sturdy commented: Worked Perfectly +1

Jx_Man 987 · Answer 1 · 2012-03-31T15:08:46+00:00

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

Sturdy 11 · Answer 2 · 2012-03-31T15:18:48+00:00

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.

Sturdy 11 · Answer 3 · 2012-03-31T16:00:02+00:00

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