Is it a calculated field? Ado tries to be very smart and will tend to set the ReadOnly property at run time if it can't see a way of editing the field. We use ClientDatasets as the front end for our ADOStoredProcs (using providers to link) and we have to create the fields in both the ClientDataset and ADOStoredProc components and set ReadOnly to false for any calculated fields before we end up with a true editable field in the ClientDataset.
David. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edward Koryagin Sent: Monday, 9 October 2006 1:42 p.m. To: NZ Borland Developers Group - Delphi List Subject: [DUG] ADO magic? Hi all I've created form with the number of TDBEdit components on it. When I connect to Oracle everything works as expected. When I connect to MSSQL all controls except one allow editing but this 'magic' field doesn't... The data type is the same as some others. Readonly is false. DataSet is AutoEdit. I've tried copy and paste control which works fine and change datafield to my magic column - same result. Any ideas? Edward. Send instant messages to your online friends http://au.messenger.yahoo.com _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
