1. Beatrix Willius
  2. Valentina Database ADK
  3. Mittwoch, Oktober 30 2019, 01:59 PM
  4.  Abonnieren via E-Mail
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?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Right, RecIDs can't be imported.
Kommentar
There are no comments made yet.
  • Seite :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories