Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 492
  • Last Modified:

dbnavigator question

using tquery and set requestlive to true.
click dbnavigator insert button and input new record data.
post it . but the new record position is not the last.
why?
and click refresh button.
it has 'table is not supported this operation because it is not uniquely indexed'exception
who can solve this problem?
thanks.
0
fatchoi
Asked:
fatchoi
1 Solution
 
MotazCommented:
Use Query1.Append; because + button means Query1.Insert; which inserts new record in current location. So that drop new button and write this code on it:

Query1.Append;

The exception that occures with refresh means that you should make primary key for your table.

Refresh is used when many instances of datasets are updating current table.

Motaz
0
 
fatchoiAuthor Commented:
i means the position is not after the current record when using append.and not before the current record when using insert.
and i already set the id field to primary.
but the same error occurs.
thanks.
0
 
CleanupPingCommented:
fatchoi:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now