Filter with part of the primary key

EMHenriques · 2006-09-22

Hello,

I need to rename some items from the table item but only the first 10 positions of the field no.

They give-me the first 10 positions of the old No. and the new 10 positions.
And i have to rename all the items that i found starting with the old 10 positions.
My question is, is there a way of filtering the records with only part of the key??

The only ideia that i have is to read all the records and find those that i want. But i think that will be time consuming :?

Thanks

Eduardo

Luc_VanDyck · 2006-09-22

You can filter on the first X-characters by means of '*':

codFirst10Chars := '1234567890';
recItem.SETFILTER("No.",codFirst10Chars + '*');

EMHenriques · 2006-09-22

Thanks a lot.

I will try it now.

EMHenriques · 2006-09-25

I tried, but didn't work,

The "find", just comes empty.

Artigos.SETFILTER(Artigos."No.", CodAnt + '*');
IF Artigos.FIND('-') THEN REPEAT
..
..
UNTIL Artigos.NEXT = 0;

EMHenriques · 2006-09-25

Sorry, i'm an ass.

My mistake. :oops:

Howdy, Stranger!

Quick Links

Categories

Filter with part of the primary key

Answers