hi
Search record is a record that has at least one search key. Sqc is nothing but sqr program but the saving convention is sqc. By using Keys methods and properties we can connect other application in ci.

hi

in the search record need one key field of parent record.

if u want to create sqc u can write programm like sqr but with out program section and can save with .sqc extension.

What is search Record?

Search record is the first record which will be accessed by component buffer. means it facilitates the retrival of required rows that will be used for the compoenet. e.g instead of retriviewing all the rows we can select some particular through the search keys.it willl improve the performance.

Search Record: Based on upon search record keys the component processor retrieves data from database and waits for the user action. We can give the row level security based on upon this search record.

SQCS: SQC'S can be created with naming conventions of.sqc.

This SQCs are used for commonly used procedures instead writing again and again same