Hi, If "virtualcolumn" is not a column in the database, but created in ClientDataSet, create it as a InternalCalc field. InternalCalc fields can be used as a normal field in runtime, but are not updated with the database.
Hope this helps, Vishak -------------------------------------------------------------------------------- ----- Original Message ----- From: Ridwan Haris To: [email protected] Sent: Thursday, June 22, 2006 12:44 PM Subject: [delphi-en] client data set, prevent the field from updating onto the db.. How to prevent one of the field in clientdataset from updating onto the db? I set the ProviderFlags( pfInUpdate,pfInWhere etc) for that field('myvirtualcolumn') all to false and my DataSetProvider update mode i set to upWhereChanged or upWhereKey but it seems doesnt solve my problem it keeps returning error 'Invalid column name "myvirtualcolumn'...'.. Any idea how to solve this problem? Thanks. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Great things are happening at Yahoo! Groups. See the new email design. http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/i7folB/TM --------------------------------------------------------------------~-> ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
