Home > Software engineering >  Increase the vb database columns Adodc3. You. Fields (" Date ")=Trim error (Date. The Text
Increase the vb database columns Adodc3. You. Fields (" Date ")=Trim error (Date. The Text

Time:09-26

Adodc3. You. Fields (" Date ")=Trim (Date. The Text)
Adodc3. You. Fields (Dno)=Trim (Dno. Text)
CmdCancel. Enabled=False
Adodc3. You. Update
CmdAdd. Enabled=True
CmdDel. Enabled=True
CmdCancel. Caption="update"
Why always me the first line has a problem,
Compile error:
Missing: list separators or)

CodePudding user response:

Try this:
Adodc3. You. Fields (" [Date] ")=Trim (Date. The Text)

CodePudding user response:

Adodc3. You. Fields (" Date ")=Trim (Date. The Text)
Fields is can not, of course, want to don't affect program not
First you need to check the type Date is the Date field in the database, and if so, the Date, the Text shows what is the Date format, extra or missing any
Usually record the date of this writing will be better:
Adodc3. You (" Date ")=Format (Date. The Text, "yyyy - mm - dd")
To ensure that the records are correct date format

CodePudding user response:

The Date. The Text is a Text box? But the Date is VB keyword, is a function name, according to it as a text box is not possible, the name of the program is running, it think this is the first function, therefore, there will be a mistake,

CodePudding user response:

The Date is VB reserved words. You modify the name of the textBOX

CodePudding user response:

reference 4 floor aspower_ response:
Date is VB reserved words. You modify the name of the textBOX.



Agree with this, change to another name
  • Related