Board index » delphi » ADo, MS SQL 2000 and Parameters

Marius Horak

Delphi Developer
Fri, 04 Feb 2005 17:58:34 GMT

ADo, MS SQL 2000 and Parameters

Parameters.ParamByName('DATA').LoadFromFile(sFile,ftBlob);

MH

 
Martijn Tonie

Delphi Developer
Fri, 04 Feb 2005 18:36:51 GMT

Re:ADo, MS SQL 2000 and Parameters


Quote
> Parameters.ParamByName('DATA').LoadFromFile(sFile,ftBlob);

Hi Marius,

I don't have a file :) ... And I don't want to create a file either...

btw, LoadFromFile simply calls LoadFromStream after creating a
TFileStream...

Here, this is from AdoDB:

procedure TParameter.LoadFromFile(const FileName: string; DataType:
TDataType);
var
  Stream: TStream;
begin
  Stream := TFileStream.Create(FileName, fmOpenRead);
  try
    LoadFromStream(Stream, DataType);
  finally
    Stream.Free;
  end;
end;

And why the message "String or binary data would be truncated"?

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Marius Hora

Delphi Developer
Fri, 04 Feb 2005 22:30:37 GMT

Re:ADo, MS SQL 2000 and Parameters


Try ftBlob instead of ftVarBytes.

MH

Martijn Tonie

Delphi Developer
Sat, 05 Feb 2005 19:16:39 GMT

Re:ADo, MS SQL 2000 and Parameters


Thanks - it seems to work fine now...

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

"Marius Horak" < > wrote in message news:3d6100d6$1@dnews...

Quote
> Try ftBlob instead of ftVarBytes.

> MH

Other Threads

1. MS SQL 2000 and runtime date parameters

2. ADO language parameter for SQL 2000

3. MS-SQL 6.5 & MS-SQL 2000

4. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

5. D5 + ADO + MS Sql 2000 = Unspecified Error

6. Delphi 5 - ADO - MS SQL Server 2000

7. ADO, MS SQL 2000, CursorType ctDynamic and temp tables

8. ADO + MS SQL 2000 + threads

9. DELPHI ADO & MS SQL 2000 Requery question

10. Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000