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
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
Jump to PostTo 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
Can you show your sql query to retrieve customers from database?
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.
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
Wow...That code worked perfectly.
Thank you sir.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.
You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed. It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post.