Scanning a database table without a doSelect.

[sigtb02]

Im am trying to scan the contacts table and simply print the contact.name. This is my script. But the getSize function does not seem to work ? Any suggestions.

var contactList = new SCFile("contacts");
var i = 1;
var LastRecord = contactList.getSize();
print ("Contact name :\n" + contactList.contact_name);
print ("Record number :\n" + i + " of " + LastRecord);
for (var i=0; LastRecord > i; i++)
{
print ("Contact name :\n" + contactList.contact_name);
print ("Record number :\n" + i + " of " + LastRecord);
}
return i;

[tommy]

I don't understand why you use getSize? This returns the size of an array.

Your code should look like this instead

var contactsFile = new SCFile("contacts");
var rc = contactsFile.doSelect("true");
 
while (RC == RC_SUCCESS)
{
print ("Contact name :\n" + contactsFile.contact_name);
rc = contactsFile.getNext();
}

If you just want the last then use getLast() and drop the while loop.

[sigtb02]

Here are the results, I get the following error in french.

Le panneau de traitement eval.expressions de RAD us.link a rencontré une erreur à la ligne 3 (us.link,eval.expressions)
Impossible d'évaluer l'expression (us.link,eval.expressions)
Impossible d'évaluer l'expression (us.link,eval.expressions)
Script <UNKNOWN> ligne 4 : ERROR ReferenceError: RC is not defined au car 1

Impossible to evaluate expression at line 4 RC is not defined. Is this not suppose to be a system variable ?

[tommy]

No rc is not a system variable. It has to be defined.

Sorry I wrote above quickly. Javascript is case sensitive. Thats why you get the error. I the while statement change RC to rc.

[sigtb02]

I get it, its case sensitivve right ?

[tommy]

Yes.

[sigtb02]

I am trying to reinitialize dgsig.temp.intervention.prevu and
dgsig.temp.inter.retour.arriere fields inside of $L.file

and reinitialize global variable $lo_temps_prevu and $lo_temps_retour.

This is my script. That does not work.

var avant = system.vars.$L_file;
var prevu = system.vars.$lo_temps_prevu="";
var retour = system.vars.$lo_temps_retour="";
var avant.dgsig_temp_intervention_prevu="";
var avant.dgsig_temp_inter_retour_arriere="";

Any suggestions ?