Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPCOM within VFP COM Server????
Message
From
25/05/2005 11:28:28
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01017514
Message ID:
01017538
Views:
25
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform