Sending Array of Variant to Server

[Theprasit]

I tried to send array of variant as remote function parameter using rtcArray but not success., e.g.

Sending -> OpenSql('Exec StoreProc1 :P1, :P2', [2, '300']);

This will call function to execute store procedure (which return record set) on the server side but seem not to work.

So, how to send this kind of data type among client and server?

Regards,

[D.Tkalcec (RTC)]

You can not send "Variant" data types, because "Variant" is not a type. It is a container for a number of different data types. But, you can send your store procedure call parameters in an array or record where each element is of a different type, like ...

Code:

with RtcClientModule.Prepare('OpenSql') do
  begin
  asText['my_sql_statement']:='Exec StoredProc1 :P1, :P2'; // Unicode String
  with newArray('my_parameters') do
    begin
    asInteger[0]:=2; // integer value
    asString[1]:='300'; // 8-bit character String 
    end;
  end;

While you could also use the "Value" property, which reads and sets data using the Variant type, I do not recommend it, because type conversions are required ("Variant" can NOT be sent) and you won't know for sure what type your data ended up in.

Best Regards,
Danijel Tkalcec

[Theprasit]

WOW! very fast response 

Per your example, this is fine but in actual requirement, the number of parameters is not fixed, that's why I intended to use open array to pass these parameters.

I did some experiment and managed to resolve it by iterate open array value into rtcArray data type (using .asValue[]).

I awarded with your mentioned about Variant but "OpenSql" is my generic function which receive any type of parameters for SQL statement.

Do you have any ideas beside using .asValue[] ?

Thank you and Regards,

[D.Tkalcec (RTC)]

If you are happy with "asValue", then use it. But I would recommend checking what type is actually being sent and then assigning the value using asInteger, asString, asText, asCardinal, asFloat, asDateTime, ... That's more work, but it ensures that you have covered all the types you need to support and that type conversions are done according to your requirements.

Best Regards,
Danijel Tkalcec

[Theprasit]

Thank you for your suggestion, will seek for others alternative.

Best Regards,