关于在Access中使用带有Memo字段类型的UNION查询的问题

我使用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>
Published At
Categories with 数据库类
Tagged with
comments powered by Disqus