Adodc1. You. Find "commodity name=" + CRH (39) + mhf1. TextMatrix (I, 1) + CRH (39) + "And batch number=" + CRH (39) + mhf1. TextMatrix (I, 3) + CRH (39) + "And origin=" + CRH (39) + mhf1. TextMatrix (I, 4) + CRH (39) + "And size=" + CRH (39) + mhf1. TextMatrix (I, 5) + CRH (39) + "
"How can I change!

CodePudding user response:

You set a variable, such as s1,
S1="commodity name=" + CRH (39) + mhf1. TextMatrix (I, 1) + CRH (39) + "And batch number=" + CRH (39) + mhf1. TextMatrix (I, 3) + CRH (39) + "And origin=" + CRH (39) + mhf1. TextMatrix (I, 4) + CRH (39) + "And size=" + CRH (39) + mhf1. TextMatrix (I, 5) + CRH (39) + "
"
And then print it out and see whether conform to the specifications first,
The debug. Print s1

CodePudding user response:

CRH (39) is not single quotation marks', why the whole so complicated,

CodePudding user response:

Set a variable have to link tables in the database, ADO controls is the data source, the method of online are connected to the ACCESS database, don't know how to let the variable SQL data source connection

CodePudding user response:

First in program analyzer manually enter the query command, right after the write in your code,

CodePudding user response:

Correct the upstairs:
Inside the "query analyzer" first...

CodePudding user response:

I guess your batch number field is numeric, then you use here is that the string, and then an error,

Of course, it is best to do you according to the 1st floor said, print out the results of this string concatenation, you look at what is causing the,