Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link Par2: MS SQL Computed Fields 2003-03-10 -- Vernon Jay Godwin > I have three calculated fields on a MSSQL backend.
> In Clarion DCT they are all read only, my problem is that when I try to
> insert a new record I get an 'Error 'ColumnName' cannot be modified
because
> it is a computed column.(37000).'
> I removed the fields from the browse,remove the read only attrib but same
> error.
> Im using C5.5 and the update is using EIP.
In your dictionary you need all the fields declared that you expect to have
in the browse. However, you need to make one additional change to the
dictionary.
On those fields that are computed by the backend, you need to add the
|READONLY switch.
You do this by going to the field in question and changing the "external
name" value. If there is no external value you will need to make it match
the column's name. For example, lets say the column is CalcTotal. The
external name should be CalcTotal|READONLY. This should resolve your
problem.
Today is May 12, 2024, 1:56 pm This article has been viewed 35128 times.
|
|