Access数据库中的字段值不可见 [英] Field value in Access database not visible

问题描述

嗨
我遇到一个奇怪的问题。

当我从VB.net代码向MS Access 2010插入记录时，会插入记录。但是当我打开Access数据库时，我发现第一个字段没有显示该值。但是我知道值已被记录但只是不可见（通过在搜索文本框中输入值的字符，它将可见但在光标移出时再次消失）

VLPatil

Hi I am facing a strange problem.
When I insert a record from VB.net code to MS Access 2010, the record gets inserted. But when I open the Access database I find that the first field is not showing the value. But I know that the value is recorded but just not visible (By entering a character of the value in search textbox, it will be visible but again vanishes when cursor is moved out)
VLPatil

推荐答案

不，这是不可能的。您在数据库中插入的值将/应该在数据库表中可用。如果我没有错，你的记录（你试图插入）不会插入数据库。

No, it's not possible. A value you inserted in database will/should be available in the database table. If I am not wrong, your record(which you are trying to insert) is not getting inserted in database.

PatilVL写道：

PatilVL Wrote:

通过在搜索文本框中输入值的字符，它将可见但在光标移出时再次消失

By entering a character of the value in search textbox, it will be visible but again vanishes when cursor is moved out

这只是因为浏览器缓存。



您必须调试代码，并找出错误的根本原因。

- Amit

这是一个愚蠢的错误。

在vb代码中添加了字符vbcrlf（在字符串的开头，在某个地方插入到字段中的文本字符串。（如果我想存储一个字符串Mystring，我发送的是vbcrlf &Mystring）。因此存储的刺痛根本不可见！

This was a silly mistake.
In vb code the character vbcrlf was added (in the beginning of the string in some place to the text string which was inserted into field. (If I wanted to stored a string Mystring, I was sending vbcrlf & Mystring). Thus the sting stored was not at all visible!

这篇关于Access数据库中的字段值不可见的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！