[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] No corresponding column type could be found for column 'ID'.


Hello Robert

See below.
Hello Robert

See below.


On 5/16/2019 2:53 PM, Robert Großkopf wrote:

Hi Paul,
When I want to append a Table from database one to database two, I get
the message "No corresponding column type could be found for column 'ID'."
The field "ID" from the Firebird-table must be autovalue.
The receiving firebird database two is ID primary key, AutoValue = yes, Length = 10

I you will import the table, which all contains text-fields, the wizard
will start. First you have to add the targettablename the content of the
fields should be added to. Mark also "First row will show fieldnames"
(don't know how it is called in English).

Up to this point everything works.

Table name is set correctly and Append Data is checked (circle filled with blue)

"Use first line as column names" is already check marked and cannot be changed.

Click on "Next" and then message shows "No corresponding column type could be found for column 'ID'."

Cannot continue past this message.

  Then goto next and mark all
fields of your importtable except "ID", if this content created new and
shouldn't be moved to the targettable. Switch with the arrow-buttons on
the right the field of the targettable, which should be filled by the
content of your importtable. The field ID of the targettable could be at
the same position as the field of the importtable, because you have
deselected the field ID from the importtable.

Hope this will work for you.

Regards

Robert

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.