I', plan to move from the VFP database to MSSQL server. But i have few question before i move to MSSQL server.
In VFP i used to write my single file maintainance program in a form with a pageframe with 2 pages. In page 1 contain a grid which is use to display the entire table's record. In here user can scroll the grid to locate certain record and edit it on second page.
Q1. If i move to SQL server. do i need to issuse the SELECT * from tableA to select all the record from the tableA into a cursor and put it in the grid ?
Q2. So far i have learn that VFP only tranfer the Index from server to client. If i select all the record from the SQL server will it transfer entire table's record to the client ? Will it become very slow?
Q3. Do anyone have any comment this single file maintenance program ? Which Page1 : Have a grid contain all the records from the table. Page2 is use to edit the selected record from Page1.
Q4. Where can i get the article or sample on how to use MSDE with VFP ?
In VFP i used to write my single file maintainance program in a form with a pageframe with 2 pages. In page 1 contain a grid which is use to display the entire table's record. In here user can scroll the grid to locate certain record and edit it on second page.
Q1. If i move to SQL server. do i need to issuse the SELECT * from tableA to select all the record from the tableA into a cursor and put it in the grid ?
Q2. So far i have learn that VFP only tranfer the Index from server to client. If i select all the record from the SQL server will it transfer entire table's record to the client ? Will it become very slow?
Q3. Do anyone have any comment this single file maintenance program ? Which Page1 : Have a grid contain all the records from the table. Page2 is use to edit the selected record from Page1.
Q4. Where can i get the article or sample on how to use MSDE with VFP ?