Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VPM integrate with FOXFIRE
Message
From
14/10/2006 02:47:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
VPM integrate with FOXFIRE
Environment versions
Visual FoxPro:
FoxPro Windows
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01161969
Message ID:
01161969
Views:
64
Hi,
anyone have try to integrate with FOXFIRE report by using VPM9.0??
i have no problem to using foxpro9 to integrate but not in VPM.

Here is my code (which is work in foxpro)
PRIVATE pcrptmodule
LOCAL lcselect, lcwaslib

tcnmprefset="GLO"
lcselect=SELECT()

IF USED("ffprefer")
   USE IN ffprefer   
ENDIF

SELECT 0
CREATE CURSOR ff_batch ( ;
   REQUEST C(8), ;
   ACTION C(40), ;
   USER_ID C(4), ;
   USER_DEPT C(10), ;
   CONFIG M(10), ;
   TIMEOUT N(4), ;
   MACROOK L(1), ;
   NOPRTPRMPT L(1), ;
   FLTSTRALS M(10), ;
   FLTTITLE M(10), ;
   FLTARRAYS M(10), ;
   FLTDISPLAY M(10), ;
   SENDTO C(10) ,;
   OUTPUTFILE M(10), ;
   DOSPRTR M(10) ,;
   WINPRTR1 M(10) ,;
   WINPRTR2 M(10) ,;
   MACPRTR M(10) ,;
   ASKATRUN M(10) ,;
   HEADING M(10) ,;
   FF_FILTER M(10), ;
   FF_FRXNAME M(10), ;
   FF_SQL M(10) ,;
   FF_COUNT N(9) ,;
   SYSTEM M(10) ,;
   ERROR M(10) ,;
   PREFSET C(20), ;
   SERVERFILE M(10), ;
   SERVERNAME M(10),;
   SQLTYPE C(10) ,;
   USE_LOGIN L(1),;
   CONHANDLE N(2))          



APPEND BLANK
REPLACE action WITH "REQUESTS", user_ID WITH "SYSTEM", config WITH 'FFCONFIG', ;
   prefset WITH tcnmprefset, use_login WITH .F. 

IF FILE("FOXFIRE.INI")
   IF FILE("FFBACK.INI")
      ERASE FFBACK.INI
   ENDIF
   RENAME FOXFIRE.INI TO FFBACK.INI
ENDIF
LOCAL lnFile
lnFile=FCREATE("FOXFIRE.INI")
=FWRITE(lnFile,tcnmprefset)
=FCLOSE(lnFile)


DO ("FOXFIRE")

IF FILE("FOXFIRE.INI")
   ERASE FOXFIRE.INI
   IF FILE("FFBACK.INI")
      RENAME FFBACK.INI TO FOXFIRE.INI
   ENDIF
ENDIF
IF USED('FF_BATCH')
   USE IN ff_batch
ENDIF

SELECT (lcselect)    

RETURN
When i run the above code on VPM. It prompt me FFActiveX.cLibrary (ffdefCbrReqMgr.prg) cannot be found (but i have it in folder). When I click ignore, it prompt me Please specify a valid library name for FFActiveX.cLibrary and etc..


Anyone please help because is urgent..
thank you very much.

regards,
darren
Reply
Map
View

Click here to load this message in the networking platform