Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Long Text and SQL 7.0
Message
From
09/10/2002 17:10:32
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Long Text and SQL 7.0
Miscellaneous
Thread ID:
00709557
Message ID:
00709557
Views:
49
Argh! This is a weird one. A user complained that their data in a text field
had disappeared. When I looked at the app the text <Long Text> was in the
text field. This was also the text value in the database (confirmed using 
Query Analyzer that it was not long text, but actually the charcter string 
<Long Text>). So it appears that the user hit save again on the screen and 
updated the field with the text <Long Text>. But how did <Long Text> ever 
show up in the first place!? It had to be either on the read or the update
(not sure which). I cannot find any reasonable explanation and as far as 
know, no error swere genreted during the transactions. Any clues?
Next
Reply
Map
View

Click here to load this message in the networking platform