How can I build the params of ConnectionProperties.Execute() ?

畅雨 · 2014-05-27 06:25:36

My code:

var
vparam: array of Tvarrec;
...
// How can I build vparam ? the value form anther array (string array )

ConnectionProperties.Execute(aSQL, vparam)
...

Last edited by 畅雨 (2014-05-27 06:26:16)

ab · 2014-05-27 06:30:16

You should not use TVarRec, but an array of const parameters.

You can't bind a parameter array, just an array of constant parameters.

畅雨 · 2014-05-27 06:52:22

I do not know the number of parameters,Only know the number of parameters when running... Need to dynamically create parameters

ab · 2014-05-27 07:05:22

You can try to define an array of TVarRec and set each value using VariantToVarRec() from SynCommons.pas.

But I'm afraid it won't work with SynDB classes, since TSQLDBStatement.Bind() does not support variant kind of parameters (yet)!

The easiest is to bind all values one by one, using regular ISQLDBStatement.Bind() for each parameter.

畅雨 · 2014-05-27 07:31:28

thanks,

mORMot Open Source