Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>I've been through a long list of postings about this issue and still don't understand all I know about how remote views work.
>>
>>I am using Visual Foxpro 6.0 with a SQL Server back end. The tables on the server all have key fields, the remote views all have the SQL update properties set, I have a good connection in the database, but I can't get the SQL tables to reflect new records or changes.
>>
>>Can someone walk me through how to set up a remote view, and then make sure it talks to the database?
>>
>>TIA!
>>Tom.
>
>1. Are you using the View designer?
>
YES. I created a database, added a connection, and created the views. I then built the form and added a dataenvironment that included the views. I added the controls to the form and selected their control sources from the combobox in the properties window. I also set relationships between the views in the load event of the form. All seems to work well with moving around in the views
and displaying the data. I have an 'Add' button that does INSERT INTO the approriate views when I need to add records, and a 'Save' button that does the tableupdate() for each view in succession. If I browse the views in the dataenvironment, all my modifications appear as I would expect. They just don't go out to SQL Server. Of course, when I close down the form designer and come back in, the views are reflective of the SQL Server data tables and have lost my changes.
>2. Have you turned on the 'send updates'.
>
YES.
>3. Have you done a tableupdate() to send the updates, then a requery() to see if they are on the back end?
>
YES to the tableupdate() and NO to the Requery(). I have gone out in SQL Executive and looked at the tables though.
>4. Are you loggin on to the SQL server with an account that has writes to do the update?
>
YES I have all necessary rights to the SQL database. I am using ODBC with a machine DSN which connects properly.
>BOb
There has to be something I'm missing. I just can't see it.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement