#62 tffquery parambyname loadfromstream/file

[Anonymous]

acaduto@amsoftwaredesign.com

When loading a stream via a parameterized query flash
filer cannot load in any data bigger than 64k

Here is the fix:

piLength needs to be a integer not a word. After this
is changed there are several other procedures that need
to be changed as well.

I found the bug and it is a simple fix:

TffSqlParamInfo = record {Information block
for SQL parameter}
piNum : word; {..parameter number
(1..n)}
piName : string[ffcl_GeneralNameSize];
{..parameter name }
piType : TffFieldType; {..data type}
piOffset : word; {..offset in record}
piLength : word; {..length in bytes}
end;

The fix is to change pilength to a Integer, a word is
not big enough to hold
large files, that's why it could not load anything
bigger than 64k.

How do we go about updating the OS version on Source Forge?

TffSqlParamInfo = record {Information block
for SQL parameter}
piNum : word; {..parameter number
(1..n)}
piName : string[ffcl_GeneralNameSize];
{..parameter name }
piType : TffFieldType; {..data type}
piOffset : word; {..offset in record}
piLength : integer; {..length in bytes}
end;