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

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.

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). 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
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
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