Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFPCOM within VFP COM Server????
Message
De
25/05/2005 11:28:28
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01017514
Message ID:
01017538
Vues:
26
>I can see some people have been having problems with something that I would like to do. These are the steps:
>1. Use a VFP MTDLL COM object as the database engine for my ASP web application (not asp.net, just classic asp).
>2. Call the COM object from my ASP app and have it do the database i/o, ultimately producting a VFP cursor, which may be the end result of several subqueries, etc.
>3. Convert the cursor to an ADO recordset with minimal overhead
>4. Pass the recordset reference back to the ASP application
>
>CursorAdapter does not go in this direction. Only RStoCursor. So what's the best way to do this? Thanks very much!

Check SetResultSet in VFP9.
Also ASP can use ADO directly if you save resulting data to a temp table and return its name. With this approach you might even get more complex structures like hierarchical recordsets which CursorToRS and RSToCursor cannot handle - maybe updated version does, I don't know- (saving few related resultsets into temp tables). XML of course is an option but would be slower IMHO.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform