Is this even possible?
var con = ADBC.newConnection("reportCard"
var myRecordSet = ADBC.Recordset;
myRecordSet = con.Execute("SELECT * from sheet1 group by StudentNumber"
While !(myRecordSet.EOF)
{
this.getField("student_name".value = myRecordSet("StudentName".value
this.print
myRecordSet.moveNext()
}
my error message is con.execute is not a function
var con = ADBC.newConnection("reportCard"
var myRecordSet = ADBC.Recordset;
myRecordSet = con.Execute("SELECT * from sheet1 group by StudentNumber"
While !(myRecordSet.EOF)
{
this.getField("student_name".value = myRecordSet("StudentName".value
this.print
myRecordSet.moveNext()
}
my error message is con.execute is not a function