Subject | RE: [firebird-support] Stored Proc to act like the string.Copy method in Delphi |
---|---|
Author | Martin Dew |
Post date | 2005-07-05T13:56:34Z |
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
Alan
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
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
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 neverin
> 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
> it increases;I wonder if it's just a corrupt copy of the dll? on the PC in question
>
Alan
>before
>
> /* 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
> it, so this is the value you would */find
>
> /* 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
> with the other sites with no problem is the line containing the f_MID.maybe
>
>
>
> 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
> I would need a copy of the freeUDFLib.dll which has been compiled withmy
> the $Define FREE_IT uncommented, I cannot seem to get that to work in
> 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]