Hi!
Here is my problem.
I work in Developer Forms6.0
When I make UPDATE for a record, I want to use for it ROWID.
EXAMPLE:
I have one block named bloc1.
I'm using LOV to get the record that I need to change.
After that, I put the rowid for this record into block item named bloc1.item1;
For example,bloc1.item1 contain this value AAAPE9AAOAAJhLJAAC
Until this point everything is OK.
After that my command is :
UPDATE table1 SET col1=value1 WHERE table1.rowid=bloc1.item1;
commit;
My problem is - after this command my changes will appears in two records not in only one!
I know that ROIWD is character.
If I type,for example,
UPDATE table1 SET col1=value1 WHERE table1.rowid='AAAPE9AAOAAJhLJAAC'; it works.
So,I think I need something to get bloc1.item1 in form like this
'AAAPE9AAOAAJhLJAAC' , meaning with apostrophes.
How can I do this?
I've tried with
UPDATE table1 SET col1=value1 WHERE table1.rowid='''||bloc1.item1||''';
but it didn't work.
I tried to use
to_number(table1.rowid)=to_number(bloc1.item1),but it didn't work ,not at all.
So,if somebody can help me,I will thank a lot.
Here is my problem.
I work in Developer Forms6.0
When I make UPDATE for a record, I want to use for it ROWID.
EXAMPLE:
I have one block named bloc1.
I'm using LOV to get the record that I need to change.
After that, I put the rowid for this record into block item named bloc1.item1;
For example,bloc1.item1 contain this value AAAPE9AAOAAJhLJAAC
Until this point everything is OK.
After that my command is :
UPDATE table1 SET col1=value1 WHERE table1.rowid=bloc1.item1;
commit;
My problem is - after this command my changes will appears in two records not in only one!
I know that ROIWD is character.
If I type,for example,
UPDATE table1 SET col1=value1 WHERE table1.rowid='AAAPE9AAOAAJhLJAAC'; it works.
So,I think I need something to get bloc1.item1 in form like this
'AAAPE9AAOAAJhLJAAC' , meaning with apostrophes.
How can I do this?
I've tried with
UPDATE table1 SET col1=value1 WHERE table1.rowid='''||bloc1.item1||''';
but it didn't work.
I tried to use
to_number(table1.rowid)=to_number(bloc1.item1),but it didn't work ,not at all.
So,if somebody can help me,I will thank a lot.