The export of a document from SCOPELAND is determined on the one hand by a special interface applet, which delivers the data, and on the other hand by a template, which describes the appearance of the document. To generate a report (no matter whether DirectDesk report, Windows report, WebReport etc.) one always goes one of […]

If list boxes are to be layered, i.e. made dependent on each other so that the next list box displays only those entries that match the previous list box, you can proceed as follows:In the selected applet, you must create a relation between the base field of the first list box (starting point of the […]

How do I implement a comma-separated enumeration of data in a template? In this case you want the comma or any other separator text to appear only between the records. For this there is the identifier $[HasNextRow], which can be used within a $[Repeat] range. It only outputs the contained document part if the currently […]

If you want to create a report in SCOPELAND, you can do this under the menu function “New/Page” or with “Open”. Afterwards you can either search for the desired base table for the first query or select it directly from the displayed directory structure. The search function is very helpful, because it not only searches […]

If a macro is executed per run, there is a return value. It positively indicates the successful processing and the number of records. Negative return values provide information about the error. Overview of all return values : enErrCNSaveInfo = -108, // can’t not save information enErrNFieldId = -107, // no field id is give enErrNStepId […]

Map Control makes it easier to work with data that has location information from a spatial reference system. The main task is the data visualization in generated web pages, besides it offers possibilities to analyze and manipulate data. It can also be used for geocoding and embedding maps in documents. In the Direct Desk you […]

If a lot of data is to be written directly from the database to a file, the following error may occur: Error report:ORA-29285: file write errorORA-06512: at “SYS.UTL_FILE”, line 148ORA-06512: at “SYS.UTL_FILE”, line 403ORA-06512: at “SYS.UTL_FILE”, line 1166ORA-06512: at line 5829285. 00000 – “file write error”*Cause: Failed to write to, flush, or close a file.*Action: […]

The Repeat.Page identifier can also be used in Excel, similar to PowerPoint slides. In Excel, the identifier must be added in the top left cell of the worksheet and the end of the identifier must contain the complete contents of the worksheet. In addition, the name of the worksheet must be added as a simple […]

  • 1
  • 2