Home > Back-end >  CBC executing SQL statements when INSERT INTO what kind of function of field conversion?
CBC executing SQL statements when INSERT INTO what kind of function of field conversion?

Time:10-06

Like to add a SQL statement in the database of the string, need what function? Thank you all for the

CodePudding user response:

Way to use param
 adoquery - & gt; Close (); 
Adoquery - & gt; SQL - & gt; Text="insert into t values (: (p1)";
Adoqery - & gt; Paramters - & gt; Parabyname (" p1 ") - & gt; Value=https://bbs.csdn.net/topics/... ;
Adoquery - & gt; ExecSQL ();

CodePudding user response:

Parameters, or adopt a stored procedure

CodePudding user response:

With 2 l way can solve most problems.. But if the field is bigint type words.. Can directly use AsString. Direct assignment or organization into the insert into statement..
  • Related