It seem to me (Mr. Paul R. Alrick-) that the only way to get more than 10 records (per sql) each time is to find out if you can add more variables to the sql at the end of it to include more data, otherwise I am not really sure about sql, or does it stand for "sequential query language??" Have I helped -any?? Thanks. paulralrick@...





________________________________
From: Vishal Tiwari <vishualsoft@...>
To: firebird-support@yahoogroups.com
Sent: Sat, April 17, 2010 12:37:49 AM
Subject: [firebird-support] How to add addition record in sql output


Hi All,


I have a small doubt(and requirement also), if i am executing an sql statement and it is giving 10 records as an output, is it possible to get some extra rows with this output with some initial values or with no values for specified or for all columns.

For example, if i am getting 10 records as an output, is it possible to get an extra records means total 11 records (i.e. one extra record with or without values).

As per my efforts it seems to be not possible, but still i would like to clarify this doubt.

But i would like to do this effort with sql statement.

Thanks in advance.


Vishal

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







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