Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPCom not working
Message
From
08/02/2005 14:39:07
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
08/02/2005 12:53:37
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00984783
Message ID:
00984853
Views:
21
IIRC, the current VFPCOM came out after the initial release of VFP8, so maybe they are still working on the VFP9 version. Will CursorAdapter do what you want? I know it can work with ADO, but I'm not sure if it will create a recordset from a cursor. If not, there used to be a DBF2RS.prg floating around that you might be able to find.

>Hi,
>
>I have a vfp com object (accessed from an asp page) that I am changing from vfp 7 to vfp 9 (to add new features).
>
>In numerous places I take a cursor and convert it to a recordset and then return the recordset. Like the following:
>
>	SELECT * FROM student WHERE istudentid=813 INTO CURSOR _S
>	Local oRecordset, oVFP
>
>	oRecordset = Createobject("ADODB.RecordSet")
>	oVFP = Createobject("vfpcom.comutil")
>	oVFP.CursorToRS(oRecordset, "_S")
>	Release oVFP
>	Close Databases All
>
>	Return oRecordset
>
>When the COM object is compiled in vfp 7 it works. When it is compiled in vfp9 it doesn't; the asp page will just hang and the line in the vfp com object that it gets stuck on is
>
>   oVFP = Createobject("vfpcom.comutil")
>
>The function works when compiled into vfp 7 and when I run it from the command window in vfp9, but when an asp page is accessing it, it just hangs.
>
>I have downloaded and installed the newest version of vfpcom.dll from microsoft (says for vfp 8).
>
>
>Is the vfpcom not supported in vfp9?
>Is it because I have windows service pack 2?
>
>Any assistance would be appreciated.
>
>Thanks,
>Malonep
>
>(not sure if I put it in the correct category - the first time)
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Previous
Reply
Map
View

Click here to load this message in the networking platform