C using ADO SQL insert data of more than 4000 what should I do-CodePudding

As title, the current writing SQL commands
StrSQL. The Format (_T (" INSERT INTO % s (% s) VALUES (% s) "), the tableName, szColumn, szRow);
I check the information on the Internet to convert the value of the value to clob types, but c + + ADO how to operate

CodePudding user response:

What is the target field data types?

CodePudding user response:

The

reference 1/f, started the first reply:

what is the data type of the target field?

Clob type, but actually I upload the past as the default type is varchar2, so cause the program directly flash back

M_pRst=m_pConn - & gt; Execute (_bstr_t (strSQL), NULL, adCmdText);
After performing the to this sentence, flash back directly

CodePudding user response:

refer to the original poster master save me 10086 response:

, such as the topic, the current writing SQL command
StrSQL. The Format (_T (" INSERT INTO % s (% s) VALUES (% s) "), the tableName, szColumn, szRow);
I check the information on the Internet to convert the value of the value to clob types, but how c + + ADO operation

ADO there should be a lob data operation method,

CodePudding user response:

reference 5 floor lhdz_bj reply:

Quote: refer to the original poster master save me 10086 response:

As title, the current writing SQL commands
StrSQL. The Format (_T (" INSERT INTO % s (% s) VALUES (% s) "), the tableName, szColumn, szRow);
I check the information on the Internet to convert the value of the value to clob types, but how c + + ADO operation

ADO, there should be a lob data operation method

There are some but I check the information on the Internet is used in Java or VB didn't see examples of c + +,,