Thanx for the suggestion. It really ne'er came to my mind to do like this. It is working fine. Just the quotes should not be given, that is

echo select * from table_1 | isql -u sysdba -p masterkey <dbfile>

This can be easily written in a batch file and the query can be given as an arguement to that batch file.

Thanx once a'ain.
Mahesh

Dimitry Sibiryakov <SD@...> wrote:

On 15 Dec 2003 at 12:48, Mahesh Ishwar wrote:

>I'm working on Windows XP and the firebird version I'm using is 1.5.0.3481 RC3.
>I want to execute some queries thru commandline by giving options to isql.

You can try to use stdin redirection. Something like this:

echo "Select * from table" | isql server:database -u user -p password

SY, Dimitry Sibiryakov.



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com




Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



---------------------------------
BT Yahoo! Broadband - Save £80 when you order online today. Hurry! Offer ends 21st December 2003. The way the internet was meant to be.

[Non-text portions of this message have been removed]