Thanks to [leledumbo], GpSQLBuilder now works with the FPC pascal and supports the INSERT statement.
You can now write statements such as:
query := CreateGpSQLBuilder
.Insert
.Into(DB_TEST)
.&Set(COL_1, [42])
.&Set(COL_2, 'abc')
.AsString;
Which will give you:
INSERT INTO Test (Column1, Column2) VALUES (42, 'abc')
Thx leledumbo!
ReplyDelete