I have a table with 4 keys. I'm trying to create a record in this table from a stored procedure. For example,

Record='

NewRecId=Val_1 : '*' : Val_2 : '*' : Val_3 : '*' : Val_4

Write Record On TableVar,NewRecId Else

• *error msg

End

The 'Record' is being written to the table, and I can see 'NewRecId' in the system editor, however, when I try to open it, I get the message, 'Row could not be found in table.

What's the trick to programmatically creating new records that use multi-part keys?

You're getting this error in the system editor? What is the exact key? Can you read it back from code? Try reading a SYSREPOS record or a SYSREPOSEVENTS record, though it shouldn't matter. In the system editor, there is no such thing as a multi-part key. It's a logical convention used mostly in windows.

[email protected]

Sprezzatura Group

Greg,

Some keys (whether or not they are multi-part) cannot be read from the System Editor. Examples would be keys with lower case characters and trailing or preceding spaces (I believe). Otherwise it should read just fine.

Are you certain that you have the correct Table being selected? Sometimes I double-click on a table to get a list of keys but then I accidentally change the Table reference (without refreshing the key list) and I get the message you just got.

[email protected]

SRP Computer Solutions

For what its worth. I routinely open multi-key records from the system editor with no problems.

When creating the key, I was ( unknowingly ) adding a trailing space to the key. Once I got rid of the space, everything worked fine.

Thanks to all who responded.

Greg

View this thread on the forum...