B v2.5 I don't know.
Now that I know they exist I can probably live with them until
I migrate this application to FB3 (although that will probably
a long while).
Thanks for your time and patience, Adriano.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
t block line: 6, col: 3
What is required to get this example to work?
In both FB2.5.6 and FB3 (under Windows) I get:
"Only INSERT commands are accepted in bulk mode"
(Any example that would let me run EXECUTE BLOCK with a
parameter in isql would help.)
--
Geoff Worboys
Telesis Comput
Affects Versions: 2.5.6
Reporter: Geoff Worboys
Priority: Minor
I've marked this down as a UDF related issue because I don't imagine you should
get invalid DSC from anywhere else.
If a UDF returns an invalid result "by descriptor" (an invalid DSC) then it is
Issue Type: Bug
Components: Charsets/Collation
Affects Versions: 2.5.6
Environment: Windows 10, 32bit Firebird
Reporter: Geoff Worboys
EXECUTE BLOCK (
"Param1" VARCHAR(80) CHARACTER SET WIN1252 = :"Param1"
) RETURNS (
Adriano dos Santos Fernandes wrote:
> On 22/07/2016 08:38, Geoff Worboys wrote:
>> the other regarding EXECUTE BLOCK parameters:
> You did not put full test case here, so I do not know what
> you mean.
> Of course, parameters are converted to client charset, even
> if they u
Issue Type: Improvement
Components: UDF
Affects Versions: 2.5.6
Environment: Windows 10, Delphi 10.1, 32bit build
Reporter: Geoff Worboys
Priority: Minor
Using "by descriptor" parameters a UDF can read the character set of a string
input
Adriano dos Santos Fernandes wrote:
> On 22/07/2016 02:49, Geoff Worboys wrote:
>>
>> Is this expected behaviour?
> No, I think. ttype_dynamic should not escape from the engine.
Okay, I'll raise a tracker item for it.
...
I'm wondering if there might be two issues items
derstand the last
example but the EXECUTE BLOCK example seems wrong.)
ttype_dynamic is not all that useful inside a UDF, because it
has no way to find out what the relevant attachment character
actually set was.
--
Geoff Worboys
Telesis Computing Pty Ltd
way or another (even if, in many cases,
the "localisation" has been only to localise programmer-speak
into English ;-). Internalising that capability would be a
nice thing to see and could offer other benefits as well, like
being able to rename any object at any time without impact to
the st
Adriano dos Santos Fernandes wrote:
> Em 03/06/2016 23:30, Geoff Worboys escreveu:
>> Can I suggest then, that you implement a database option and/or
>> a server option that controls the acceptance of long metadata
>> names. Databases could upgrade with the option set
Adriano dos Santos Fernandes wrote:
> On 03/06/2016 10:35, Geoff Worboys wrote:
>> This is not a request, I am just asking whether the option
>> has been considered as a way of maintaining backward
>> compatibility.
> Not considered nor will.
> No reason to introdu
atibility.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming
Dimitry Sibiryakov wrote:
> 04.01.2016 15:49, Geoff Worboys wrote:
>> Which leaves me trying to work out how to determine whether I can
>> ignore a callback or not. Is there a reliable way to do this so
>> that I don't signal an event when there hasn't actually been one?
ork out
what it buys first and then decide whether it is worth the
possible cost.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
collations for sorting and
indexing, and UDFs for calculations). Obviously not as fast
as have CPU support for such decimal numbers, but still not
bad.
--
Geoff Worboys
Telesis Computing Pty Ltd
Jim Starkey wrote:
> The original Interbase implementation had rational, aka reasonable,
> arit
to make it.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
James Starkey wrote:
Once it was belived that nobody could get fired for going IBM
(SNA anyone? Anyone?).
I worked with SNA / SDLC for some years. I don't remember
anyone getting fired for choosing it.
--
Geoff Worboys
Telesis Computing Pty Ltd
robust security impossible, however, it is a
feature that can be convenient - even if only for testing and
development purposes.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Firebird-Devel mailing list, web interface
and FPC.
provide both Delphi and FreePascal support in example code will
need to take care to use specific types, like UTF8String rather
than just String. And PAnsiChar and AnsiChar for the string
elements.
--
Geoff Worboys
Telesis Computing Pty Ltd
for the string
elements.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
requirement to do this should be looked
on with suspicion.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership
Alex Peshkoff wrote:
On 02/07/15 03:20, Geoff Worboys wrote:
Simple? Well, I guess it is if I don't have any care about
security. But context variables are not the way to do this
sort of thing, load on demand from a secured table is a less
open way of dealing with such private data
is not a problem to me).
P.S. Thanks Alex for your input into this.
--
Geoff Worboys
Telesis Computing Pty Ltd
liviusliv...@poczta.onet.pl wrote:
Hi,
This is simple
Store your user, password and role in context variable and
use it in execute statement
Regards,
Karol Bieniaszewski
- Reply
Vlad Khorsun wrote:
05.02.2015 14:36, Geoff Worboys wrote:
Hi,
Firebird v2.5.3
I've been studying the source trying to understand the reasons
behind a particular aspect of EXECUTE STATEMENT with ON EXTERNAL.
Specifically, why are USER PASSWORD and ROLE tied together here?
Why do you
Alex Peshkoff wrote:
On 05.02.2015 15:36, Geoff Worboys wrote:
Hi,
Firebird v2.5.3
I've been studying the source trying to understand the reasons
behind a particular aspect of EXECUTE STATEMENT with ON EXTERNAL.
Specifically, why are USER PASSWORD and ROLE tied together here?
I had
(will be tomorrow now), I
find out.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub
forces the names to
lower-case when doing the actual file search/load or whatever?
It's a simple rule - and I seem to remember it being a fairly
common recommendation for various types of project in the past.
--
Geoff Worboys
Telesis Computing Pty Ltd
).
Any hints would be greatly appreciated.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile
Dmitry Yemanov wrote:
16.10.2014 14:55, Geoff Worboys wrote:
I've cut the problem down to the thing that's giving me
trouble: I want to return a non-null value when when the
input expression resolves to null. In the code below I'm
just trying to return a 0 (for the sake of the example
of the database that
they access from a Firebird server running on their own
machine) from extracting the source code.
[Cutting this short, because Jim has already covered the
point I was going to make about replacing the server to
extract the data and/or keys.]
--
Geoff Worboys
Telesis
encryption added to Firebird
to do it. But I can't protect myself from my customer unless
I keep control of the server. If redsoft have done it, I'd
be interested to hear how.
--
Geoff Worboys
Telesis Computing Pty Ltd
complex solution than necessary or
appropriate for the requirement.
But whether this has to be done for v3.0 is another matter,
although I can see the attraction of having the replacement
syntax in place now, so that the old update can also be marked
as deprecated now.
--
Geoff Worboys
Telesis
) I think
that option 4 (Leave the rdb$procedures and rdb$triggers
writable (or at list the source field)) is the best fit
at this time.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Slashdot TV.
Video for Nerds. Stuff
Dimitry Sibiryakov wrote:
01.09.2014 16:01, Geoff Worboys wrote:
At this late stage of v3.0, it seems to me that simple and
least possible change (to v3 and to the developer) should
be high on the list of priorities. More sophisticated
options could be assessed in detail later.
Exactly
is obviously in addition to that
interception (along with key management etc.) - hence my
assumption that it will take more code.
If you can explain to me how it can take less code to do
encryption, decryption and key management, than to write
null to the source field the I am willing be educated.
--
Geoff
their database for distribution,
or when they login to apply updates to a customer database,
they make sure to set this option in their connection string
and away they go.
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Slashdot
gives more time to discuss the best way forward for
Firebird - without implementing official DDL or other mechanism
that we may have reason to regret/deprecate in the near future.
--
Geoff Worboys
Telesis Computing Pty Ltd
the source, but really the
only better solution is UDR, and developers need significant
time to migrate. So if you want projects to stay current, you
need to give them a changeover period to move to the better
solution.
--
Geoff Worboys
Telesis Computing Pty Ltd
Adriano dos Santos Fernandes wrote:
On 31-08-2014 12:06, Geoff Worboys wrote:
I'd like to argue that developers have already had years to
find a better solution than deleting the source, but really the
only better solution is UDR, and developers need significant
time to migrate. So if you
a metadata extract feature, what was the
point of that if we expected users to always have copies of
the source they used to create the database? ;-)
--
Geoff Worboys
Telesis Computing Pty Ltd
--
Slashdot TV.
Video for Nerds
|| !d d2 0)
{
internal::setnull(rc);
internal::set_int_type(rce, 1);
return;
}
Something like this could make UDFs more powerful and error
situations easier to deal with.
--
Geoff Worboys
Telesis Computing Pty Ltd
Adriano dos Santos Fernandes wrote:
On 28/04/2011 08:20, Geoff Worboys wrote:
...
While on this sort of subject are you able to offer any
information about what happens to API text such as SQL
statements and the like) sent to the server? (And details
like relation names etc returned
?
--
Geoff Worboys
Telesis Computing
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today. Delivers lowest initial
release notes, but without any
explanation of its purpose. Is that because it's always been
there and just never documented? (Else, do you know when it
arrived - which version of FB?)
Thanks for your help.
--
Geoff Worboys
Telesis Computing
of NONE.
Thanks again.
--
Geoff Worboys
Telesis Computing
--
WhatsUp Gold - Download Free Network Management Software
The most intuitive, comprehensive, and cost-effective network
management toolset available today
Dimitry Sibiryakov wrote:
13.04.2011 11:45, Geoff Worboys wrote:
More seriously. Yes I know there are important security
considerations BUT I thought perhaps people were overlooking
what I see as the biggest potential advantage of the request.
Just because it is a risk does not take away
46 matches
Mail list logo