Create field only in Dataset with default value

Question

Create field only in Dataset with default value

Asked 5 years, 3 months ago

Viewed 186 times

1

How I create a field in the ClientDataSet that is not in the database and I leave it with a default value?

I need a field like FLAG_EXEMPLO standard’S' only that I cannot create the same in the bank. It needs to be only in the DataSet.

I’ve tried to use Calculate and InternalCalc with AutoGenerateValue and Default Expression, but nothing seems to work. I don’t know if maybe I didn’t do it the right way.

You can post your code to get an idea?

– Edward Ramos

2019/08/19 at 16:24
Creates the field in Clientdataset as ftString, size 1, just after giving a Createdataset, assigns the default value to the field as’S' and no longer needs to change.

– Jefferson Rudolf

2019/08/21 at 18:26

2 answers

Browser other questions tagged delphi delphi-7 embarcadero

You are not signed in. Login or sign up in order to post.

by Ricardo Alves Carvalho • **484** points · Answer 1 · 2019-08-20T14:32:33+00:00

0

You can do in SQL itself:

SELECT 'S' AS FLAG_EXEMPLO, CAMPO1, CAMPO2 FROM TABELA;

Then go to the dataset to mark the field as editable, or it marks it as Readonly with that sql. Then trying to change the value in the code will give error :)

– Tiago Rodrigues

2019/08/21 at 11:06

by Uberdam Cavaletti • 1 point · Answer 2 · 2020-06-02T03:10:08+00:00

You can create fields on ClientDataset in Runtime, then you go to the properties of that field and inform that this field does not go to the bank, that is, when the ClientDataset generates the commands of insert and update, this field is not generated in SQL.