[libreoffice-users] Import script problems

     I use LibreOffice to connect to HSQLDB 2.6.1 on UBUNTU 20.04. The 
problem is with this SQL statement:

PERFORM IMPORT SCRIPT DATA FROM <single-quoted file path> { CONTINUE | 
STOP | CHECK } ON ERROR

     The following is one of the properties of my database:

jdbc:hsqldb:file:/media/dan/Storage/.database/2020personal/2020personal;

     The file that I want to import is Main-subform.cvs.

     I have place this file in the folder containing the 4 database 
files (data,log, properties, script). Then in Tools > SQL, I entered 
this statement:

PERFORM IMPORT SCRIPT DATA FROM 'Main-subform.cvs' STOP ON ERROR; 
CHECKPOINT;     and then

PERFORM IMPORT SCRIPT DATA FROM './Main-subform.cvs' STOP ON ERROR; 
CHECKPOINT;     and then

PERFORM IMPORT SCRIPT DATA FROM '../Main-subform.cvs' STOP ON ERROR; 
CHECKPOINT;

     None of them worked. So, where should the cvs file be placed or 
what should the path be for this file?

Dan


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