我使用UNION将包含MEMO类型的查询语句联合起来查询,在我机子的Access中使用没有问题,而在同事的机子使用却不行,提示UNION不能包含Memo类型,我真是晕过去了,有人知道原因码?最好是能够将解决办法告知,谢谢
---------------------------------------------------------------
When you run a SQL-specific union query that contains an OLE Object field, you may receive the following error message:
Can't use Memo or OLE object field
1<fieldname> in the SELECT clause of a union query.
2
3Cause
4By default, union queries implicitly sort the data and delete duplicate records. Because Memo and OLE Object fields cannot be sorted, the error occurs.
5
6Resolution
7To avoid this error, add the ALL predicate to eliminate the sorting of the field data. For example, add the ALL predicate to the following SQL statement
8
9SELECT DISTINCTROW Employees.[LastName], Employees.Photo
10FROM Employees
11UNION
12SELECT DISTINCTROW Employees.[LastName], Employees.Photo
13FROM Employees;
14
15to produce the statement:
16
17SELECT DISTINCTROW Employees.[LastName], Employees.Photo
18FROM Employees;
19UNION ALL
20SELECT DISTINCTROW Employees.[LastName], Employees.Photo
21FROM Employees;
22
23Note that the SQL statement with the ALL predicate does not remove duplicate records.
24
25NOTE: The [LastName] field in the above example should be [Last Name] in version 2.0.
26
27
28References
29For more information about union queries, search the Help Index for "union queries," or ask the Microsoft Access 97 Office Assistant.
30
31Additional query words: querying can t use memo or ole object field
32
33Keywords: kberrmsg kbusage
34Issue Type: kbprb
35Technology: kbAccessSearch kbAccess200 kbAccess97 kbAccess97Search kbAccess95Search kbZNotKeyword3 kbAccess700</fieldname>