Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Day two with Active VFP
Message
 
À
09/11/2003 12:49:30
Information générale
Forum:
Visual FoxPro
Catégorie:
ActiveVFP
Divers
Thread ID:
00848074
Message ID:
00848091
Vues:
15
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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform