HOW TO CREATE A DROP DOWN LIST IN BROWSER taking data from A Dbf

Topics: Developer Forum, User Forum
Aug 29 at 11:22 AM
This is my first time in Activevfp . I required to Develop a report which required from user to Choose Some Option from a drop down List; and data in drop down list will be taken from a dbf which is store on server.

How it can be created.

Thanks in advance.
Coordinator
Aug 29 at 3:12 PM
The best approach is start with the sample and look at the documentation:
HtmlDropdown - create an HTML dropdown list from the currently open table.
Syntax:
 oHTML.HtmlDropDown(cKeyValue,cDisplay,cFormVar,cFirstItem,cSelectedVal,lComplete)
Returns:
 String with HTML dropdown list containing the records of the open table.
Parameters:
 cKeyValue - value that is passed when the record is chosen.  For example, a product code. 
 cDisplay - value that is displayed in the dropdown list
 cFormVar - name of the dropdown variable that is passed when the form is submitted
 cFirstItem - first item that is seen.  For example, 'Select a State'.
 cSelectedVal - name of variable that matches key value and will be the selected value 
 lComplete - if true, include the <select> </select> tags, otherwise do not. 
Example:
 oSession.VALUE("cStates",oHTML.HTMLdropDown('tCursor.stateid',;
 'tCursor.statename','region','Select State/Region',oSession.VALUE("region"),.F.))
Aug 29 at 4:15 PM
Hi,

I try many time to make the .AVFP extention to work at root of my web site.
I run IIS 8.5 on my own server 2012r2.

I can't run script other than the one in the virtual folder. Is it normal or it's a setup issue?

Who can tell me how to setup that correctly?