Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Picklist Procedure to accept relations
Message
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00002211
Message ID:
00002215
Views:
37
Chaya

Notice in the example the use of mixed quoutes. You really have " ' ' ". He is putting a space between the fields. You may want "Client.name + car.carmake".

Hope this helps
Tom


>I downloaded this procedure from one of Mr. Guerra
>websites and I would
>like to know if there anyway to edit the following
>procedure to accept
>database relations properly? For example the
>table fields would be
>Client.name + car.carmake.
>
>I am running it under FPW2.5.
>*Use to quickly select records (PICKLIST)
>* Example: DO picklist WITH 3,34,"Name+'
>'+Number","Pick a Customer"
>* Name and Number being table fields
>PROCEDURE picklist
>PARAMETERS toprow,topcol,flds,tit
>IF RECCOUNT() > 0
> botcol=topcol+LEN(&flds)+1
> flds="fields "+flds
> DEFINE POPUP picklist FROM toprow,topcol PROMPT
>&flds TITLE (tit)
>SHADOW
> ON SELECTION POPUP picklist DEACTIVATE POPUP
>picklist
> tconf=IIF(SET('confirm')='
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform