Subject RE: [firebird-support] Stored Proc to act like the string.Copy method in Delphi
Author Martin Dew
Good thinking, however I have retried copying the dll by stopping FB,
overwriting it and restesting, still happens.



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alan McDonald
Sent: 05 July 2005 14:08
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Stored Proc to act like the string.Copy
method in Delphi



> >>and you're sure its the F_MID UDF? I've used it for years and never
> struck
> >>memory leaks from it.
> >>Alan
>
>
>
> Almost 100% sure, if we comment the following lines out of a stored
> proc, and then run it the memory does not increase, if we leave them
in
> it increases;
>

I wonder if it's just a corrupt copy of the dll? on the PC in question
Alan


>
>
> /* Convert the incoming status to one of our own for display
> purposes.*/
>
> alocation = F_LEFT(:V3_LOCATION,1);
>
>
>
> blocation = F_MID(:v3_location,2,5);
>
> blocation = F_RTRIM(:blocation);
>
>
>
> /* blocation holds the location without the c_ or b_ identifier
before
> it, so this is the value you would */
>
> /* post into either the desp_car or desp_base field according to
> whether alocation is a b or a c */
>
>
>
> We have this stored proc at other sites, the only difference we can
find
> with the other sites with no problem is the line containing the f_MID.
>
>
>
> We have tried using all 3 of the Functions mentioned declared with and
> without FREE_IT, so my guess is that this is having no effect, and
maybe
> I would need a copy of the freeUDFLib.dll which has been compiled with
> the $Define FREE_IT uncommented, I cannot seem to get that to work in
my
> Delphi environment.
>
>
>
> Regards
> Martin
>




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





SPONSORED LINKS

Technical support
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+supp
ort&w2=Computer+security&w3=Computer+technical+support&w4=Computer+train
ing&w5=Free+computer+technical+support&c=5&s=138&.sig=77sbeaNS_CB99ND1Np
Q02w>

Computer security
<http://groups.yahoo.com/gads?t=ms&k=Computer+security&w1=Technical+supp
ort&w2=Computer+security&w3=Computer+technical+support&w4=Computer+train
ing&w5=Free+computer+technical+support&c=5&s=138&.sig=h-vpfglcVDyMom6ZGR
j-AA>

Computer technical support
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Techn
ical+support&w2=Computer+security&w3=Computer+technical+support&w4=Compu
ter+training&w5=Free+computer+technical+support&c=5&s=138&.sig=0PtYe-giI
Cy1KkECNuG2EA>

Computer training
<http://groups.yahoo.com/gads?t=ms&k=Computer+training&w1=Technical+supp
ort&w2=Computer+security&w3=Computer+technical+support&w4=Computer+train
ing&w5=Free+computer+technical+support&c=5&s=138&.sig=psUjUcHSklN7Uvu_cJ
ch-g>

Free computer technical support
<http://groups.yahoo.com/gads?t=ms&k=Free+computer+technical+support&w1=
Technical+support&w2=Computer+security&w3=Computer+technical+support&w4=
Computer+training&w5=Free+computer+technical+support&c=5&s=138&.sig=isTc
tikpuewr3b607bkoUA>





________________________________

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



________________________________



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