Re: Problem with append query - memo field

On Nov 29, 11:33 am, nujcha...@xxxxxxxxxxxxxx wrote:
Hi
I have a series of queries, I have a number of temp tables which I use
as templates for my data.
I start with
1. Delete the data in a temp table
2. Use append query to fill the temp table with data

Now, in the temp table, I have a memo field. I append information from
a text column (Oracle DB) into the memofield in the temp table. For
some reason, only the first 255 characters copied across as if it
takes that column in the temp table as a text field.

Why is this and how to work around it?

Many thanks
Padthai

We might be able to tell you why, and what to do about it if you post
the SQL you use to append. There are several special situations that
result in this truncating behaviour but which one is causing your
difficulty? We are likely to have a much better idea if you show us
the SQL.
.

Relevant Pages

  • Re: How to Create Local Temporary Table
    ... As Daniel pointed out, many times, it is locking that forces one to look at temp tables and Oracle does not share this problem. ... With the improvements in Oracle 9i and 10g and what Oracle has added to its SQL feature set, one can most often get by with just a single SQL statement, which is more efficient than writing data to a table and then reading it back again. ... If it places the group's minds at ease DB2 supports neither VARRAY nor local temps. ...
    (comp.databases.oracle.server)
  • Re: Indented Bill of Materials
    ... but eventually I will be calling SQL ... > have no parent are inserted in a temp table, ... > execution of the WHILE statement, the last executed statement is the SET ... > In the first iteration, @lev will be increased to 1. ...
    (microsoft.public.sqlserver.programming)
  • Re: Drop Table Columns
    ... I'm thinking the Append should be in two steps. ... is to merge that temp table into the master table. ... for future importing) once you get the results you want ... I cannot change the source excel file. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: help: Timeout expired. The timeout period elapsed prior to completion of the operation or the se
    ... Actually we are putting records in a temp table which qualify according ... code fails very much even before transaction starts. ... unless really needed pls dont use lock hints as SQL ...
    (microsoft.public.sqlserver.server)
  • Re: Order by in a INSERT INTO..SELECT
    ... Insert Into #TempPaging ... I can't provide a reproduceable scenario right now without making this ... select from the temp table will not fix the problem. ... seen this on SQL 2000 servers. ...
    (comp.databases.ms-sqlserver)