> Regardless what you're using to fetch the data, try:

> "SELECT Top 100 * FROM Tablename"

> > I want to build a customer relation database software that I can use
over
> > the internet, using Internet Explorer. Each dataset occupies about a
page
> > worth of information per customer. I want to be able to quickly browse
> > between customers - more quickly then reloading the page for each
> customer.

> > (How) Can this be done using vb.net?

> > Building an ActiveX that fetches 100 customers per connection?

> > Other ideas?

> > Thanx for any help!

> > /M

> I want to build a customer relation database software that I can use over
> the internet, using Internet Explorer. Each dataset occupies about a page
> worth of information per customer. I want to be able to quickly browse
> between customers - more quickly then reloading the page for each
customer.

> (How) Can this be done using vb.net?

> Building an ActiveX that fetches 100 customers per connection?

> Other ideas?

> Thanx for any help!

> /M

> It "Top" really SQL standard? Isn't it just an Access feature?

> > It "Top" really SQL standard? Isn't it just an Access feature?

> You are right, TOP is an MS construction. (Also available in MS SQL
> Server.)

> There are no SQL standard function like TOP. But many other DBMS
> vendors have their own versions, like RDB's LIMIT.

> If you want to verify you SQL statements standard conformance, check
> out the SQL Validator: http://developer.mimer.com/validator

> It has support for SQL-92, SQL-99 and even SQL-2003 (current draft).
> Saves lots of time when developing portable applications.

> I worry that the term "SQL-2003" might cause confusion with
> Microsoft's Yukon. Is there still time to agree to call the ANSI/ISO
> product "SQL:2003" instead, which reflects the current draft's
> spelling better?

> Peter Gulutzan
> Author of "SQL Standards" article at http://dbazine.com/gulutzan3.html