Some things to follow:
- Use ODBC, not ADO. Microsoft has said they will no longer support ADO for SQL Server
- Don't work on an entire table. Work on a set of records, for example, customers in a particular city. Previous/Next will work on that set of records.
- Take Al's advice and do some web searches.
>Hi,
>I want to write a program in VFP 9 to maintain the records in the database table in SQL server 2012
>I need to browse and maintain the table record by record, such as which can move next record, previous record, go top, go bottom...etc.
>Is it using ADO recordset or other method like binding navigator in vb.net ?
>
>Please advise.
>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer