How to pass array by reference to VB dll from VFP8.0

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Change process priority I have a VFP 8 EXE and I want the EXE to run with a lower process/thread priority automatically. How do I change the EXE process priority from within the running EXE? M. Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189335
  - 2
    - Regsvr32 (Kernel32.dll) I have read some of this elsewhere on forums in VB. Has anyone seen code that I can declare in VFP to call regsvr32 without having to shell out to register a dll Presently my line of code reads RUN REGSVR32 HASHCTL.DLL / where the switch bypasses a message box helping with security but still shelling out of the present environment. This works smashing otherwise Thanks in advance Charlane Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189331
  - 3
    - Treeview Imagelist Assignment ProblemOLE Dispatch Exception Code 0 Hello: I am working in VFP8, SP1, and trying to add an imagelist OLE object to a form that also has a treeview control on it. When I try to assign the imagelist object to the treeview object, I get the following error message at runtime: OLE IDISPATCH EXCEPTION CODE 0 FROM TREECTL: INVALID OBJECT. The code I'm running, in the INIT method of the treeview control (tvProcessResults.init) is: This.ImageList = ThisForm.oleControl1 I have set up the imagelist OLE object with several 32x32 icon images in the ImageListCtrl Properties menu, and made sure that the INIT on the imagelist control runs *before* the INIT on the treeview. I can't figure out what is wrong here Ideas? Thanks! Steven C Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189330
  - 4
    - VFP7 and VSS - Linked File problems Our dept. manager moved our repository to a newer, faster server (finally!). We have three projects which share a couple of files, and everything seems to be setup properly in VSS. However when we join two of the three projects through VFP all three of the shared files are not copied down to the client - but are still listed in the project. If I go into VSS and do a get on them they do appear in the project manager - but are not shown as being part of Souce Control (no lock icon, just a blank space). No matter what we have tried VFP won't realize those joined files ARE part of the repository. I have updated to the latest client. Unfortunetly the old server has been reformatted so there is nothing to go back to. Nothing has changed on the client machines during the transition from one server to the other - yet the problem has been tossed into the hands of the developers to solve. There is no problem checking out files through the VSS interface, except the text files are not created so we lose the ability to do text-compares between revisions. Losing that audit trail has been declared 'unacceptable' by the dept. manager. Any ideas and thoughts would be greatly apprecaited. Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189329
  - 5
    - CursorFill() as a workaround to Requery() when inside a transaction. This is cool. I have validation code in a stored procedure that wants to REQUERY() a view when I issue a TABLEUPDATE() on a particular table. This is a problem because all of our generic "save changes" code includes wrapping TABLEUPDATE()s in a transaction when more than one table is going to be updated (and Requery() either error's out during a transaction or does nothing at all (depending on what's being requery'd). Changing the view into a cursoradapter allows "requerying" the cursor via the cursoradapter CursorFill() method. -- William Fields MCSD - Microsoft Visual FoxPro MCP - Win2k Pro US Bankruptcy Court Phoenix, AZ "Reality is merely an illusion, albeit a very persistent one." - Albert Einstein Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189328
  - 6
    - using view to delete records I have defined two views. create sql view t_theorder remote connect myconn ; as select * from orders ; where orderid=?m.orderid =dbsetprop("t_theorder","view","sendupdates",.t.) =dbsetprop("t_theorder","view","tables","orders") =dbsetprop("t_theorder.orderid","field","keyfield",.t.) create sql view t_theodetail remote connect myconn ; as select * from "order details" ; where orderid=?m.orderid =dbsetprop("t_theodetail","view","sendupdates",.t.) =dbsetprop("t_theodetail","view","tables","order details") =dbsetprop("t_theodetail.orderid","field","keyfield",.t.) =dbsetprop("t_theodetail.productid","field","keyfield",.t.) I then use the following commands to delete the records: m.orderid=t_orders.orderid select 0 use t_theodetail shared =cursorsetprop("buffering",5,"t_theodetail") delete all if tableupdate(.t.) select 0 use t_theorder shared =cursorsetprop("buffering",5,"t_theorder") delete if !tableupdate(.t.) a_error[1]=.f. =aerror(a_error) =tablerevert(.t.) =messagebox("Error deleting header. "+a_error[2],48) endif else a_error[1]=.f. =aerror(a_error) =tablerevert(.t.) =messagebox("Error deleting detail. "+a_error[2],48) endif if used("t_theorder") use in t_theorder endif if used("t_theodetail") use in t_theodetail endif Then I hit an eror "No Update Tables specified. Use the Tables property of the cursor". I had no idea what I did wrong. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:08pm up 12 days, 23:40, 0 users, load average: 1.15, 1.07, 1.03 Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189311
  - 7
    - keeping precision of number when converting to string If i have a number in a number field (nsalary) say 100.54 and want to convert it to a string to be exported to a text file that is being manually created, and i use str(nsalary) it returns "101" as the string... how do you get the number back as a unrounded number in a string with the same 2 digit precision? thanks! Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189302
  - 8
    - EXE file behaves different than in Design Evnironment I am just starting with Visual Foxpro. I have been a long time CLIPPER developer and trying to switch to VFP to convert my applications from DOS environment to Windows plateform. I started off with a very simple application with one single form containing 4 variables, 4 labels, 4 text boxes and 2 buttons. I set ShowWindow property of the Form to "2 - AS TOP LEVEL FORM". I put the following code in Init and Activate methods of the form Init thisform.addproperty('ReadEventsFlg',.F. cInfile='KKKKKKKK cOutfile='LLLLLLLL dStart=ctod('01/01/2000' dEnd=date( Activate IF !THISFORM.READEVENTSFL READ EVENT THISFORM.READEVENTSFLG=.T ENDI In CONFIG.FPW, I put only one line SCREEN=OFF. The button named GO displays a messagebox showing values of the variables as entered by the user and CANCEL button has following code in CLICK_EVENT clear event thisform.releas When I run the form in Design environment, everything works fine i.e. the initial values of the variables are displayed as initialized in the Init method. However, when I compile an EXE and run it under runtime, it shows all blank values. I tried moving the initialization code of the variables from Init to Activate method. Then it shows the correct value for the first text box and as I click on other boxes, those values also show up correctly. I want the form to show all four values correctly as the form is first displayed. I have playing with it for 3 days now but with no success I would really appreciate help from the experts and make my entry into FOXPRO world a little easier Thanks in advance..... Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189301
  - 9
    - thousands separator in numeric fields via ODBC Hello, when I select data>=1000 from foxpro numeric fields with decimal places I start receiving a comma as a thousands separator. I've looked through the ODBC help but I'm still not sure why this is happening, any ideas? I'd like to have no separator. -- TIA Andrew Howell Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189300
  - 10
    - Check for numerical values How do I verify a string is a numerical value? Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189298
  - 11
    - Beauty OOP report tool for VFP Dowload: English version: www.oopreport.com/ORT5_1033.rar Chinese(Traditional) version: www.oopreport.com/ORT5_1028.rar Chinese(Simplified) version: www.oopreport.com/ORT5_2052.rar More versions... For more pictures,please goto: http://myf1.net/bbs/dispbbs.asp?boardID=1&ID=238989 Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189294
  - 12
    - VFP Toolbar - beyond a joke Whenever the VFP IDE reappears (ie starting VFP, finishing running an app, etc)("etc"?) the normal toolbar puts my docked project onto a separate line from the standard toolbar, and therefore doubles the height of the bar. I spoke about this before (a long time ago) and y'all said no-one else was seeing this. However I've now got the same effect on a different computer, still a laptop but that's about the only similarity, different operating system (XPH) and different hardware. This has to be a bug shirley? I have (only) the standard toolbar showing. There *is* space for the project to be docked onto the same line. What's going wrong? Grrrrr 8-( Mark Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189292
  - 13
    - remote view and identity column of sql server orders ------------- orderid int, identity, primary key I used a view to open orders on sql server as t_orders. I then append blank a record in t_orders and tableupdate(.t.). How could I know the new value of orderid from sql server? If I issue requery("t_orders"), the record pointer would no longer on the newly appended record. I need the new value of orderid to build a new view with order_details. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 5:38pm up 12 days, 18:10, 0 users, load average: 0.99, 0.96, 0.91 Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189288
  - 14
    - quick question on sql Dear All, I have forgot how to do this, counting the number of record for each customer appear in table sales. I make this, select customer, count() as total from sales group by alltrim(customer) The message keep popping up that the statement has missing expression. Please kindly help me out. Many thanks. Regards, Wandy Tang Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189275
  - 15
    - odbc-configure connection dialog box always prompt, why ? Now, I can create my remote view programically (save as create_view.prg) However, everytime I run the create_view.prg, there is a dialog box prompt out , i need to press "OK" , otherwise, the remote cannot be created. It is very troublsome for the user . Can anyone how to solve it ?? Thanks in advance From agnes My code is shown as below. OPEN DATABASE u:\cgl\vfpseafreight\data\transport.dbc IF INDBC("t_data","connection") = .F. CREATE CONNECTION t_data; connstring ; 'Driver={Microsoft Visual Foxpro Driver};DBQ=u:\cgl\vfpseafreight\data\transport.dbc;BackgroundFetch=Yes' ENDIF IF INDBC("tview","VIEW") = .F. CREATE sql VIEW tview remote CONNECTION t_data AS SELECT number,jobno,closesw FROM billLadingHeader order by number ENDIF Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189274
  - 16
    - curdir fullpath When I use curdir() it does not give the full path, is there any way to do this??? Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189262
  - 17
    - Return value I'm using createobject to reference a class object that consists of a form with a text box. If in the unload event of the class, I'm returning a value, how do I grab the value in the parent form? Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189260
  - 18
    - Is ProFox there? Does anyone know if the ProFox list is running? I haven't heard from it for a while. -Lew Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189257
  - 19
    - UNABLE TO ERASE A FILE I have the following situation. I create a text file from a table that meet a certain condition. I'm using the following command. COPY TO ( cOutput ) FOR STORE <> "CA" TYPE SDF IF no records meet the condition then FoxPro creates a file with zero bytes. The problem that I'm having is that I cannot delete this file until I'm completing out of FoxPro. Here's the error that I'm getting. There has been a sharing violation - The source or destination file may be in use. Does anyone know how I go about closing the file so that I can erase it in the program? Thanks Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189256
  - 20
    - Interface of visual foxpro to C++ routines How can I call a C++ routine from vfoxpro? And How is to complie and linkedit the two modules: a main foxpro with a C++ sub I cannot visualize how join the two softwares. Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189254
  - 21
    - Help!!! how do I get an Icon file. I need ico for imagelist. I neet to get 3 icons (word,excel,pdf) as imagefiles so that I can load them in the imagelist for my tree. How can I get to these Icons. I went to word for example and I couldn't fine the icon file. thanks Nick Patel Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189244
  - 22
    - combobox and bounding the view: t_jobs job_desc job_id ------------- ------ manager 4 clerk 5 n/a 3 I want the value of job_id (column 2) while the form will show job_desc (column 1). The combobox is set up as follows: controlsource=thisform.var rowsource=t_jobs rowsourcetype=1. alias boundto = .t. boundcolumn = 2 whenever I click the combobox to select a value, it always become blank. what step did I miss? -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 12:26am up 12 days, 58 min, 0 users, load average: 1.00, 1.01, 1.00 Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189242
  - 23
    - HOW TO CREATE ODBC CONNECTION PROGRAMMICALLY ?? create the connection and view programmically. However, there is an error. Please give me a hand OPEN DATABASE d:\data\account.dbc SET DATABASE TO "account" IF INDBC("acct1","CONNECTION") = .F. Create connection acct1 ; connstring; 'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc'; CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM arinvheader endif Thanks in advance from agnes Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189239
  - 24
    - calling button.click() from form.release()? I am using Visual Foxpro 6.0. When a user clicks the "X" button on a form, the form.release() method would be called. Is it possible to make it run the code in cancel_button.click() event first? I think it's a bad idea to call another event from within another event. Right now I disabled the "X" button. -- .~. Might, Courage, Vision. In Linux We Trust. / v \ http://www.linux-sxs.org /( _ )\ Linux 2.4.22-xfs ^ ^ 11:30pm up 12 days, 2 min, 0 users, load average: 1.00, 1.00, 1.00 Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189236
  - 25
    - Populate combobox at runtime How do I populate a combobox at runtime with data from cursor? Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189235
- Next
  - 1
    - russian, cyrilliic character font ?? with FoxPro 2.6 Hello, i am using FoxPro 2.6. i want to create a multi language table including different languages. Has somebody an idea, how i can store into a table the cyrillic charater font. And i also want to make a print out of the cyrillic text. is this possible in this old version of foxpro ??? thanks in advance for answers Wolfgang wolfgang@wolfgang-munich.de Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189234
  - 2
    - Page printing selection in VFP report preview. How to select only some pages for printing in VFP report preview. Is is possible to print only current page while viewing the preview Thanks Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189227
  - 3
    - wich field was updated ? I'm writing a trigger in a dbc (VFP6 SP5 + WXP). the same trigger is for update over 250 files, with each around 200 fields. On update, this trigger inserts a record in an other table. All works ok, but I need to store the names of the fields from where this trigger is run. I have alias, dbf, working areas ; if I have field name, I can use oldval and curval.. How can I retrieve field names ? Thank you in advance for help Michel (in France) Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189223
  - 4
    - Connectivity error [Microsoft][ODBC Visual FoxPro Driver] Cannot Open file d:\data\account.dbc I create the connection and view programmically. However, there is an error. Please give me a hand OPEN DATABASE d:\data\account.dbc SET DATABASE TO "account" IF INDBC("acct1","CONNECTION") = .F. Create connection acct1 ; connstring; 'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc'; CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM arinvheader endif -- Thanks For Your kind Attention. Best Regards, Miss. Agnes Cheng Dynamic Tech Consultants Ltd. T:2264-5583 F:2264-5584 mail : agnes@dynamictech.com.hk Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189222
  - 5
    - [ALT] key cannot open menu while running in EXE I have designed a menu 'MAINMENU' and define the ALT key in [keypress] in menu designer. This menu will be called from a form 'MAIN', The ALT key works while in the design time, after that, I compile it to build an exe file, the ALT key doesn't work. Inside the initial main.prg, I have several environment settings and at last, there is as do form MAIN read events and in the INIT event of form MAIN, the content is do mainmenu.mpr with thisform, .t. Below are some setting of the form MAIN ShowWindow - 2-As Top-Level Form WindowType - 0-Modeless MDI Form - .f. Please, can anyone give me a hand on this issue. thanks lot Edward Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189215
  - 6
    - How : Create remote view programmically? I try the folllowing code to create the odbc connection and remote view. However, those code didn't work . Canyone give me a hand ? OPEN DATABASE u:\sample\data\tradelink SET DATABASE TO "tradelink" IF INDBC("itts_connection","CONNECTION") = .F. Create connection itts_connection ; connstring; 'Driver={Microsoft Visual FoxPro Driver};'+; 'DBQ="u:\sample\data\tradelink" ;' CREATE VIEW itts_chl CONNECTION itts_connection AS SELECT * FROM CHL -- Thanks For Your kind Attention. From Agnes Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189208
  - 7
    - Promatrix Spam! Just for those of you who don't take kindly to spam (I've never made any approach to Promatrix): Return-Path: <promatrixnews@promatrix.com> Delivered-To: astechsystems@iinet.net.au Received: from unknown (HELO ms-smtp-03.tampabay.rr.com) (65.32.5.133) by mail.iinet.net.au with SMTP; 2 Feb 2004 23:29:03 -0000 Received: from EMACH1 (653220hfc53.tampabay.rr.com [65.32.20.53]) by ms-smtp-03.tampabay.rr.com (8.12.10/8.12.7) with ESMTP id i12NSD1H027087 for <astechsystems@iinet.net.au>; Mon, 2 Feb 2004 18:28:58 -0500 (EST) Message-ID: <4149-22004212232748359@EMACH1> Organization: ProMatrix Corp. From: "ProMatrix" <promatrixnews@promatrix.com> To: astechsystems@iinet.net.au Subject: Professional Visual FoxPro Framework Only $49.95! Date: Mon, 2 Feb 2004 18:27:48 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_84815C5ABAF209EF376268C8" X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Spam-Status: No, hits=3.6 required=5.0 tests=EXCUSE_3,FOR_JUST_SOME_AMT,HTML_40_50,HTML_FONT_BIG, HTML_FONT_COLOR_BLUE,HTML_SHOUTING3, HTML_TABLE_THICK_BORDER,MAILTO_TO_REMOVE, MIME_BOUND_NEXTPART,RCVD_IN_RFCI version=2.55 X-Spam-Level: *** X-Spam-Checker-Version: SpamAssassin 2.55 (1.174.2.19-2003-05-19-exp) ------=_NextPart_84815C5ABAF209EF376268C8 Content-type: text/plain; charset=US-ASCII VPM Standard Only $49.95. Go to: http://www.promatrix.com/mall/vpms01.asp VPM Enterprise 8.1 Now With Multilingual Toolkit and Source Control. Go to: http://www.promatrix.com/vpme/vpme01.htm ------=_NextPart_84815C5ABAF209EF376268C8 Content-Type: text/html; charset=US-ASCII <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Spotlight on  VPM 7</title> </head> <body topmargin="0" leftmargin="0" bgcolor="#FFFFFF"> <div align="center"> <center> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%"> <tr> <td width="100%" align="center"> <table border="1" width="615" style="border-collapse: collapse" bordercolor="#000080" cellpadding="0" cellspacing="0" bgcolor="#000080"> <tr> <td width="26%" bgcolor="#000080"> <img border="0" src="http://promatrix.com/email/pweb_banner_navy.gif" width="195" height="60"></td> <td width="74%" bgcolor="#000080"> <p align="center"><b><i><font face="Arial" size="7" color="#FFFFFF"> Breaking News</font></i></b></td> </tr> </table> <table border="0" width="615" bgcolor="#000080" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="100%" bgcolor="#000080"> <hr> </td> </tr> </table> <table border="3" width="615" bgcolor="#FFFFFF" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#000080"> <tr> <td> <table border="0" width="100%" cellspacing="3" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111"> <tr> <td width="83%" align="center"> <b><font face="Arial" size="4" color="#000080">News Topics</font></b></td> </tr> <tr> <td width="83%" align="center"> <ul> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#Get VPM Standard For Only $49.95">VPM Standard Only $49.95</a></font></b></li> <li> <b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Standard Multilingual Toolkit Now Only $49.95">VPM Standard Multilingual Toolkit Only $49.95</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 - Multilingual & Source Control">Introducing VPM Enterprise 8.1</a></font></b></li> <li><b><font face="Arial" size="4" color="#0000FF"> <a href="#VPM Enterprise 8.1 Demo Now Available">VPM Enterprise 8.1 Demo Now Available</a></font></b></li> </ul> </td> </tr> </table> </td> </tr> <tr> <td height="29" bgcolor="#000080" bordercolor="#000080"> <p align="center"> <b> <font face="Arial" size="5" color="#FFFFFF"> <a name="Get VPM Standard For Only $49.95">Get VPM Standard For Only $49.95</a>!</font></b></td> </tr> <tr> <td height="29"> <table border="0" cellpadding="2" cellspacing="3" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber2"> <tr> <td width="100%"> <p align="center"><b><font face="Arial" color="#0000FF">A regards - anthony shipley look, ma - no .sig Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189206
  - 8
    - My grid´s rightclick event is lost Hi all! I have to close and reopen a view to populate a grid (designed in VFP7) in VFP8. This probably because of lack of backcompatibility VFP8 to VFP7. I do this with the code below. SELECT vwRelscomp USE USE vwRelscomp IN 0 SELECT vwRelscomp Requery('vwRelsComp') This.Grid1.RecordSource = 'vwRelscomp' This.Grid1.Column1.Text1.ControlSource = 'vwRelsComp.relname' This.Grid1.Column1.Width = lnCol1Width && saved before closing the view Now the grid is populated again even in VFP8 but the Grid1.Column1's capacity to fire it's rightclick event becomes lost. How can I get the rightclick event (a shorcutmenu designed i the menubuilder) back to work? Regards Christina Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189205
  - 9
    - VFP running Access Query/Macro Hi Do you know of a way to run an Access query/macro from within VFP. No ODBC Similar to usin loXL = getobject('','Excel.Application' loWB2 = loXL.Workbooks.open('c:\earnedvalue\module\earned_value_data_shell.xls' loWB2.Application.Run('earned_value_data_shell.xls!import_data' to run an Excel macro Thanks Ga Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189203
  - 10
    - micration tool What is the best migration tool for VFP 6.0 ? -- George Malekkos ________ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189191
  - 11
    - Printing statements to Adobe files I would like to print statements to individual adobe print files for emailing. I have developed a process that runs the statement report for each customer. When I change the printer to Adode it asks the name of the file. I would like to send the name of the file for Adobe to use so I don't have to type it in for each customer. I am not finding an approach to send the name to Adobde. Any ideas? Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189189
  - 12
    - How Add a CommandButton on 1 Activex Dear All, I wants to add a CommandButton (Setup impression) on 1 Activex (CRviewer of CrystalREport). This AcTivex is on a Form. There is not method "Addobject" for this Activex. I use the addobject of Form but as you suspect it the button comes to be placed below the activex and is thus not visible. The method Zorder(X) does not arrange anything . It would be necessary to be able to say to the button "Always One Top"...... thank you in advance for the assistance brought. Bernhart Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189183
  - 13
    - Hardware Control via Printer-port ? Hi All, I've bought an "On-Off" relay control board with source code written by "VB" and "C++", actually I don't know the above 2 languages, can someone tell me VFP can do the same thing ? Thanks ! Regards Sammy Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189182
  - 14
    - Sending faxes using foxpro and windows 2003 sbs Dear All I am having problems with mapi sending faxes with Outlook 2000 sp3, xp and 2003. Early version are ok. I am getting to a point where I think it may be a security issue. Sending a normal fax is ok, but if I attach a *.tif file it comes up undeliverable with the message The Microsoft Fax transport failed to deliver the message to the recipient. Not all attachments can be rendered. Here is my code, I have changed the fax number. objSession = CreateObject("Mapi.Session") objSession.Logon () MESSAGEBOX("CDO version installed is "+trans(objSession.Version)) objMessage = objSession.Outbox.Messages.Add objMessage.Subject = "Test" objMessage.Text = "This is a test with an attachment" objRecipient = objMessage.Recipients.Add objRecipient.Name = "[FAX:5555555555]" objRecipient.Type = 1 objRecipient.Resolve () objAttachment = objMessage.Attachments.Add() objAttachment.Position = 0 objAttachment.Type = 1 objAttachment.ReadFromFile("C:\B.TIF") objAttachment.Source = "C:\B.TIF" objAttachment.Name = "B.TIF" objMessage.Send () objSession.Logoff Thank you for any help David Anagram Systems Limited work email: david@anagram-sys.co.uk Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189181
  - 15
    - System Clock Hi Is it possible for VFP to hide the system clock so that no one ca change the time of the computer Thanks Abe Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189179
  - 16
    - Incorrect page footer information problem env: O/S 2000 sp4 vfp7 sp1 on report designer, 1.data grouping is set, new page when group change 2.fields on group footer band is set "Stretch with overflow" If fields stretch with overflow on group footer and it overflow to next page, it affect the result of field on page footer on current group and next group. Steps to Reproduce: Create table by following code: create table table1 (f1 c(10),f2 m) insert into table1 (f1,f2) value ('A','') insert into table1 (f1,f2) value ('B',repl('X'+ chr (13),200)) && overflow to next page insert into table1 (f1,f2) value ('C','') create report testbug add data grouping expression "f1" : set "Reset page number to 1 for each group" add report variables "vf1" with Expression : f1 on page header band : add a field Expression : f1 on detail band : add a field Expression : f1 on "group footer : f1" band : add a field Expression : f2, set "Stretch with overflow". on page footer band : add a field Expression : f1 Save report do a command : report form testbug preview Or report form testbug to print result : Assume Group A is printed on page1, Group B is printed on page2 and 3 because for group footer overflow to next page, Group C is printed on page4 on page footer band when f1 group B : field "f1" display C && incorrent field "vf1" display B && corrent on page footer band when f1 group C : field "f1" display C && correct field "vf1" display B && incorrent Is it a bug? thanks. Ray Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189178
  - 17
    - Foxpro 6 Tutorial Hi All, I am the very beginner of Foxpro. Currently, I have Foxpro 6.0 installed in my computer(windows ME 2000). I would be very appreciated if some one can tell me the websites which contain the Foxpro 6 Tutorial. Have a nice weekend! Best Regards Richard Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189175
  - 18
    - Graphical editing of a class Hi all, If I define a class in a program (not is the class designer), how could I edit it in the class designer? Thanks Hutch Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189173
  - 19
    - not insert to table Dear All, I have 2 tables, sales and salesdetail here is my source: sales set to buffering-3 salesdetail set to buffering-5 begin transaction insert into sales(...blah blah blah) insert into salesdetail(...blah blah blah) if (tableupdate(0, .f., "sales") and tableupdate(1, .f., "salesdetail")) end transaction strange thing is, I got salesdetail updated but sales always got nothing. no error message pop out. Can't figure what's wrong. Many thanks. Regards, Wandy Tang Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189170
  - 20
    - change page per group on report vfp.6 start each group on a new page reprint group headers are on design mode of a report can i have it on a variable with a choice of a user on the same report ? -- Thanks George Malekkos --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/1/2004 -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189159
  - 21
    - Ask for method for copying file from one folder to another Dear all, I would like to ask is there any method for Foxpro 6.0 to copy file from one folder to another? Thanks a lot, Ray Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189150
  - 22
    - Mailmerge Wolfgang, Thanks for your kind response. I changed DFC() and got past the error but I got a message from WORD: Error in mailmergeword8(69): OLE IDispatch exception code 0 from Microsoft Word: Word was unable to open the data source. I am wondering if the message prior (Unable to find FoxPro File ODBCDriver) is the cause? I have tried putting the ODBC drivers I could find in the Windows and Windows32 folders but it didn't help. Do you know the proper name of the driver and where it should be located? I found this code in mailmergeword8 and it seems to be wanting the driver. Why would it be needing the ODBC driver and connection string when the data source is a local view? *- attach data file oDoc.MailMerge.OpenDataSource(THIS.cDataSrc,0,0,0,0,0,"","",0,"","",m.cODBCSource,; THIS.csqlstmt, THIS.csqlstmt2) Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189146
  - 23
    - SEEKING LIST OF COMMON WORDS I'm seeking a list of words one would find in an english dictionary (ie 'bank', 'cat', 'symphony', etc.) All I need is a comprehensive list of these common words. If anyone can send to me or direct me to a such a list I WOULD BE VERY GREATFULL !!! Thx Mike Farnesi San Diego Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189141
  - 24
    - simple procedure question Hi, I'm new to Foxpro, and I'm trying to create a stored procedure that returns a set of records. The following does not return records: procedure GetRecords select * from customer endproc Do I need to create a cursor or something? If so, what does that look like? tia, John Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189138
  - 25
    - CHECKBOX QUESTION I have a form that has three buttons 1. File Check 2. Run Program 3. Exit File check does what it says, looks to see if files are present. If they are present, it updates the chkbox/label with a CHECK. I then want to run the program in accordance with which boxes are checked. I tried you thisform.check.value but it doesn't work. Is there an easy to do this. I am getting I need to pass a value at some point? Thanks in advance. Tag: How to pass array by reference to VB dll from VFP8.0 Tag: 189133

I am passing arrays by reference parameters to Visual Basic dll from VFP8.0 and I am getting the following error

Error 2020
The class file associated with this field cannot be found - class association cleared
I believed this was fixed in VFP8 service pack 1. It is a known issue, but still it does not work. The same code works fine in VFP7.0, and now we are moving our app from 7.0 to 8.0.

Any suggestion or workaround to this, please help

Thanks
Hitesh Pate

Top

Re: How to pass array by reference to VB dll from VFP8.0 by Eric

Eric
Thu Feb 05 00:32:32 CST 2004

Hello, Hitesh!

Can you post your code and your VB class code?

Perhaps the following article can help you:
ArrayCom.exe Passing Array To COM DLL by Reference
http://support.microsoft.com/default.aspx?scid=kb;en-us;188255
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Top