Restrict number of customer from database

Question

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

customer limit sql vb6 visual-basic-6

2

Contributors

4

Replies

6

Views

5 Years

Discussion Span

5 Years Ago

Last Post by Sturdy

This Question has been Answered

1

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

Votes + Comments

Sturdy: Worked Perfectly

customer limit sql vb6 visual-basic-6

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.