1. Beatrix Willius
  2. Valentina Database ADK
  3. Wednesday, October 30 2019, 01:59 PM
  4.  Subscribe via email
A customer did something odd with the data of a small table. I wanted to fix this manually by editing the table in Excel. But an export to csv or a dump to Excel didn't have any RecIDs. How do I get those?
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Right, RecIDs can't be imported.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Beatrix Willius Accepted Answer
Ah, hadn't seen this button before. The 16x16 buttons in Valentina Studio seriously are too small.

Exporting the data with recid is good. But I don't think I can import the data with the recid again, can't I? Normally, you would want the database to handle the recids. Here, I just need to make corrections in the data. But the recids need to stay the same.

I din't want to have the customer send me his whole database because those tend to be large. But I don't think that I can avoid this.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Sergey Pashkov Accepted Answer
Hello Beatrix,

It is possible from the SQL Editor, just execute query returning RecID:
SELECT RecID, * FROM table1

And export records using the export button on the right bottom of the result.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories