Too many key fields were specified...

samemery

Hi,

I am getting an error message that reads "Too many key fields were specified, so Contact could not be retrieved. The number of fields in the primary key is 1." when trying to use a GET using a new key I made in the table.

Does anyone know why my SETCURRENTKEY isn't changing to my new key?

Thanks.

Savatage

GET Finds a record based on values stored in primary key fields. Not a new key!
Are you saying you can't GET your info using the primary key?

You can use Find for that.
example..
item.SETCURRENTKEY("No.");
item.SETRANGE(Blocked,FALSE);
item.SETFILTER("No.",'<100000');
if item.find('-') then //do stuff also available FindFirst, FindLast, Findset depending on what you need.

More details here!
http://msdn.microsoft.com/en-us/library/dd355032.aspx

samemery

you're right! I don't know why I thought I could do that. :oops:

Thank you for your help.