Re: CLOB SUPPORTED in Delphi 5/7 ADO ?

Jean-Michel Granier wrote:

What is the query being used? Have (for example) writen the query
as

select clob_field from clob_table where value = : VALUE

Note the space after the parameter indicator. This could give you the
error you are talking about. to fix it just delete the space.

HTH

Graham Harris
> Hello there,
>
> big problem
>
> i need to query a table which contains a clob field.
>
> The query hangs with : not supported field.
>
> BDE runs the query fine.
> Toad : OK
> DBArtisan : OK
>
> Oracle 9.2.1.0 version both client and server side
> mdac 2.8
> tried with mdac 2.7 and also ORacle 8.1.7.0 client.
>
>
> What/where is the problem with CLOB and Delphi ???
>
> Best regards.
>
> Jean-Michel
>
>
> PS'SOFT The IT Asset & Service Management Specialists Jean-Michel
> Granier Chef de Produits "Le Berlioz" - 100, rue Albert Caquot 06410
> Sophia-Antipolis/Biot - France jmgranier@xxxxxxxxxx +33 (0)4 93 65 27
> 86



--

.

Relevant Pages

  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • lame server messages in named.log
    ... Mar 30 05:42:30.526 security: info: client 202.52.250.176#1052: ... query (cache) denied ...
    (RedHat)
  • Re: High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... We have encountered similar problems not limited to Excel, but every client. ... occur when there are many dimensions nested on each other on a single axis ... > Performance Guide to optimize the query, the cube, the server, etc. ... > While the query was grinding, the server was doing absolutely nothing. ...
    (microsoft.public.sqlserver.olap)
  • Re: Delete Query Does Not
    ... When I try to run the SQL query below it gives me the ... Cannot group on fields selected with '*' (client) ... INNER JOIN meals ... Tom Ellison ...
    (microsoft.public.access.queries)
  • Re: Report filtered on a calculated field
    ... Make a query to determine who owes you. ... make this into a Totals Query. ... now you can base your first report directly on this query. ... totals for each client, also define a Client footer section as well. ...
    (microsoft.public.access.reports)