Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SEEK
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: SEEK
Divers
Thread ID:
00550599
Message ID:
00550603
Vues:
16
Try this:

'FEE' $ ENTRYDESCR

From the VFP7 help for $: Returns True (.T.) if a character expression is contained in another character expression; otherwise, returns False (.F.).





>I have a table that may have any where from 1000 records to 20,000 recirds in it on a daily basis. I have to set up a process to get some data out into another table. I have done this a thousand times. This is what I do:
>
>
>SCAN
>
> DO CASE
>
> CASE LEN(alltrim(newtranrt)) != 9
>
> SCATTER MEMVAR
> INSERT INTO collections FROM MEMVAR
> USE IN collections
> SELECT risdata_temp
> DELETE NEXT 1
>
> CASE ALLTRIM(newtranrt) = '999999999'
>
> SCATTER MEMVAR
> INSERT INTO collections FROM MEMVAR
> USE IN collections
> SELECT risdata_temp
> DELETE NEXT 1
>endscan
>
>
>This is really longer but I dind't want to bore you.
>
>I have a situation where I need to look at a part of a field. The field wil contain something like "MERCH FEES", or "FEE" or "BANK FEE." They all contain the word "FEE" in it somewhere. I am not sure how to do something like this and it work properly:
>
>
>CASE amount<= 50.00 and NOT EMPTY(newmid) and ENTRYDESCR='FEE'
>
>I am thinking this will fail because of the ENTRYDESCR='FEE' part. The field will really have the whole phrase in it. This works fine with a "SEEK" though.
>
>Any ideas?
>
>Thanks for your help in advance.
Rip Ryness
International Falls, MN
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform