sql - MS Access "This recordset is not updatable" in a SELECT query -


i'm stumped regarding message ms access giving me.

i trying run select query, 2 sub-queries within it. tables local.

could please explain me why following code returning error?

select s.sku, s.date, s.[order no], p.wsp, p.average_cost, s.[item status] [item detail temp] s, [fd worksheets temp] p [p].[sku]=[s].[sku] , [p].[date use]=(select min(p2.[date use])                            [fd worksheets temp] p2                           p2.[sku] = s.[sku]                          ,    p2.[date use] >= s.[date]);

giving google hasn't particularly helped. have macros enabled in security make sure wasnt it, , can tell dont have sort of grouping in code above cause error?

additionally, believe code work fine, whole time loading bar message displayed in bottom left corner of screen. runs incredibly slow, , i'm sure have run query in past without message showing up, , quicker currently.

many thanks

edit: after looking bit more, have found few possible reasons:

"- uses first(), sum(), max(), count(), etc. in select clause. queries aggregate records read-only. - there min() function, causing it?

- has subquery in select clause. uncheck show box under subquery, or use domain aggregation function instead."

- fields in join not indexed correctly: there no primary key or unique index on joined fields. there no unique key fields, reason?

join table sources , use domain aggregate function, dmin, make query updateable.

from     [item detail temp] s     inner join [fd worksheets temp] p     on [p].[sku]=[s].[sku]     [p].[date use]=         dmin             (                 "[date use]",                 "fd worksheets temp",                 "[sku] = " & s.[sku] & " , [date use] >= " & format(s.[date], "\#yyyy-m-d\#")             );

Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more