Re: Saving Image/Picture to Database using ADO

It took me a little while to realize that you are using code from a old Delphi 5 example that of
posted above five years ago in 2001. A few things have changed over the years and ADO access is one.

I have put together a complete working example and you can get it from here.

http://www.dpassmore.com/wdata/ADOPictures.zip

It is based on a MsSql 2000, sp4 server and the NorthWind database.

Let me know what other problems you run into.


.

Relevant Pages

  • Re: locking rows
    ... Jon thanks for your interest in my post, ... I'm programming in Delphi 7 with MSSQL, ... in a catalog of customers I use an adodataset. ...
    (microsoft.public.sqlserver.programming)
  • Re: WHERE IntegerPrimaryfield IN List
    ... which does work fine in Delphi with MSSQL 2000 (though afaics T/SQL has no ... As far as the IN statement, it's part of MSSQL T-SQL syntax, not specific to ... PersonID IN is converted to ... Run the real query you using in Query Analyzer, do you get the same results? ...
    (borland.public.delphi.database.ado)
  • [Microsoft][ODBC SQL Server Driver]Optional feature not implememted
    ... I am using MSSQL 2000 and Delphi 7 enterprise. ... execute the following TADOQuery: ...
    (borland.public.delphi.database.ado)
  • Re: SQL Server 2005: Cannot refresh a TADOTable
    ... replied that for MSSQL 2K5, you have to fully qualify object names. ... the table schema, SQL you are using, and ADO version. ... > What in the world is that and how do I refresh an ADO table? ... > Will it go away if I upgrade to Delphi 2005? ...
    (borland.public.delphi.database.ado)
  • Re: Access Violation when setting SQL property
    ... >Which version of Delphi and do you have latest patches? ... I have installed the only update that relates to MSSQL. ... however memo field problems seem to be overcome by using parameters and so I have gotten in the habit of parameterizing queries. ...
    (borland.public.delphi.database.ado)