command line output

[joshHunger]

Hi,

Thanks for this great software!

I'm testing it and having great results so far.
Now I need to operate the DBFcommander from the command line.
I was wondering if it is possible to get command line output?
When I try to print the output to a file like this :

Code: Select all

DBFCommander.exe -q "SELECT * FROM table_X WHERE table_ID='id'" >output.txt

I just end up with empty file

Regards,
J

[Admin]

Hi Josh,

Thanks for this great software!

we're glad that you like it

I was wondering if it is possible to get command line output?

Am I right that you need to view a DBF file in MS-DOS console? If so, then there is no such feature.
But you can execute SELECT ... INTO TABLE ... statement, and then open the destination DBF file with DBF Commander.

[joshHunger]

Thanks for your reply!
I am adding a mobile app to older software that uses DBF.
I need to sync information between the webapp and the older sofware.

So I wanted to write a script that can access the DBF database via commandline using DBFCommander.
And at the same time access the mySQL database that is the backbone of the webapp.

Do you think this is possible?

[Admin]

I think this is possible:

to write a script that can access the DBF database via commandline using DBFCommander.

But other actions are depend on what exactly you need to do.

BTW, you can also export a DBF file to a text CSV file with the following command:

Code: Select all

dbfcommander.exe -e "D:\Data\customer.dbf" "D:\customer.csv" ,

[joshHunger]

That should do the trick
Thanks!