Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dotnetpro database performance contest
Message
De
13/05/2007 05:01:54
 
 
À
12/05/2007 15:44:53
Markus Winhard
Lauton Software GmbH
Nürnberg, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
VFP Compiler for .NET
Divers
Thread ID:
01224231
Message ID:
01225043
Vues:
17
Hi Markus
>
>>You did not mention if the data found in the example allows switching over to checking for the first blank.
>>If the stuff/at combo is faster than strtran(), depending on the possible values of vorname this should
>>give you another few millisecs.
>
>I'm not sure what exactly you're talking of here.
SELECT Table2
SCAN
	#if .t.
        *** if StrTran(VorName, " ", "")==Rtrim(Vorname) in table1 you don't need to work via RAT
        *** But table1.Strasse has Spaces Embedded 
	lcStrasse = RTRIM( Strasse )
	
	FPUTS( m.lnFHandle, ;
	    STUFF( RTRIM( Name ), AT( " ", Name ), 1, ", " ) +", "+ ;
	    STUFF( m.lcStrasse, RAT( " ", m.lcStrasse ), 1, ", " ) +", "+ ;
	    STUFF( RTRIM( Ort ), AT( " ", Ort ), 1, ", " ) +", "+ ;
	    RTRIM( eMail ) )
	#else
	lcName = RTRIM( Name )
	lcStrasse = RTRIM( Strasse )
	
	FPUTS( m.lnFHandle, ;
	    STUFF( m.lcName, RAT( " ", m.lcName ), 1, ", " ) +", "+ ;
	    STUFF( m.lcStrasse, RAT( " ", m.lcStrasse ), 1, ", " ) +", "+ ;
	    STUFF( RTRIM( Ort ), AT( " ", Ort ), 1, ", " ) +", "+ ;
	    RTRIM( eMail ) )
	#endif
ENDSCAN
FCLOSE( m.lnFHandle )
thomas
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform