vandhana

• Nov 8th, 2005

 

write down ur procedure in a notepad and use the naming convention as .sqc.

srinivasulu

• Dec 16th, 2005

 

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.

 

praveen

• Dec 30th, 2005

 

hi

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

nagesh

• Jul 27th, 2006

 

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

neelvizhi

• Oct 3rd, 2006

 

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.

Nataraj

• Nov 8th, 2006

 

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 

RamKumar

• Feb 17th, 2007

 

 Search Record : A Search Record provides a easiest way of navigation in to a page in component.

pradeep

• Nov 19th, 2007

 

this is the example!! of SQC and SQR


write procedure in a note pad and save it ex1.sqc
begin-procedure main
begin-select
emplid
name
from ps_personal_data
end-select
end-procedure

after that select new notpad and save ex2.sqr

#include 'ex1.sqc'
begin-program
do main
end-program

run the ex2.sqr file

rahul_96k

 Profile Answers by rahul_96k Questions by rahul_96k

• Dec 7th, 2007

 

 Search Record are use define the structure of dialog box , is also use to retrive and filter the data.