BorlandTalk.com

Guest

I'm not having any success at something that should be (and probably
is) very simple:
I want to store an integer array into a SQL Server BINARY data field.
Psuedocode:

var MyIntArray : array[0..9] of Integer;

begin
(Fill MyIntArray with integers here)
Dataset.Active := true;
Dataset,Edit;
Dataset['MyBinaryField'] := MyIntArray;
Dataset.Post;
end;

Of course, this doesn't work. Delphi complains that the 'Variant' and
'Array' types are incompatible.

What's the most efficient way to make Delphi accept the array into the
data field? Perhaps the SQL field should be a different data type?

{Origianlly posted to ../Database/General Group - sorry for the
cross-posting, but this seemed to fit better here.]

TIA