Anyone use Progress Result?
Result is imbedded in our Student Mangement System called Skyward which uses progress database.
I try to use Result to make a query and export it to text file and automate the process.
But in Result, if I view as browse, and then click the Count button, I can see 7000 records, but if I export it by using print to file, I got 7500 records.
It's the same query, but why I got different records, I unwrapped the text file already.
I look through the exported text file and compare with the browse view records in Result, I found in text file there are duplicated records with one field different, the field is having a question mark "?"
This is a couple of record in exported text file,
"002648","603","Edmondson","Eduardo","?", 2016,"False"
"002648","603","Edmondson","Eduardo", 2016,"False"
The following is from browse view of Result, there is only one record about the student:
"002648","603","Edmondson","Eduardo", 2016,"False"
Does anyone know why the same query gets different results?
I would like the browse view result, I don't want the duplicated records.
How can I fix it, so that in my exported file I don't have those records with "?" mark,
Thanks
Result is imbedded in our Student Mangement System called Skyward which uses progress database.
I try to use Result to make a query and export it to text file and automate the process.
But in Result, if I view as browse, and then click the Count button, I can see 7000 records, but if I export it by using print to file, I got 7500 records.
It's the same query, but why I got different records, I unwrapped the text file already.
I look through the exported text file and compare with the browse view records in Result, I found in text file there are duplicated records with one field different, the field is having a question mark "?"
This is a couple of record in exported text file,
"002648","603","Edmondson","Eduardo","?", 2016,"False"
"002648","603","Edmondson","Eduardo", 2016,"False"
The following is from browse view of Result, there is only one record about the student:
"002648","603","Edmondson","Eduardo", 2016,"False"
Does anyone know why the same query gets different results?
I would like the browse view result, I don't want the duplicated records.
How can I fix it, so that in my exported file I don't have those records with "?" mark,
Thanks