Subject: | |
From: | |
Reply To: | |
Date: | Tue, 10 Jun 1997 18:20:56 GMT |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Hello ALL!
We are looking for a solution to the following IMAGE/SQL problem:
We want to write a EXCEL Basic script that should update an Image/SQL
database. Unfortunately the UPDATE statement in the EXCEL-Script returns an
error 2042.
When we do the same update with ISQL the following error occurs:
isql=> update dbb.cfg set anschluss = 'N' where ADR='VW';
IMAGE/SQL error 156; TurboIMAGE error -242; TurboIMAGE intrinsic 420, &
Auxiliary error 6554488. (DBERR 13552)
Number of rows processed is 0
isql=>
The same error occurs also when doing only a SELECT on the dataset. SELECT
with open mode 5 is ok.
The dataset CFG is a manual master with ADR as key.
The user is defined with open mode 1.
The intrinsic 420 is DBXBEGIN, the error -242 could not be found in the manuals.
Our MPE Release is C.50.00, ALLBASE/SQL version installed is A.G1.13,
IMAGE/SQL version is B.G1.05.
My questions are:
1. Do anybody now what is wrong?
2. Is there anybody who did a successful update on an IMAGE/SQL database
within an Excel-Skript?
Thank you in advance for your help.
Regards
Herbert
|
|
|