1. Beatrix Willius
  2. Valentina Database ADK
  3. Среда, Октябрь 30 2019, 01:59 PM
  4.  Подписаться через 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?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Right, RecIDs can't be imported.
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
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.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
  • Страница :
  • 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