UPDATE table from command line

[skydiver]

I am testing the evaluation version of the dbfcommander tool. I need to be able to script an update of a specific field in a database table by using the -q command line switch but this does not seem to work. I am getting an error that is an error opening d:\-q.
Is this an error due to the evaluation version?

[skydiver]

Any suggestions?

[Admin]

Hi,
thanks for your question!

No, the UPDATE statement should work. It looks like there is some syntax error(s) in your command line. Here is a sample command line for your case:

Code: Select all

dbfcommander.exe -q "UPDATE 'D:\Data\employee.dbf' SET emp_id='' WHERE ALLTRIM(emp_id)='6'"

More info on using command line you can find here: http://dbf-software.com/dbf-command-line.html

If you cannot find the error, please provide your command line (or SQL query) you want to execute.

[skydiver]

So I have a file job.dbf with columns ID | usernumber | longname | noprint
I can run the following SQL command from inside of dbfcommander in the SQL panel:
update D:\data\20100609\job.dbf set noprint='N' where ID=17

ID is type Numeric
norpint is type Char

I try to run this command from command line (dbfcommander is in the system path):
dbfcommander.exe -q "update 'D:\data\20100609\job.dbf' set noprint='N' where ID=18"
I get this error: Cannot open file "D:\data\20100609\-q". The system cannot find the file specified.
Click ok though the error and dbfcommander gui opens without any file loaded

I try to run this command from command line:
dbfcommander.exe -q "update 'D:\data\20100609\job.dbf' set noprint='N' where ID='18'"
Exactly the same error occurs

[Admin]

I just did EXACTLY what you're doing, and there were no any errors.

What version of DBF Commander Pro do you use? Please make sure your version is the latest - 2.8.41.
How do you run your command? Typing in command-line mode or using BAT file? If it's a BAT file and it contains other commands besides of this UPDATE SQL query, maybe some other command invokes this error?

[skydiver]

I am currently running dbfcommander (not pro yet) 1.1 build 25 as I entioned in the first post. I need to test this on my lab before we use this to update the files on the server.

I have tried from a command line session and also via a CMD batch file. I have also tried on both WIndows 7 32 bit and x64 with the same issue.

[skydiver]

Does the evaluation version of the pro version require internet access when you purchase the license? The server we need to run this on is a whitelist only network and doesn't have any external internet access.

[Admin]

DBF Commander Free (version 1.1.25) does not supports command line mode at all. Please use Pro version. It has 20-days trial period and is fully-functional.

>>Does the evaluation version of the pro version require internet access when you purchase the license?
No, DBF Commander Pro doesn't need Internet connection neither before purhase nor after.