We had similar performance problems with an order by in a view, which is
quite silly if the view is optimized isolated from the whole query.
Particularly when you want to select one single record from a view, it seems
that it selects everything, orders it, at then returns what you are looking
On Fri, 26 Jul 2013 08:29:10 +, Poul Dige p...@tabulex.dk wrote:
We had similar performance problems with an order by in a view, which
is
quite silly if the view is optimized isolated from the whole query.
Particularly when you want to select one single record from a view, it
seems that it
Hi all, I have a number of sps similar to this. Basically, I update,
insert or delete according to the parameter actiontype Then according
to the parameter tgp I use the q_tool table, the q_gauge table or the
q_ppap table. Everything else is identical and basically I want one set
of actions
On Fri, 26 Jul 2013 09:50:43 +0100, Alan J Davies
alan.dav...@aldis-systems.co.uk wrote:
Hi all, I have a number of sps similar to this. Basically, I update,
insert or delete according to the parameter actiontype Then according
to the parameter tgp I use the q_tool table, the q_gauge table or
Hi
We have a setup with two terminal servers and 1 database server running
Firebird 2.1.5.18497 (both server and klient).
This has been up and running for years.
Just a few days ago, this error starts coming on variuos machines, and I was
woundering what you would look after, check and
Unable to complete network request to host 192.168.3.25
Error reading data from the connection.
I would take a copy of OmniPeek, Wireshark or similar and check
network connectivity. In the few cases where I saw this, it always
have been problems with switches or firewalls. Once
Thanks Mark, it appears that what I want to do is not possible. i.e.
have the table name as a replaceable parameter. Using your example I
would still have 3 separate statements (as now) but in a different
format in the SP.
What I really would like to be able to do is (paraphrase):
declare
On Fri, Jul 26, 2013 at 12:26 PM, Alan J Davies
alan.dav...@aldis-systems.co.uk wrote:
**
Thanks Mark, it appears that what I want to do is not possible. i.e.
have the table name as a replaceable parameter. Using your example I
would still have 3 separate statements (as now) but in a
On Fri, 26 Jul 2013 11:26:31 +0100, Alan J Davies
alan.dav...@aldis-systems.co.uk wrote:
Thanks Mark, it appears that what I want to do is not possible. i.e.
have the table name as a replaceable parameter. Using your example I
would still have 3 separate statements (as now) but in a different
Ok, Mark Markus, thanks again for both your help.
I've tried this construct but get an error -206 column unknown pjs_no_in
which is passed in as an input parameter
declare variable table_to_use varchar(30);
declare variable stmnt varchar(500);
begin
table_to_use='q_tool';
begin
On Fri, 26 Jul 2013 13:14:08 +0100, Alan J Davies
alan.dav...@aldis-systems.co.uk wrote:
Ok, Mark Markus, thanks again for both your help.
I've tried this construct but get an error -206 column unknown pjs_no_in
which is passed in as an input parameter
declare variable table_to_use
Thanks again Mark - it took a while to work out what was going on (doh!)
but now it works very well and I can expand it to do what I want.
Once again, thank you.
Alan
Just for interest (for anyone else)
table_to_use='q_tool';
stmnt=
'update '|| table_to_use ||
' set
12 matches
Mail list logo