I have an application written in Delphi 5 that makes use of clientdataset components against a SQL server 7.0 database. I have a query 'Query1' that specifies the data selection (i.e. 'SELECT Field1, Field2, Field3 FROM TableName ORDER BY Field1, Field2') which is then linked to a DatasetProvider and then a Clientdataset component. I am able to add entries to the clientdataset and then pass these back to the database table using the syntax 'ClientDataSet1.ApplyUpdates(-1)' which works successfully. I am now running against a different database structure where the tables may be owned be different users. My query SQL syntax has now become 'SELECT Field1, Field2, Field3 FROM [table-owner].TableName ORDER BY Field1, Field2'. Having added data entries to the linked clientdataset (again through a DataSetProvider component), on attempting to issue the command 'ClientDataSet1.ApplyUpdates(-1)' I am getting the error message 'Unknown table name : [table-owner]'. The system is attempting to apply the updates againt [table-owner] rather than the table as required. Can anyone suggest what modifications I need to make to achive my aim or suggest a work-around ?
Thanks in advance
Steve
Thanks in advance
Steve