1. Beatrix Willius
  2. Valentina Database ADK
  3. 水, 10月 30 2019, 01:59 PM
  4.  メールで購読
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 承諾済みの回答
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.
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 承諾済みの回答
Right, RecIDs can't be imported.
コメント
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories