Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What the heck am I doing wrong?
Message
De
17/03/2012 11:21:43
 
 
À
16/03/2012 19:36:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01538551
Message ID:
01538560
Vues:
67
>Hey folks...
>
> This should be stupid simple, but I seem to be just stupid...
>
> I have a list box on a Form Tab with a Row Source Type of "Array" and the Row Source of the array "ThisFormSet.so_FS.sa_Images".
>
> On the record selection, I want to fill it in with the results from a SQL Select:
>
> SELECT PADR(JUSTSTEM(imgfile), 25) AS stem, imgfile FROM a_arcimg WHERE custno = a_arcust.custno INTO ARRAY laImages
> IF _TALLY > 0
> = ACOPY(laImages, ThisFormSet.so_FS.sa_Images)
> ELSE
> .sa_images[1] = ""
> ENDIF
>
> ThisFormSet.frmCustomer.CntpgfCustomer.PgfMain.page9.CntTaxCert.LstImages.Refresh()
>
> When I do this, I only get results from ONE record, even though the array has all of the information for all records. Why don't I get more?
>
> Thanks in advance!

ACOPY() can to do trouble.
try
SELECT PADR(JUSTSTEM(imgfile), 25) AS stem, imgfile FROM a_arcimg WHERE custno = a_arcust.custno INTO ARRAY .sa_Images
IF _TALLY = 0
DIMENSION  .sa_images[1]
.sa_images[1] = ""
ENDIF
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform