Very vegetable problem, please heroes help me

summer945

var
x: string;
sqlstr, y: integer;
begin
x: = '12313';
y: = 12;
sqlstr: = 'instert into cart values ​​(' '' + y + '' ',' '' + x + '' ')';
query1.connection: = main.conn;
...
end
The integer y in the SQL name cannot be inserted. How can I rewrite this SQL statement?
And how to read the field value in a query
I can read using query ['id'], but the query is limited to only one record
Help me! !!

dai87331

attention

ysn10000

sqlstr: = 'insert into cart values ​​(' '' + IntToStr (y) + '' ',' '' + x + '' ')';

shuang525

var
x: string;
sqlstr, y: integer;
begin
x: = '12313';
y12;
sqlite: = 'insert into cart values ​​(' + y + ',' + '' '' + x + '' '' + ')';
query1.connection: = main.conn;
...
end

summer945

My field is digital

andypeng

var
x: string;
sqlstr, y: integer; // sqlstr: String; sqlstr is a string! You wrote it wrong!
begin
x: = '12313';
y: = 12;
sqlstr: = 'instert into cart values ​​(' '' + y + '' ',' '' + x + '' ')';
// sqlstr: = 'insert into cart values ​​(' + inttostr (y) + ',' '' + x + '' ')';
// Ｙ is an integer to turn around! There is no need to add 'in integers in SQL! So just remove it!
query1.connection: = main.conn;
...
end

1166222

var
x: string;
y: integer;
sqlstr: string;
begin
    x: = '12313';
    y: = 12;
    sqlstr: = 'insert into cart values ​​(' + inttostr (y) + ',' '' + x + '' ')';

query1.connection: = main.conn;
...
end

溯夜惊蛰

You can use the format statement to format
Are you sure that the field you want to insert y is numeric?
sqlstr: = format ('instert into cart values ​​(% d,' '% s' ')', [y, x])

xclzc17

sqlstr: = 'insert into cart values ​​(' + IntToStr (y) + ',' + x + ')';