Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Day two with Active VFP
Message
 
To
09/11/2003 12:49:30
General information
Forum:
Visual FoxPro
Category:
ActiveVFP
Miscellaneous
Thread ID:
00848074
Message ID:
00848091
Views:
14
If you want to do this all in an HTML page, then check out:
http://www.activevfp.com/avfpdemo2/Default.asp?action=showcode (the VFP Script example). Look specifically where the SQL query is run with:
SELECT * FROM customer &lcWhere ;
INTO Cursor tCursor ;
ORDER BY Company
and then look and see where it outputs the results on the same page in the SCAN block. For example: tCursor.Address and tCursor.Phone
On the other hand, if you do the SQL statement in the .dll, then you just need to code tCursor.Address and tCursor.Phone in the HTML. You will need to recompile the .dll when you make a change in that code whereas you wouldn't if doing this all in the HTML.
BTW, did you create a new project with the WebAppBuilder or are you working with the demo project?
Generally I would recommend looking at main.prg closely and the corresponding HTML template for each CASE statement. The code there is very simple.

>I want to run the SQL and display the results on the same page in IExplorer. This should be very simple to do. But, right now I only know the SQL code and no activeVFP methods. I have been pouring over the documentation provided with your download.
>
>I am trying to do this on a new page that I created in the same directory as the one created when I installed activeVFP
>
>Is there anything else I can provide to help you?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform