On Wed, Jan 21, 2015 at 11:04 PM, Stephen Russell srussell...@gmail.com wrote:
Resist the URGE to put a UDF() into all SQL statements.
I am taking out Rtrim(LTrim( st.item )) = Rtrim(LTrim(tp.item)) now just
st.item = tp.item in queries that drops my time fro 7 seconds to .1 second
on
Bad idea, Your Honor! :)
But thank you for pointing this out!
On Wed, Jan 21, 2015 at 1:34 AM, Richard Kaye rk...@invaluable.com wrote:
It can if you use a VFP UDF.
--
.~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\
The same problem could happen to using a UDF in LOOKUP()?
On Wed, Jan 21, 2015 at 6:12 PM, Man-wai Chang chan...@gmail.com wrote:
Just don't do DBF read/write when using a UDF in a SQL statement, at
least, not without opening the table using another alias.
--
.~. Might, Courage, Vision.
Just don't do DBF read/write when using a UDF in a SQL statement, at
least, not without opening the table using another alias.
On Wed, Jan 21, 2015 at 1:49 AM, Allen pro...@gatwicksoftware.com wrote:
Doing away with a UDF for this case was what I was after. I'm not anti UDF.
I do use them
On Wed, Jan 21, 2015 at 4:14 AM, Man-wai Chang chan...@gmail.com wrote:
The same problem could happen to using a UDF in LOOKUP()?
-
Resist the URGE to put a UDF() into all SQL statements.
I am taking out Rtrim(LTrim( st.item )) = Rtrim(LTrim(tp.item)) now just
st.item =
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen
Sent: 20 January 2015 14:01
To: profox@leafe.com
Subject: using select in a case
Hi Foxgang
I have a need in a case to read a field and select case depending on the result.
Normally I would just make a UDF
...@leafe.com] On Behalf Of Jean
MAURICE
Sent: 20 January 2015 15:19
To: profoxt...@leafe.com
Subject: Re: using select in a case
from where ? when ? train number ?!!? ;-)
Jean à Grenoble
---
This email is free from viruses and malware because avast! Antivirus
protection is active.
http
Lamballe, 26/01 15:21 to Montparnasse train 8646
Back 28/1 19:06 train 8665
Al
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean
MAURICE
Sent: 20 January 2015 15:19
To: profoxt...@leafe.com
Subject: Re: using select in a case
from where ? when
Tracy,
you are right : lookup moves the record pointer. There is a parameter in
INDEXSEEK to say 'no move of record pointer'.
LOOKUP returns a field value; INDEXSEEK a logical
The Foxil
Le 20/01/2015 15:55, Tracy Pearson a écrit :
Dave,
I don't think I've ever used the LOOKUP() function.
] On Behalf Of Dave
Crozier
Sent: 20 January 2015 15:58
To: profoxt...@leafe.com
Subject: RE: using select in a case
Tracy,
Yes it does say that but must admit I used it before I noticed that and it
always performed faultlessly. Either I was lucky or the doc may be
incomplete.
Dave
---
This email
Never too old to learn but often too old to remember!
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Allen
Sent: 20 January 2015 14:35
To: profox@leafe.com
Subject: RE: using select in a case
Yes Dave, a long list of Case in this instance. I do use
Hi Foxgang
I have a need in a case to read a field and select case depending on the
result.
Normally I would just make a UDF and locate and return the field value.
I am wondering though if there is a simple way avoiding extra methods.
Example
Case GetVal(2) = 6
Function GetVal
LParameters
Hi Allen,
I think that LOOKUP() can solve your issue ...
The Foxil
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list:
, January 20, 2015 9:12 AM
To: profoxt...@leafe.com
Subject: RE: using select in a case
I agree with Jean,
Lookup() doesn't move the record pointer. In fact I have used it in a sql
statement to define a field using icase(). That may well be the way to
accomplish what you are doing - or is the reason
: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave
Crozier
Sent: 20 January 2015 15:12
To: profoxt...@leafe.com
Subject: RE: using select in a case
I agree with Jean,
Lookup() doesn't move the record pointer. In fact I have used it in a sql
statement to define a field using icase(). That may
Dave Crozier wrote on 2015-01-20:
I agree with Jean,
Lookup() doesn't move the record pointer. In fact I have used it in a sql
statement to define a field using icase(). That may well be the way to
accomplish what you are doing - or is the reason you need the case because
you are involved in
Thanks Jean Maurice
Al
PS I will be taking to your favourite transport next week. Train to Paris
and back.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean
MAURICE
Sent: 20 January 2015 15:10
To: profoxt...@leafe.com
Subject: Re: using select
from where ? when ? train number ?!!? ;-)
Jean à Grenoble
Le 20/01/2015 15:12, Allen a écrit :
Thanks Jean Maurice
Al
PS I will be taking to your favourite transport next week. Train to Paris
and back.
___
Post Messages to: ProFox@leafe.com
Aint that the truth.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave
Crozier
Sent: 20 January 2015 15:37
To: profoxt...@leafe.com
Subject: RE: using select in a case
Never too old to learn but often too old to remember!
Dave
---
This email
On Tue, Jan 20, 2015 at 8:00 AM, Allen pro...@gatwicksoftware.com wrote:
Hi Foxgang
I have a need in a case to read a field and select case depending on the
result.
Normally I would just make a UDF and locate and return the field value.
I am wondering though if there is a simple way
To: profox@leafe.com
Subject: RE: using select in a case
Dave Crozier wrote on 2015-01-20:
I agree with Jean,
Lookup() doesn't move the record pointer. In fact I have used it in a
sql
statement to define a field using icase(). That may well be the way to
accomplish what you are doing
A SQL SELECT also doesn't move the record pointer... :)
On Tue, Jan 20, 2015 at 10:09 PM, Jean MAURICE jsm.maur...@wanadoo.fr wrote:
I think that LOOKUP() can solve your issue ...
--
.~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\
It can if you use a VFP UDF.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai
Chang
Sent: Tuesday, January 20, 2015 12:20 PM
To: profoxt...@leafe.com
Subject: Re: using select in a case
A SQL SELECT also doesn't move the record
I didn't say you should use a UDF; I said you can use a UDF.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen
Sent: Tuesday, January 20, 2015 12:50 PM
To: profoxt...@leafe.com
Subject: RE: using select in a case
Doing away with a UDF
with pure VFP.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of AndyHC
Sent: Tuesday, January 20, 2015 12:44 PM
To: profoxt...@leafe.com
Subject: Re: using select in a case
Can you use a UDF in a *SQL* select statement?
On 20/01/2015 23:04
January 2015 18:34
To: profoxt...@leafe.com
Subject: RE: using select in a case
It can if you use a VFP UDF.
---
This email is free from viruses and malware because avast! Antivirus protection
is active.
http://www.avast.com
___
Post Messages to: ProFox
...@leafe.com
Subject: Re: using select in a case
A SQL SELECT also doesn't move the record pointer... :)
On Tue, Jan 20, 2015 at 10:09 PM, Jean MAURICE jsm.maur...@wanadoo.fr wrote:
I think that LOOKUP() can solve your issue ...
--
.~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10
27 matches
Mail list logo