Kbase P43441: Microsoft SQL Server text fields cause Access Violation errors when using field lists and NO-LOCK, d
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/30/2005 |
|
Status: Verified
FACT(s) (Environment):
MS SQL
MS SQL DataServer
SYMPTOM(s):
Microsoft SQL Server text fields cause Access Violation errors when using field lists and NO-LOCK.
Progress client generates a GPF
Code that will reproduce the problem, if city is a text field in MS SQL Server.
FOR EACH customer FIELDS(city) NO-LOCK:
DISPLAY city FORMAT "x(77)".
END.
The text field is in field list
Use no-lock
CAUSE:
Bug# 20030811-001
CAUSE:
When Progress retrieves data from the database it uses "binding" to assign a buffer to each column in the database. In our case, Progress for "text" field datatype failed to initialize the pointer to that buffer. That is why Progress tried to bind a column to a nonexistent buffer, which caused the GPF.
FIX:
Do not use the FIELDS option in your query.