Firebird move file for me

[xinyiman]

Hello guys I have an application written in Lazarus that refers to a firebird db. And in a table called T_File I own a field called OLD_PATH that contains the file path at the present time and new_path that will contain the path where I want this file to be moved. Until everything is right. I was wondering there is a chance to tell firebird to really move the files from OLD_PATH new_path through a store procedures? If you like I do?

[rvk]

There is no "move database" command (that I'm aware of) in Firebird.

You'll need to move the databsse manually. There is however a method to do it in code and safely. You can backup the database to the same name but with extension .fbk (instead of .fdb for example). Then you can change the connection-string to include the new path and restore the backupped database.fbk to that location. At that point you have the database at the new location. There is however no possibility to delete the old database file.

All this is because you might not have physical access to the real database location. If you do have access you can delete the original database with a simple deletefile command. (you can also delete the .fbk backup-file when you're sure the new database is all correct)

For some code to backup and restore you can look at the wiki here:
http://wiki.freepascal.org/TFBAdmin

[xinyiman]

No, it is not move the database, it is to launch a shell command to move an image attached to my records

[rvk]

No, it is not move the database, it is to launch a shell command to move an image attached to my records

Well, that has nothing to do with Firebird itself. Firebird can't move arbitrary files for you or even run a shell you made. You'll need to do that yourself. (It would be a huge security risk if Firebird could do that)

If you have access to the locations of the files you can move them yourself with code, otherwise you'll need to establish a connection (via telnet or SSH) and execute your script.

[xinyiman]

In fact, I was almost sure that it was so. But I hoped for a miracle. I know that I have to write a service that reads that data. Thanks anyway

[rvk]

In fact, I was almost sure that it was so. But I hoped for a miracle. I know that I have to write a service that reads that data. Thanks anyway

You could try programming this yourself via UDF but I wouldn't recommend it:
http://stackoverflow.com/questions/22945455/does-firebird-have-the-ability-to-run-system-level-commands

A server-side script would indeed be better in this case.