Kbase 17550: Actuate Basic Error 1011
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/19/2000 |
|
Actuate Basic Error 1011
DRAFT COPY - Currently under review and edit.
INTRODUCTION:
=============
If customer gets:
Basic Error: 1011
Module: C:\Actuate\Devwdb\afc\db.bas
Line: 144
Database Error
2 The error which occured is database specific.
a reason for this can be that incorrect data type is sent from Actuate
to Progress database - eg. missing quotes around values of a SELECT
statement.
PROCEDURAL APPROACH:
====================
As an example Actuate nested report can be used. Source is stored in
..\ACTUATE\DEVWB\EXAMPLES\NSTDREP
There are two local methods:
Sub Start() - stores custID for a main record (customer)
Function ObtainSelectStatement() - to prepare WhereClause of a
SELECT statement for related record (order)
This example is for Access Database, but can be simply modified to run with Progress sports database (rename objects and fields to use sports database table and field names).
Function ObtainSelectStatement( ) creates a WhereClause in a form of:
WhereClause = order.cust-num = 3
This is correct as cust-num is an integer. In case order.cust-num is a
character field quotes have to be added around the value to get:
WhereClause = order.cust-num = '3'
otherwise you get an error mentioned before.
To get a correct syntax modify ObtainSelectStatement from:
WhereClause = "" & "order.cust-num = " & NestedApp::param
to:
WhereClause = "" & "order.cust-num = " & "'" & NestedApp::param & "'"
To check a generated string MsgBox(WhereClause) can be used.
VZA (07/Jan/98)
Progress Software Technical Support Note # 17550