Hello,
it`s me again.
I want to put the data from a dynamic browse into an Excel-Sheet.
I work under Progress 91.d
My code (the query was opened and prepared before...):
DEFINE VARIABLE temp AS HANDLE NO-UNDO.
CREATE "Excel.Application" chExcelApplication.
chExcelApplication:Visible = FALSE.
chWorkbook = chExcelApplication:Workbooks:Add().
chWorkSheet = chExcelApplication:Sheets:Item(1).
myqry:GET-FIRST().
REPEAT WITH FRAME fmain:
IF (myqry:QUERY-OFF-END) THEN LEAVE.
temp = mybrowse:BUFFER-FIELD("Field - Name").
chWorkSheet:Range("A" + cColumn):Value = string(temp:BUFFER-VALUE()) NO-ERROR.
myqry:GET-NEXT.
end.
But it doesn`t work.
I have allready filled an Excel-Sheet with a dynamic browse, but I filled it with
the whole table and went trough all fields in a loop:
temp = mybuffer:BUFFER-FIELD(_field._field-name).
With this statement it worked.
But when I need only a few fields of the table I do this:
temp = mybrowse:BUFFER-FIELD("Field - Name").
And this doesn`t work.
I get the error:
"No temp data available (91)."
and:
"Buffer-field is a no queryable attribute for browse-widget."
Why it works with _field._field-name
but not with Field - Name?
Greets
Storzum
it`s me again.
I want to put the data from a dynamic browse into an Excel-Sheet.
I work under Progress 91.d
My code (the query was opened and prepared before...):
DEFINE VARIABLE temp AS HANDLE NO-UNDO.
CREATE "Excel.Application" chExcelApplication.
chExcelApplication:Visible = FALSE.
chWorkbook = chExcelApplication:Workbooks:Add().
chWorkSheet = chExcelApplication:Sheets:Item(1).
myqry:GET-FIRST().
REPEAT WITH FRAME fmain:
IF (myqry:QUERY-OFF-END) THEN LEAVE.
temp = mybrowse:BUFFER-FIELD("Field - Name").
chWorkSheet:Range("A" + cColumn):Value = string(temp:BUFFER-VALUE()) NO-ERROR.
myqry:GET-NEXT.
end.
But it doesn`t work.
I have allready filled an Excel-Sheet with a dynamic browse, but I filled it with
the whole table and went trough all fields in a loop:
temp = mybuffer:BUFFER-FIELD(_field._field-name).
With this statement it worked.
But when I need only a few fields of the table I do this:
temp = mybrowse:BUFFER-FIELD("Field - Name").
And this doesn`t work.
I get the error:
"No temp data available (91)."
and:
"Buffer-field is a no queryable attribute for browse-widget."
Why it works with _field._field-name
but not with Field - Name?
Greets
Storzum