Unable to edit data in queries

Hi,
When I am creating a new query in DataGlass, I can alter data in fields. However, the same query (using exactly the same fields and criteria) created within Access and loaded into DataGlass produces an error when I tap "edit":
quote
Cannot Edit Record
..... because it is a view or has no primary key fields defined ....
unquote
The Access-query is in the form of a dynaset and contains the primary key-field of its underlying table.
Can I only edit data in existing tables but not in existing queries?

Fritz
2 people have
this problem
+1
Reply
  • Walter (Customer Support Representative) April 22, 2012 22:09
    This is a known issue. When running a pre-defined query in Access, the database doesn't correctly report the existence of the primary key fields.

    One work-around is to re-create the query in the app itself (either using the Query Builder forms, or with custom SQL) and then bookmark the query. When you run that query, the primary keys should be identified and you should be able to edit the records.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated

  • Thank you for your reply. Creating Queries within DataGlass via Query Builder or SQL is a VERY fickle affair and goes wrong more often than it works. I understand this has to do with the very strict adherance to SQL standards by DataGlass.
    It appears, the only practical way to use DataGlass is to delete/reload the database to achieve synchronized files on both the PC and the SmartPhone. I can live with that.
    Fritz
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. kidding, amused, unsure, silly indifferent, undecided, unconcerned happy, confident, thankful, excited sad, anxious, confused, frustrated