Please review and CORRECT help files, especially section related to SC macros. There is a lot of old and outdated information. Here is an example. some of the embed points do not exist anymore and many are missing. The table also does not show any properties for EditableGrid.
Arthur
Hello,
I will discuss this issue with our team.
regards,
Bernhard Bernsmann
this is a fragment of description of one of the most important SC macros, and it is all screwed up.
You also need to translate your terrible English into REAL ENGLISH.
I’m trying to read this description and I cannot figure out what the author it trying to say.
sc_lookup(dataset, “select customer_id, customer_name, credit_limit from customers” );
To have access to the first line (Dataset), use :
{customer_id} = {dataset[0][0]};
{customer_name} = {dataset[0][1]};
{credit_limit } = {dataset[0][2]};
To have access to the second line (Dataset), use:
{customer_id} = {dataset[1][0]};
{customer_name} = {dataset[1][1]};
{credit_limit} = {dataset[1][2]};
If occurs error in the execution of the SQL command, the variable attributed to the dataset will return as “false” and the error message will be available in the “dataset_erro” variable. It is also important to verify the select returned data, to prevent access to inexistent variables, once the output array only will be created if the select command returns data.
THE LAST SENTENCE COMPLETELY MAKES NO SENSE !
THIS IS A CODE SNIPPET FROM SC which is completely different from HELP and it also contains an “isset” directive which I cannot find anywhere in HELP !
/**
/**
* Selecting a field from another table
*/
// Check for record
$check_sql = "SELECT state_name, region"
. " FROM States"
. " WHERE state_id = '" . {field_state_id} . "'";
sc_lookup(rs, $check_sql);
if (isset({rs[0][0]})) // Row found
{
{other_field} = {rs[0][0]};
{other_region} = {rs[0][1]};
}
else // No row found
{
{other_field} = '';
{other_region} = '';
}
Where can I find any information on “isset” statement ?
I’m so confused what is valid and what is not. It as all big mess.
Note2: For a big result returned in the dataset we recomend the use of the macro sc_selec instead of this one.
what is sc_selec ?
SO WHAT IS GOING HERE ?
THERE IS OVER 500 million people speaking English natively. Why don’t you hire somebody outside of your country and let the person PROOFREAD all your help materials, SC messages etc. so at least it will be one area less for frustration ???
Arthur