Kbase 19537: Variable declarations on Embedded SQL Code.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/18/2000 |
|
Progress Knowledge Base entry # 19537
INTRODUCTION:
=============
This K-base will describe a case when you can get the errors 1605 and/or 1596.
PROCEDURAL APPROACH:
===================
When running sqlcpp on embedded SQL code, you may get the following errors:
- Error in variable declaration section. (1605)
and/or
- Unmatched END DECLARE or error in DECLARE SECTION. (1596)
If on "C" code you declare a char variable like a pointer. Example:
EXEC SQL BEGIN DECLARE SECTION;
char *test;
EXEC SQL END DECLARE SECTION;
Then run the sqlcpp, it will send the above errors. Progress will not recognize this declaration as a "C" unlimited size char format, the declaration of the variable needs to be changed by a "C" array format. Example:
EXEC SQL BEGIN DECLARE SECTION;
char test[10];
EXEC SQL END DECLARE SECTION;
Where [10] is the same as in the Progress format "X(10)" then it will be recognized.
Progress Knowledge Base entry # 19537