Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Text and endtext (2)
Message
From
01/11/2005 15:56:45
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01064109
Message ID:
01064190
Views:
29
You can't set the RowSource with [;] in string
try this:
TEXT TO cValue NOSHOW TEXTMERGE PRETEXT 15
   SELECT T.Cnomteleph , T.iid
          FROM TELEPH T WHERE T.iid IN
                             (SELECT iTelephoneid FROM cfiltre WHERE lactif = .T. AND ireport = <<goapp.noReport>>)
          GROUP BY 1 , 2
  INTO CURSOR cNames
ENDTEXT
THIS.listEmployee.ROWSOURCE = cValue
THIS.listEmployee.REQUERY()
Is goapp.noReport is numeric? If so you didn't need TRANSFORM(), if it is String you need this
ireport = '<<goapp.noReport>>') 
in TEXT...ENDTEXT block.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform