Perhaps my problem is in an incorrect installation setting?
I have FB 2.5.3 on a laptop. Win 7 32 bit.
I introduced a stored procedure and in it call F_LEFT(:varName, 24) to
truncate :varName from a vc(48).
This DB is used in Win 7 and win 8.1 else where without problem.
When I run the
>Perhaps my problem is in an incorrect installation setting?
>I have FB 2.5.3 on a laptop. Win 7 32 bit.
>I introduced a stored procedure and in it call F_LEFT(:varName, 24) to
>truncate :varName from a vc(48).
>This DB is used in Win 7 and win 8.1 else where without problem.
>
>When I run the pr
On Thu, 28 Aug 2014 10:32:51 +0200, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
>>Perhaps my problem is in an incorrect installation setting?
>>I have FB 2.5.3 on a laptop. Win 7 32 bit.
>>I introduced a stored procedure and in it call F_LEFT(:varName,
On 28 Aug 2014 01:10:40 -0700, "russ...@belding.co.nz [firebird-support]"
wrote:
> Perhaps my problem is in an incorrect installation setting?
>
> I have FB 2.5.3 on a laptop. Win 7 32 bit.
> I introduced a stored procedure and in it call F_LEFT(:varName, 24) to
> truncate :varName from a vc
>>I have FB 2.5.3 on a laptop. Win 7 32 bit.
>>I introduced a stored procedure and in it call F_LEFT(:varName, 24) to
>>truncate :varName from a vc(48).
F_LEFT belong to FreeUDFLib which you need to install.
Since you are already using FB2, it’s much easier to just use the built in
LEFT() func
Thank you Set, Mark and Maya. I think I see my error and will test it tomorrow.
On the network where F_LEFT worked I had installed FreeUDFLib.DLL long ago.
On the remote laptop where if failed I did not install FreeUDFLib.dll
Using Substring(..) or LEFT(..) is better as they require no installa
Hi all,
I have a table with ddl : create table Tbl1(id int,dscp varchar(100))
Is there a tool to encrypt data in field dscp? I only need to encrypt that
field, not all field.
Thanks in advance & Regards,
Anto
>Hi all,
>
>I have a table with ddl : create table Tbl1(id int,dscp varchar(100))
>
>Is there a tool to encrypt data in field dscp? I only need to encrypt that
>field, not all field.
You can read a bit about encryption on
http://www.firebirdsql.org/manual/fbmetasecur-solution.html or
http://www
Hi, I'm looking at a system that I have not touched for some years and
wonder if there is a way to improve this code. This all works, but is
there a better or more efficient way? I can't think of how to combine
them into one 'where' statement.
Basically I look for a part based on increasingly ti
On 28 Aug 2014 03:24:18 -0700, "trsk...@yahoo.com [firebird-support]"
wrote:
> Hi all,
>
> I have a table with ddl : create table Tbl1(id int,dscp varchar(100))
>
> Is there a tool to encrypt data in field dscp? I only need to encrypt
that
> field, not all field.
There is no standard functional
On Thu, 28 Aug 2014 12:11:59 +0100, "Alan J Davies
alan.dav...@aldis-systems.co.uk [firebird-support]"
wrote:
> Hi, I'm looking at a system that I have not touched for some years and
> wonder if there is a way to improve this code. This all works, but is
> there a better or more efficient way? I
> Hi, I'm looking at a system that I have not touched for some years and
> wonder if there is a way to improve this code. This all works, but is
> there a better or more efficient way? I can't think of how to combine
> them into one 'where' statement.
> Basically I look for a part based on incre
On Thu, 28 Aug 2014 12:54:33 +0200, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
> At my workplace, we encrypt (or obfuscate) some fields in our programs
and
> only use Firebird for storage of the field (hence, Firebird knows
nothing
> about the encryptio
I have 1 out of 50+ Firebird installations that slows done dramatically after a
time (+- 24 hours) Queries that normally takes less than 0.01 secs takes 5-8
secs). Specs of problem Server: Firebird 2.5.2 SS, 2GB, Win XP SP2 with just 1
workstation connected.
I did a backup/restore, check the
Hello,
the following sql statement is almost done, just one thing is problematic.
SELECT TTEILE.TEILENR, TTEILE.BEZEICHNUNG, TLAGER_SUM.MENGE, TTEILE.MINB,
TLAGER_SUM.TYP, TTEILE.TYP
FROM TTEILE LEFT JOIN TLAGER_SUM ON TTEILE.TEILENR = TLAGER_SUM.TEILENR
WHERE (((TLAGER_SUM.MENGE)<[minb])
>Hello,
>
>the following sql statement is almost done, just one thing is problematic.
>
>In the table tlager_sum I have two types of amounts, one of typ 1, one of typ
>2. I just need the one of typ1. But if the material not in the table listet
>or just für typ 2, and there is a minimum inventory
Hello SET,
first, thank you!
[Minb] should be tteile.minb the minimum inventory amount.
Can you tell me what about the statements before the where conditions? Until
now I dont know about.
Your syntax returns me too many records, some of them has entries in the
table tlager_sum,
Thanks for the reply Carlos. Very little, mostly the software adds and reads
records, very few are updated. No were near 2 for the swipe to activate in
the time period. The big issue is that the speed never returns to normal.
Regards
Cornie
Thanks Svein, an ingenious use of distinct and nulls. It worked but not
fully, so if I add this it does, but only because I pass a value from an
external application and that would be '' as an empty parameter, not
. And you're right, :locsearchtype is not necessary. The database
was a 1.5 versi
I think I have it:
SELECT TT.TEILENR, TT.BEZEICHNUNG, LS.MENGE, TT.MINB, LS.TYP, TT.TYP
FROM TTEILE TT
LEFT JOIN TLAGER_SUM LS
ON TT.TEILENR = LS.TEILENR
AND LS.TYP = 1
WHERE TT.TYP=1
AND (LS.MENGE IS NOT NULL
AND LS.MENGE0 and ls.menge is null)
ORDER BY TT.TEILENR;
The and ls
>I think I have it:
>
>SELECT TT.TEILENR, TT.BEZEICHNUNG, LS.MENGE, TT.MINB, LS.TYP, TT.TYP
>FROM TTEILE TT
>LEFT JOIN TLAGER_SUM LS
>ON TT.TEILENR = LS.TEILENR
>AND LS.TYP = 1
>
>WHERE TT.TYP=1
>AND (LS.MENGE IS NOT NULL
>AND LS.MENGEOR TT.MINB>0 and ls.menge is null)
>ORDER BY TT.TEILENR;
>
>T
Set, many thanks for your kind support :)
Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 28. August 2014 15:33
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] Difficult condiion question
>I think I have it:
>
>
On Thu, 28 Aug 2014 14:29:31 +0200, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
> (by the way, I don't understand [minb], is that
> some kind of parameter?).
As the OP talks about Access, I assume that is the SQL Server and Access
identifier quoting.
M
Hello,
any attempt to do a search ends with the screen
Oops!
Polls feature not enabled
for some reason, so I have to ask directly:
Is it correct, that a commit is required after some contraints have been
removed, before I can do some data changes which would violate those
constraints?
Hello Patrick,
Yes, that is correct, meta data changes need to be committed as well.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
From: mailto:firebir
Hello Martijn,
thank you very much for the quick response.
Best regards,
Patrick
If you can read Spanish, here is an article about encryption, read also the
related articles:
http://firebird21.wordpress.com/2014/08/28/encriptando-columnas-de-una-tabla/
Greetings.
Walter.
On Thu, Aug 28, 2014 at 7:26 AM, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
>
>
>
On 28-8-2014 18:02, patrick_mar...@yahoo.com [firebird-support] wrote:
> Hello,
>
> any attempt to do a search ends with the screen
>
> Oops!
> Polls feature not enabled
Looks like you are talking about the Yahoo groups web interface. It is
simply bad, and it seems to be getting progressively wor
Problem and solution confirmed. Thanks to all helpers.
30 matches
Mail list logo