General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only