Mike Oakes
10/28/2005 3:41:00 AM
--
Kind Regards
Michael Oakes
> 1- What are the use of maps ?
These are for writing common code for different parts of the system.
For example, the address map is used for updating the address from different
tables. So if you update the zipcode on a customer, vendor, contact person,
you can call a map function code and it ''knows'' which address to update.
For example custTable.addressMap::formatAddress() or
vendTable.addressMap::formatAddress(); The business logic is in the same
place!
> 2- Where are table relations maintained in? master or detail
not sure what u mean, table relations are used for data integrity, same as
the extended data type relations but more complex
> 3 - What are the different relations types? and how do they differ ?
normal, fixed relation etc? this is used for adding conditions to relations.
take a look at the GL posting journals. Note you enter an account type (bank,
customer, vendor etc) and then in an account field it automatically knows
which table to look up.
> 4-What is meant by str left and str right ?
string alignment, useful in case you want records saying 1,2,3,4,5,6,7 OR
1,11,2,3,5 (note how the 11 comes before the 2)
> 5- What does function strfmt do ?
used for casting data types into strings. you cannot say
info(systemdateGet()) as the systemdateget() function returns date. so you
can say info(strfmt("%1",systemDateGet())); you can also embedd text in here
info(strfmt("This is a date %1",systemDateGet()));
> 6- How to set date formats?
you can say str2date("1/1/2003",213) or something like that where
1=day,2=month,3 = year
> 7- What is the difference between exist and inner join ?
exist join doesn''t fetch the joined record, inner join does
> 8-What is the use of forecliterals key word?
Oracle tuning
> 9- What is the use of forecPlaceHolder key word?
Oracle tuning
Forceplaceholder and literals are usesd for statistics/performance tuning
for short repeated querier
"G" wrote:
> 1- What are the use of maps ?
> 2- Where are table relations maintained in? master or detail
> 3 - What are the different relations types? and how do they differ ?
> 4-What is meant by str left and str right ?
> 5- What does function strfmt do ?
> 6- How to set date formats?
> 7- What is the difference between exist and inner join ?
> 8-What is the use of forecliterals key word?
> 9- What is the use of forecPlaceHolder key word?
> ---
> Thank You and Best Regards