ADO and ORACLE CLOB

From: JMG (jmgranier_at_hotmail.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 10:58:18 +0200

Hello,

we have a problem when quering tables with CLOB fields.
This is a simple select query, not an update query.

in ADO/DELPHI 5, the query hangs with "unknown datatype" error.
in ADO .NET (C#) we have also problems to update but not to select...

The same query in BDE/DELPHI 5 works properly.

Have you ever seen this error with this datatype ?

If you have any solution (in D7 maybe ...)

Thank you.

Jean-Michel

Relevant Pages

  • Re: To change negative to positive in MS Access
    ... If you want to use the UPDATE query method and you will be importing new data into the table, ... UPDATE query that will only change the numbers that haven't been changed. ... changed data or if it is new, unchanged data and then build your UPDATE ...
    (microsoft.public.access.queries)
  • Re: Update query after an append query?+
    ... computer so that I could tell when and if I get the update query to work. ... that if you created your query under a different ANSI SQL query mode than ... the current mode of your Microsoft Access database then your update query ...
    (microsoft.public.access.formscoding)
  • Re: Append import data to existing record
    ... I'm glad you've got the key query working. ... With the update query open in Design View: ... Split the filespec apart and reassemble it into a ... Function BuildJetTextSource(ByVal FileSpec As String, ...
    (microsoft.public.access.externaldata)
  • Re: To change negative to positive in MS Access
    ... Rick's method is just a calculated field in a SELECT query. ... Klatuu's method is an UPDATE query and it WILL change your underlying data. ... If you are importing, this can be done using the update method, but it can be a little tricky. ... you are importing data from an external source and this field is negative in these source files, ...
    (microsoft.public.access.queries)
  • Re: merging data
    ... Whether you use an append query (copy data from one table / query to another ... you'd use an append query. ... One says to use an> append query, the other an update query. ... >>> have lists of product groups that compose these 5000 ...
    (microsoft.public.access.externaldata)