Ask Your Question
0

Getting BASIC runtime error. Device I/O error

asked 2020-02-21 01:31:12 +0200

Quarto Die gravatar image

updated 2020-02-21 04:55:56 +0200

On Fedora Workstation 31 which I have just installed in attempting to run the macro below, I am getting this error message, whIle using a split database and the Java-1.8.0 openjdk.

BASIC runtime error. Device I/O error.

I am running LibreOffice BASE version Version: 6.3.4.2.0+

I should note that I can run the same file on another computer using Fedora Cinnamon Desktop. And I could run in on Linux Mint 19.3 desktop, I have installed the same program with the macro and it worked.

The actual Macro: C:\fakepath\File1.png The Error message: C:\fakepath\Error message.png

Can anyone help?

edit retag flag offensive close merge delete

Comments

Please edit the reformatted and compacted code once more to make sure it is equivalent with the code that produced the error. In specific make clear the final MsgBox statement. It looks skew. Where was the string s defined? Why is the half mile of message at the end inside the loop?

Lupp gravatar imageLupp ( 2020-02-21 02:07:09 +0200 )edit

Hello,

Don't have your OS but can consistently get the same error in Firebird embedded if the location or name is incorrect. Double check your file path. Seems to be missing something - /home/????/SQL/File1.txt

Ratslinger gravatar imageRatslinger ( 2020-02-21 04:03:00 +0200 )edit

The error occurs in reality with this /home/username/SQL/File1.txt. In Fedora, I had to add the username in fact as home, as one can create folders directly in the home directory in Fedora Workstation, whereas in in Mint, or Fedora cinnamon, this is not possible. I am quite sure the problem has something to do with Fedora, as the macro still works on another computer with Fedora Cinnamon spin.

Quarto Die gravatar imageQuarto Die ( 2020-02-21 04:25:24 +0200 )edit

I have added a screenshot of the macro visible under my query at C:\fakepath\File1.png and of the error message. I quite think that due to the comment of Ratslinger that this may be due somehow to the manner in which Fedora workstation processes the folder structure leading to the file. Also I added a third screenshot of where the error occurs in the macro.

Quarto Die gravatar imageQuarto Die ( 2020-02-21 04:42:08 +0200 )edit

It is difficult since your code shows /Home/Xxxx..... when it is typically /home/Xxxx.....

You can try print curdir

And yes, that is the same error I was getting whenever the file name or directory was incorrect.

Ratslinger gravatar imageRatslinger ( 2020-02-21 04:58:47 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-02-21 18:48:09 +0200

Quarto Die gravatar image

I found the resolution it was due in part to my error, and in part to the way Fedora presents things. In looking in the file manage in Fedora, the directory structure or path seems to be /home/SQL/ and there is no indication that it is not. However like other Linux distros, the path is really /home/USERNAME/SQL/ Thus when I saw the way Fedora presented things in the file manager, I thought I needed to create a new folder with my username, in order that the path in all of my macros be correct. This would make my macros inaccessible since the path would now be /home/USERNAME/USERNAME/SQL/ . Thus in elimating my created username folder, the macros worked. I thank everyone for their help as it allowed me to look in the proper place to find the problem.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-02-21 01:31:12 +0200

Seen: 125 times

Last updated: Feb 21