Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What the heck am I doing wrong?
Message
From
17/03/2012 11:21:43
 
 
To
16/03/2012 19:36:37
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01538551
Message ID:
01538560
Views:
68
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform