update query - memo field

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

Hello all,

I have come a cross a problem; while using the 'append query' to write data
from a old table into a new table, I found that the memo field used in the
original one only get copied with a max length of 255 characters. However I
do copy (append) a memo field into a memo field.

What am I doing wrong or how can I solve this?

The hole thing is to get several different tables generated on one machine
into one single table, where as well I did add some different features.

Thx,
Ludovic
 
Vsn said:
Hello all,

I have come a cross a problem; while using the 'append query' to
write data from a old table into a new table, I found that the memo
field used in the original one only get copied with a max length of
255 characters. However I do copy (append) a memo field into a memo
field.
What am I doing wrong or how can I solve this?

The hole thing is to get several different tables generated on one
machine into one single table, where as well I did add some different
features.
Click to expand...

Does your append query have any formatting on the memo field or use any
functions against it?
 
Rick, no i just used a 'plain' append query.

INSERT INTO tblFAQ_01 ( fGroup, fPriority, fSubject, fText, fKeywords, fRND,
fAddDate, fEditDate, fEditAddMachine )
SELECT tblNewFAQ.fGroup, tblNewFAQ.fPriority, tblNewFAQ.fSubject,
tblNewFAQ.fText, tblNewFAQ.fKeywords, tblNewFAQ.fRND, tblNewFAQ.fAddDate,
tblNewFAQ.fEditDate, tblNewFAQ.fEditAddMachine
FROM qryFinalPick INNER JOIN tblNewFAQ ON qryFinalPick.fRND =
tblNewFAQ.fRND;

Looks a bit messy but is a straight append quiry I tought, it only checks
for the designated records to be copied.

Thx,
Ludovic
 
Vsn said:
Rick, no i just used a 'plain' append query.

INSERT INTO tblFAQ_01 ( fGroup, fPriority, fSubject, fText,
fKeywords, fRND, fAddDate, fEditDate, fEditAddMachine )
SELECT tblNewFAQ.fGroup, tblNewFAQ.fPriority, tblNewFAQ.fSubject,
tblNewFAQ.fText, tblNewFAQ.fKeywords, tblNewFAQ.fRND,
tblNewFAQ.fAddDate, tblNewFAQ.fEditDate, tblNewFAQ.fEditAddMachine
FROM qryFinalPick INNER JOIN tblNewFAQ ON qryFinalPick.fRND =
tblNewFAQ.fRND;

Looks a bit messy but is a straight append quiry I tought, it only
checks for the designated records to be copied.
Click to expand...

In a new query (SQL View) just paste this portion...

SELECT tblNewFAQ.fGroup, tblNewFAQ.fPriority, tblNewFAQ.fSubject,
tblNewFAQ.fText, tblNewFAQ.fKeywords, tblNewFAQ.fRND,
tblNewFAQ.fAddDate, tblNewFAQ.fEditDate, tblNewFAQ.fEditAddMachine
FROM qryFinalPick INNER JOIN tblNewFAQ
ON qryFinalPick.fRND = tblNewFAQ.fRND

....and then switch to datasheet view. Is the memo data truncated there?
 
Yes it is. I checked it like this:-

SELECT tblNewFAQ.fGroup, tblNewFAQ.fPriority, tblNewFAQ.fSubject,
tblNewFAQ.fText, Len([fText]) AS lg, tblNewFAQ.fKeywords, tblNewFAQ.fRND,
tblNewFAQ.fAddDate, tblNewFAQ.fEditDate, tblNewFAQ.fEditAddMachine
FROM qryFinalPick INNER JOIN tblNewFAQ ON qryFinalPick.fRND =
tblNewFAQ.fRND;

I added a Len() function in your SQL statement (for ease).

And still the original tables are ok (I checked to be sure).

Thx for your help.
Ludovic
 
Vsn said:
Yes it is. I checked it like this:-

SELECT tblNewFAQ.fGroup, tblNewFAQ.fPriority, tblNewFAQ.fSubject,
tblNewFAQ.fText, Len([fText]) AS lg, tblNewFAQ.fKeywords,
tblNewFAQ.fRND, tblNewFAQ.fAddDate, tblNewFAQ.fEditDate,
tblNewFAQ.fEditAddMachine FROM qryFinalPick INNER JOIN tblNewFAQ ON
qryFinalPick.fRND =
tblNewFAQ.fRND;

I added a Len() function in your SQL statement (for ease).

And still the original tables are ok (I checked to be sure).
Click to expand...

How about if you get rid of the join? Start with the simplest possible
query...

SELECT MemoFieldName FROM TableName

....and see if it truncates. If not then add more elements of the original
query one at a time until you see what causes the change.
 
Back
Top