Asterisk in Insert

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
Post Reply
djoq
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 54
Joined: Fri, 27 Jan 2012 8:16 am
Location: Londres UK

Good afternoon. I have the following problem in my forms:
I have a block with several multirecord fields. At the Block When_create_record trigger I feed my fields with a value.

He does the insert perfectly in all fields of the block, but only in a field it does not show the value, but an asterisk ***. I'vê checked the field properties, it's the type I'm inserting, it's Base-Item Data, it's Ensert Allowed, it's not enabled Query Only and other ONLY property, there is no WHERE Clause in the block. The properties of the block também are OK.

I tried to insert by Lov, inserts all the fields, but this said whose is with asterisk.

Any help thank you!
tora34
Rank: Analista Pleno
Rank: Analista Pleno
Posts: 108
Joined: Wed, 12 Nov 2008 6:01 pm
Location: Campo Mourão PR
Renato Pasquini
Oracle Developer

Good afternoon,
What type of field in forms and the type of data in the column that represents this field?
djoq
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 54
Joined: Fri, 27 Jan 2012 8:16 am
Location: Londres UK

Hello. It's a Number Type Item.
tora34
Rank: Analista Pleno
Rank: Analista Pleno
Posts: 108
Joined: Wed, 12 Nov 2008 6:01 pm
Location: Campo Mourão PR
Renato Pasquini
Oracle Developer

Good afternoon,
Check the amount of decimal places in the table column
djoq
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 54
Joined: Fri, 27 Jan 2012 8:16 am
Location: Londres UK

Hello. Dude, it's the same, I still can not find out what it is ... = /
Thanks for the aid.
fnoriko
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 9
Joined: Mon, 26 Sep 2011 11:17 am
Location: SP

Have you seen if the property of the "Conceal Data" field is like "No"?
djoq
Rank: Programador Sênior
Rank: Programador Sênior
Posts: 54
Joined: Fri, 27 Jan 2012 8:16 am
Location: Londres UK

Hello everyone, I forgot to answer, Fnoriko era this, 'Conceal Data' was like yes.
Thanks for the Ajuada!
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 10 guests