Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relation
Message
De
04/07/2003 04:32:16
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00806659
Message ID:
00806885
Vues:
17
>I have 11 records with "CCDV801" but SCAN only
>gets 1.

Is 'CCDV801' (model) the parent's ID or it's another field in child ?
Select solutions
Set Textmerge To mytext.html  Noshow &&additive
Set Textmerge On
*seek parentTable.PkIDField
Scan While parentIDField = parentTable.PkIDField For Alltrim(solutions.model) = "CCDV801"
  \<p><<model>></p>

  If !Empty(subj)
    \<p><b><<subj>></b></p>
  Endif

  For ix=1 To 10
    luValue = Evaluate('L'+Ltrim(Str(ix))
    If !Empty(luValue)
	  \<p><<luValue>></p>
    Endif
  Endfor
Endscan
Set Textmerge To
Set Textmerge Off
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform