Thank you, Svein. I think I will implement the Default solution since my
application
allows the end user to create ad-hoc queries (of sorts). I think setting the
default will
produce fewer questions about why records are omitted. You are correct in
assuming that unknown is the same as empty.
homerjones1941 wrote:
I think I will implement the Default solution
Would there be a problem in using Coalesce(...) in addition to setting the
default values? I can't think of any, other than it may be overkill.
There would be no problem, and it is not overkill. Please note that
default is
Hello! I use FB2.5. It is possible to have an SP in which I send a
string as input paramemeter and I get the value of some field named as
my input parameter?
CREATE PROCEDURE PANIO_TERMINADO (
in_id fk_id,
in_etapa codigo)
returns (
out_fecha fecha_hora)
as
begin
select /*
well... after doing my post I've found this..
http://www.firebirdfaq.org/faq322/
and I did this
CREATE PROCEDURE PANIO_TERMINADO (
in_id fk_id,
in_etapa codigo)
returns (
out_fecha fecha_hora)
as
declare variable loc_sql descripcion;
begin
loc_sql = 'select ' || in_etapa || ' from
Thank you very much Tomasz Frank!
I'm selecting by the PK, so I'm prety sure that there always will be just one
row!!
As allways, the help I receive from this group in invaluable to me!!
-s
Den 2011-11-07 10:55 skrev Milan Babuskov såhär:
homerjones1941 wrote:
I think I will implement the Default solution
Would there be a problem in using Coalesce(...) in addition to
setting the default values? I can't think of any, other than it may be
overkill.
There would be no problem,
Hello Mark
I think so, but doesn't work.
Greetings.
Walter.
On Mon, Nov 7, 2011 at 3:30 AM, Mark Rotteveel m...@lawinegevaar.nl wrote:
**
On 7-11-2011 3:37, W O wrote:
Hello everybody
I know that I can connect to a data base writing something like:
CONNECT
Am 07.11.2011 16:27, schrieb Tomasz Tyrakowski:
Hi,
One small improvement.
Instead of
execute statement :loc_sql into :out_fecha;
I'd recommend
for execute statement :loc_sql into :out_fecha do suspend;
and additional take a look at
Background:
A customer bought a new computer, Win7 64-bit, with a 2 disk RAID
configuration. The system was installed by a person who said to me 'I am not a
professional, this is more a hobby'.
My task was to transfer the application and data from the current
server/workstation (XP) which has
W O wrote:
If mydomain.com resolves to IP address 80.51.2.3 and you are able to
connect using the IP address then you should be able to connect using
mydomain.com
I think so, but doesn't work.
So does CONNECT 80.51.2.3:C:\Databases\MyDataBase.FDB work?
I would suspect that you have a
--- In firebird-support@yahoogroups.com, W O sistemas2000profesional@...
wrote:
Hello Mark
I think so, but doesn't work.
Greetings.
Walter.
But what not work
1. connect by IP adress
2. connect by domain name
if first - then you have not port forwarding on your router set
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On 5-11-2011 12:00, venussoftop wrote:
I know a qty. for a particular item purchased. This item though has been
purchased over a long period only the last few purchase bills are now of
concern (FIFO method). I
Hello Lester
Well, writing the URL it works, but writing the domain name, not.
Greetings.
Walter.
On Tue, Nov 8, 2011 at 2:53 AM, karolbieniaszewski
liviusliv...@poczta.onet.pl wrote:
**
--- In firebird-support@yahoogroups.com, W O sistemas2000profesional@...
wrote:
Hello Mark
Hello Karol
1. (connect by IP address) works well
2. (connect by domain name) doesn't work
Greetings.
Walter.
But what not work
1. connect by IP adress
2. connect by domain name
if first - then you have not port forwarding on your router set properly
or your firewall block port default
14 matches
Mail list logo