how to open protected document using VFP program

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
    - Menu Picture Q. In the Menu Designer, under Options, what is the pixel dimensions of the picture file? Respectfully, Jonathan Morningstar Tag: how to open protected document using VFP program Tag: 239517
  - 2
    - hyperlink object Using VFP9 sp2, IE6 The following code takes me to the appropriate page in Google maps, thanks to a tip I picked up in this group a month or two ago. Now that I've implemented it to lots of oohs and aahs, I'm starting to hear that since most of the time users have a browser based application running at the same time, they'd like the Google maps link to open in a new instance of Explorer rather than using the existing instance. Does anyone have any idea of how to accomplish this? thisform.hyperlink1.NavigateTo("http://maps.google.com/maps?q="+; CHRTRAN(ALLTRIM( m.resstrt)," ","+")+"+"+; ALLTRIM(m.rescty)+"+"+; m.resst+"+"+; m.reszip) Thanks in advance. I'm sure someone's had and solved this problem already. Dave Tiffany Tag: how to open protected document using VFP program Tag: 239515
  - 3
    - More Database Help Thanks again. You don't know how much I appreciate all of you who take the time to answer. In anticipation of the day that I move to a different database... If I start changing my REPLACES into UPDATE SQL and my APPEND BLANK followed by REPLACE into INSERT SQL is there anything that is different? When I RT'd the FM it said something about UPDATE using record locking but it wasn't clear. -pause- As I was writing this posting it dawned on me that UPDATE without a condition will update every record in the table. If you want to update the fields in the current record, what SQL command do you use? Are there SQL commands that replace SEEK and FIND? Thanks, Jeff Tag: how to open protected document using VFP program Tag: 239510
  - 4
    - Database Help Hello all, thanks in advance for the help.... I've been using Fox for many years but I've never used DATABASES. The apps I'm running come from 2.x DOS days. All the DOS code is long gone now so I think its time to make the jump. I'm sure I've asked these questions here before but I don't remember the answers... Can tables in a database still be accessed as free tables? Are there different index requirements for tables in a database (Primary Keys, etc)? I would like to move into this slowly so as not to break any existing code. My primary motivation right now is to get a data dictionary where I can make notes about the various fields in some of the tables. I realize that databases can do a lot more but that is where I want to start. Once I add a table into a database, what else am I required to do in programs which use the table? Has anyone ever heard of an article like "DATABASES for old time Fox Programmers"? Thanks again, Jeff Tag: how to open protected document using VFP program Tag: 239504
  - 5
    - Report with Paragraph Hi, 1. Is it possible to make a report with a paragraph, with some words in the paragraph in BOLD? 2. Is there a way to make the paragraph alignment justified like in MS Word. Thanks. Tag: how to open protected document using VFP program Tag: 239499
  - 6
    - Help with .cdx file Have a program in VFP 9 and want to user proof it. So my program determines whether the data has become corrupt (using error 2005) then deletes the table and the structural .cdx file, then using create table I recreate the data table and then I use the index command using the syntax index on whatever tag indexname. On the machine I am writing this on this works fine, but when I put it on my testing machine the index creation was .idx files as opposed to a .cdx file. I found a suggestion to use a backup of the .cdx file, copy it to the same name as the table and then immediately upon opening reindex but that does not appear to be working. Any help would be appreciated. Tag: how to open protected document using VFP program Tag: 239497
  - 7
    - VFP Array Element Handling Gotcha I just got bit in a minor way with the way that VFP handles array elements. Consider the following code: local twod(10,2) for i=1 to 10 for j=1 to 2 twod(i,j)=10*i+j endfor endfor ? twod(4,3) Note the array dimensions and the reference. The reference is treated as being the third element starting in row 4 with VFP not checking against the declared dimension. The reference is treated as referring to twod(5,1), not as being an error. The docs do say that 2-D arrays can be accessed as 1-D. The implementation appears to be more general than that. Forewarned is forearmed and all that. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: how to open protected document using VFP program Tag: 239494
  - 8
    - How to read and update information via the internet. I am thinking of implementing a registration system into a commercial VFP application that will connect to a server across the internet, pass some unique account details and then return an expiry date. I know that I can create a .Net web service but this will require me to install all sorts of things on our clients sites and I want to keep things simple. I considered opening a query across the internet to a COM object but I understand this requires Soap which has been discontinued. I need this to be very fast and only a small amount of information will pass back and forth. What are my options here. Cheers David Younge Tag: how to open protected document using VFP program Tag: 239493
  - 9
    - mail merge by cdo Hi I am having trouble trying to use cdo to send an email I have set up a pc that does not use our exchange server and uses windows live mail (outlook express prettied up) This procedure works fine from that pc If I use a pc that is connected to exchange server (outlook is the default mapi client), nothing gets sent anywhere and no trappable errors occur I have reproduced the procedure below Any help appreciated John Davy procedure email_cdo LPARAMETERS cServer,cEmail,cSubject,cText,cFiles,cCc,cBcc PRIVATE all IF PCOUNT() < 7 cBcc = '' endif IF PCOUNT() < 6 cCc = '' endif IF PCOUNT() < 5 cFiles = '' ENDIF cR = CHR(13) + CHR(10) cFiles = STRTRAN(cFiles,",",CHR(13)) nFiles = alines(aFiles,cFiles) for i = 1 to nFiles if !empty(aFiles[i]) aFiles[i] = fullpath(aFiles[i]) endifnext loConfig = CREATEOBJECT('CDO.Configuration') loMsg = CREATEOBJECT('CDO.Message') cF = "http://schemas.microsoft.com/cdo/configuration" WITH loMsg .Configuration = loConfig WITH .Configuration.Fields .Item(cf + "/sendusing") = 2 IF !EMPTY(cServer) .Item(cf + "/smtpserver") = cServer ENDIF .Item(cf + "/smtpserverport") = 25 .Update() ENDWITH .TO = cEmail .CC = cCc .Bcc = cBcc .Subject = cSubject .TextBody = cText for i = 1 to nFiles if !empty(aFiles[i]) if file(aFiles[i]) .AddAttachment(aFiles[i]) endif endif next .send() ENDWITH RETURN Tag: how to open protected document using VFP program Tag: 239484
  - 10
    - Pageframe tabs question This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C86CF1.745980C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there an event that fires when the mouse moves over the page tab of a = pageframe. I have tried mouseenter for e.g. page 2 but it fires when the = mouse is over the main page rather than the tab of the page. Something is happening because as I move the mouse over the tabs a small = highlight bar is shown, but I can't find the event. Why do I want to do this? Because I wanted to display some help text on page 1 and hoped I could = get this text to change to explain the purpose of each page as users = moved the mouse over each tab . Many thanks Stephen ------=_NextPart_000_0006_01C86CF1.745980C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16587" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Is there an event that fires when the = mouse moves=20 over the page tab of a pageframe. I have tried mouseenter for e.g. page = 2 but it=20 fires when the mouse is over the main page rather than the tab of the=20 page.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Something is happening because as I = move the mouse=20 over the tabs a small highlight bar is shown, but I can't find the=20 event.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Why do I want to do this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Because I wanted to display some help = text on page=20 1 and hoped I could get this text to change to explain the purpose of = each page=20 as users moved the mouse over each tab .</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C86CF1.745980C0-- Tag: how to open protected document using VFP program Tag: 239478
  - 11
    - COPY TO TYPE DELI ERROR 202 "Invalid path or file name" I need to import a csv do some processing and overwrite the csv. lcActFile = THISFORM.txtActivityFile.Value LOCAL llAppendErr as Boolean llAppendErr = .f. TRY APPEND FROM ( lcActFile ) TYPE DELI CATCH TO loErr llAppendErr = .t. ENDTRY IF llAppendErr BRSERROR( "Could not open activity file " + lcActFile ) loMsgWin.AddLine( "Error: " + TRANSFORM( loerr.ErrorNo ) + CRLF +; "Description: " + loerr.Message, MSGTYPE_ERROR ) RETURN .f. ENDIF The actual file I'm processing is O:\woody\act_res_org_20080208\C103207_ACT_BLN_FFE.csv COPY TO d:\temp\testcopy.csv TYPE deli COPY TO d:\temp\C103207_ACT_BLN_FFE.csv TYPE deli COPY TO (lcActFile) TYPE DELI The first two COPY TO work but the third doesn't. I get error 202. If I change TYPE to CSV, it works but then I get field headers which I don't want. Does copy to deli not work with network path? Thanks Woody Tag: how to open protected document using VFP program Tag: 239476
  - 12
    - Access update via ODBC I'm attempting to updating an Access table via odbc, and I notice that .t. and .f. don't map to Access booleans (I'm using -1 = .t. & 0 = .f.). What other type mapping issues exist? Is there a resource that lists all the type maps? Tag: how to open protected document using VFP program Tag: 239473
  - 13
    - I Hate this kind of problem. Please Help Hello and thanks in advance for the help. I have an program which builds a file for the report generator, calls the report, and returns. It is being called from a right click menu of a form. The code for printing (2 lines) SELECT Inv_Print REPORT FORM pickticket to PRINTER NOCONSOLE The problem is that the first time this PRG is called from the compiled version I get a variable not found message. The problem does not occcur on calls to the PRG after the first one. Here is what I know about this problem: 1. If I change the REPORT line to include PREVIEW the code works fine 2. If I insert a BROWSE command in front of the REPORT command, it browses the INV_PRINT table and then prints fine. 3. If I put the BROWSE after the REPORT command, the error occurs and I discover that I wasn't actually pointing to the INV_PRINT table. As I said in the subject, I hate this kind of problem. Does anybody have any potential solutions or debugging suggestions. BTW, if you run the code in the debugger, the problem doesn't happen. It was only by sticking the BROWSE after the REPORT command that I discovered that it was pointing at the wrong table. The ultimate question is why would it be pointing at the wrong table when the SELECT statement is right before the REPORT command. Tag: how to open protected document using VFP program Tag: 239465
  - 14
    - how to update lower level view which is based on other views Hi friends I have few views e.g. view1,view2 view3 ( parameterised views based on view1 & view 2) view4 ( its also parameterised view and based on three tables and also view3) view3 and view4 has same parameter and report is using view4 but if i pass parameter for view4 it will display correct records for both view4 & view3 but when i change parameter value it will change view4 record as per value but it will not change the records of view3 but both have the same parameter , view3 display the 1st parameter values records not the current one. if I close the application and pass para then it will display correct record means it will change 1st time not every time. so how to update view3 thanks for help sanjib Tag: how to open protected document using VFP program Tag: 239458
  - 15
    - How to make VFP9SP1 read MSSQL2K5's varchar(MAX) as Memo instead of C(0) ? Hi all: First of all: ******************************* *** Gong Xi Fat Choi 2559! *** ******************************* And now, the story: I'm starting a new project. My application (created with Visual FoxPro 9.0 SP1) is using MSSQL 2005 (SP1) database as the backend. I read the data via SQL Server Native Client ODBC driver. Problem starts when I saw the following from SQL Server BOL (under the title "ntext, text, and image (Transact-SQL)" ): <start copying> ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. For more information, see Using Large-Value Data Types. <end copying> and based on that, I'm using varchar(max) instead of text. PROBLEM: 1. If I use RemoteViews, VFP will automatically read the varchar(max) datatype as c(0) (i.e. character type with zero length). Obviously, the data get truncated to zero length. Ok. I thought this one is easy. Simply change the datatype to Memo with the following: DBSetProp("SalesPerson.Notes","Field","DataType","M") would do the trick - and yes, it works well. But I wonder, is there any way to somehow 'force' VFP to do this by default? 2. If I use SPT; say, something like this: text to lcSQLCmd textmerge noshow pretext 2 select SalesPerson, Notes from SalesPerson where pkSalesPerson = lcPKSalesPerson endtext =sqlexec (liConnHandle, lcSQLCmd, [xSalesPerson]) then VFP will truncate Notes to c(0) as well. I have to use the following lcSQLCmd instead: text to lcSQLCmd textmerge noshow pretext 2 select SalesPerson, cast(Notes as text) as Notes from SalesPerson where pkSalesPerson = lcPKSalesPerson endtext Now, if i would have to force SQL Server to convert varchar(MAX) to text on _all_ select queries, why would bother to use varchar(MAX) in the first place anyway? Is the cost of forcing SQL Server to do the convertion worth the price of using varchar(MAX) instead of text? 3. Can anybody with VFP9SP2 confirm whether this still happen in SP2? If it's not, this might be one good reason for me to upgrade to SP2. ;) I'm looking forward to hearing from all of you! TIA, Willianto p.s: Yes. I know I'm cross-posting, and sorry for those of you that against this. But, I do realy like to hear and share opinions from the experts in the other planet ;) Tag: how to open protected document using VFP program Tag: 239457
  - 16
    - What is a parameterized view? Hi, I want to know what a parameterized view is? When I use the SET FILTER to for a database that is a grid control, the data display is very erractic. I was told that parameterized view is a better way to go. I don't want to have to create a cursor with SELECT command for the grid so I am hoping this will a better route. Thanks Zoom Tag: how to open protected document using VFP program Tag: 239452
  - 17
    - Any way to launch a PDF file from VFP within a new window with specific x,y, height and width? Hi, I use the following code to launch a PDF file from VFP: p_file="anyfile.pdf" DECLARE INTEGER ShellExecute IN Shell32.DLL ; INTEGER nWinHandle,; STRING cOperation,; STRING cFileName,; STRING cParameters,; STRING cDirectory,; INTEGER nShowWindow nResults = ShellExecute(0,"open",p_file,"","",1) I want to view the PDF document in a certain size window whose starting corner should be the top left of my screen but I want to be able to control the width and height of this window? Is there any way to do that? Thanks Zoom Tag: how to open protected document using VFP program Tag: 239449
  - 18
    - ATTN: Bill swdev2 - odbc over tcp/ip A while back, you said: > (odbc cross the internet is cool, btw) I know nothing about that. Can you point me to some info? Tag: how to open protected document using VFP program Tag: 239442
  - 19
    - Access Access vai odbc I have a vfp app that needs to do some io to an access mdb, I'm assuming that the easiest way do this is via odbc, if I'm correct can someone point me to some sample code or... is there a better method? The io is very simple.. locate a record in a table & change a single value. Tag: how to open protected document using VFP program Tag: 239437
  - 20
    - Tables not updating in compiled program - VFP 9 SP2 If I run my form from the command window and add a record the following code updates the table correctly INSERT INTO PATIENTS(acctnumber,medicalrecordnumber,datefirstexam,lastname,firstname,; middleinitial,age,familypresent,sex,admittedfrom,diagnosis,livingwith,livinghow,; plof1,plof2,dme,primaryins,secondaryins,patientnotes,staffingmeet,randpending, recertneededby) VALUES(lcAcctNbr,lcMrn,ldfirstdate,lclname,lcfname,lcmi,lnage,lcPresent,lcSex,; lcAdmittedfm,lcDiag,lcLivingWith,lcLivingWhere,lcplof1,lcplof2,lcdme,lcins1,; lcIns2,lcNotes,lcStaffing,lcRand,ldRecertDate) =TABLEUPDATE(.T.,.T.,'PATIENTS') Buffering is set to optimistic When I compile and run the program as an executible, the program fails to save the record. I know I have a setting wrong somewhere, but I can't find it. thank you for any help Hank Tag: how to open protected document using VFP program Tag: 239428
  - 21
    - Spaces in file names I have a line of code Append from &lcfile XL8 &lcSheet which currently fails of there is a space in the file name contained in &lcFile (and I expect will fail if there is a space in the sheet name). How can I have that line of code (or similar) and support file names with a space in them? I am using VFP 7 thanks pete Tag: how to open protected document using VFP program Tag: 239424
  - 22
    - OPening a file in Excel from vfp9 Could somebody help me by explaining why this code fails saying that the file c:\test\junk.xls cannot be found. It is there in the folder I promise. ******* Store Createobject([Excel.Application]) To loEx With loEx .workbooks.open("c:\test\junk.xls") endwith loEx = .F. ************ Sincerely Stephen Tag: how to open protected document using VFP program Tag: 239408
  - 23
    - vfp9 network installation problem This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C86959.9D895C90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am not experienced in networks and would apreciate some guidance on = installation. We have an app that has been designed for multi-user use. = I provide a server installation CD and Workstation installation CD. The = server version installs the main app and all support libraries, dynazip = activex etc into the default folder c:\my company\accounts on the server = (folder names changed but note the space - I don't know whether this is = significant). The data and reports are held in sub-folders of this main = folder. The workstation CD installs the vfp support libraries, activex controls = etc locally into c:\my company\accounts on ech workstation. First question - is this necessary - is a local install of these files = needed. I did it as belt and braces to make sure the support libraries = cound be found and because it worked I never bothered to question = whether they chould be there. The user sitting at the workstation then maps a drive, for example drive = X to \\server\my company Second question - I found that mapping to the folder my company rather = than to the accounts folder on the server was more reliable. Is there = any reason for this? A desktop shortcut to x:\accounts\myapp.exe is then created and = everything works fineon numerous networks across the country - EXCEPT - for one installation. It is based on Windows 2003 server. It has been = installed and is being tested by the network administrator with full = rights. With the above settings, sitting at the workstation, running the = app, he first gets the message that the resource file in invalid, do you = wish to over-write it, and whatever answer he gives the next error is = 111 cursor can not be updated - possibly read-only. We have both checked everything we can think of (and no, the file flags = are not set to r/o). Third question - can any body help me to see where this is going wrong = for this one user as we have run out of ideas. Many thanks Stephen ------=_NextPart_000_0006_01C86959.9D895C90 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16587" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I am not experienced in networks and = would=20 apreciate some guidance on installation. We have an app that has been = designed=20 for multi-user use. I provide a server installation CD and Workstation=20 installation CD. The server version installs the main app and all = support=20 libraries, dynazip activex etc into the default folder c:\my = company\accounts on=20 the server (folder names changed but note the space - I don't know = whether this=20 is significant). The data and reports are held in sub-folders of this = main=20 folder.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The workstation CD installs the vfp = support=20 libraries, activex controls etc locally into c:\my company\accounts on = ech=20 workstation.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>First question - is this necessary - is = a local=20 install of these files needed. I did it as belt and braces to make sure = the=20 support libraries cound be found and because it worked I never bothered = to=20 question whether they chould be there.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The user sitting at the workstation = then maps a=20 drive, for example drive X to \\server\my company</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Second question - I found that mapping = to the=20 folder my company rather than to the accounts folder on the server was = more=20 reliable. Is there any reason for this?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>A desktop shortcut to = x:\accounts\myapp.exe is then=20 created and everything works fineon numerous networks across the country = -=20 EXCEPT -</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>for one installation. It is based = on Windows=20 2003 server. It has been installed and is being tested by the network=20 administrator with full rights. With the above settings, sitting at the=20 workstation, running the app, he first gets the message that the = resource file=20 in invalid, do you wish to over-write it, and whatever answer he gives = the next=20 error is 111 cursor can not be updated - possibly = read-only.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>We have both checked everything we can = think of=20 (and no, the file flags are not set to r/o).</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Third question - can any body help me = to see where=20 this is going wrong for this one user as we have run out of = ideas.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0006_01C86959.9D895C90-- Tag: how to open protected document using VFP program Tag: 239403
  - 24
    - Could not create ZIP file <New Zip File Name> Hi, In one of my program I'm trying to zip up multiple files. In order to create the zip, DyanZip dll's are used. When zipping up below error throws up from DynaZip; Could not create ZIP file <New Zip File Name> This error isn't prompted consistently, but occasionally. Strangely though, the New Zip File is created with the correct list of files as well. As per the DynaZip documentation Meaning/ Possible cause for this error is described as; "Could not create ZIP file - This error can occur when the target ZIP file or the directory to contain the ZIP file is locked or restricted by another." Since the desired zip file is created with the correct files, I'm finding it difficult find a way to over come this issue. Does anyone has come across this such a strange behavior? Thank you in advance... Tag: how to open protected document using VFP program Tag: 239402
  - 25
    - FoxPro sample project Hello guys, I am green and wanna learn foxpro from internet, do u hv any foxpro sample project for my reference or which good site can be introduced to me? thanks a lot Tag: how to open protected document using VFP program Tag: 239397
- Next
  - 1
    - Grid Cell colour I am trying to change the background colour for individual cells in a row within a grid. Currently in the activerowcolchange event I am looping through the columns of the grid and setting the background colour of the textbox to be the desired colour and toggling the readonly property as well. If I click on a cell that has the new colour set it will show in the new colour but if I tab to that cell the new colour is not shown. I would like to see these cells in the chosen colour without the need to click on them. Is this achievable? I am using VFP 7 thanks pete Tag: how to open protected document using VFP program Tag: 239384
  - 2
    - msmapi control - problem sending attachments I have a routine that sends a number of statements by email to a number of clients (up to 1000) The statements may have up to 6 separate pdf's attached and a number of jpg's The batch routine that sends these works fine but a number of clients are reporting that they are not getting the attachments When I check the sent items, the emails are all there and properly formed with the attachments in place If a client who has this problem returns the email to me there is no attachment. I have set the switch in outlook to not send immediately in the hopes of being able to review and then send from the outbox after the vfp process was complete but this does not seem to prevent the immediate sending of emails. It seems to me to be a timing thing and that a lag should be placed in the process in order to allow outlook to properly form the email message before sending it. If I use the win api sleep function to provide that lag time, does this allow for other event steams to continue while it waits - or would the inkey() function be better? Has anyone else experienced this problem and found another solution? Any help appreciated John Davy vfp6 / winxp / outlook Tag: how to open protected document using VFP program Tag: 239381
  - 3
    - Random calc/printing problem VFP9 I am bringing this up again in case somebody has any clue. I have a fairly involved app that calculates customer totals, special fees, due dates, etc. and prints the invoice. The problem is that internally the numbers seem OK but "sometimes randomly" it prints it wrong. Here are some details: 1. The customer can insert codes in a string to position their fees, totals, due dates, etc where they want on the invoice. The codes are converted to actual fees, etc. characters and the string is printed out on the report. I do the similar substitutions for customer data on other part of report (no problems). 2. It never happens on one of mine PCs - but I don't use the app 8 hours/day. 3. One customer has two networked PCs. The random results happen on one PC (XP with SP2) and not on the second PC (XP with SP1). 4. This app was updated from VFP5 to VFP9. It did not happen with VFP5. 5. Most cases with problems are using HP laser printers. 6. I install my apps by simply using the minimal required VFP9 files into the app folder. By chance is there a system file that should be installed somewhe else? ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: how to open protected document using VFP program Tag: 239373
  - 4
    - Auto increment Hi 2 all Sir I set inv_no (auto increment) in my table sir when ever I zap this table and append it from backup table the field inv_no incremented sir how to programmatically set the initial value of auto increment field and how set the next step value thanks -- Qaiser Me Tag: how to open protected document using VFP program Tag: 239372
  - 5
    - Grid Scrollbar / Current Record Position I'm using a grid on my form which pulls records from a view (SQL backend). I perform a REFRESH(1,0,"MY_TABLE") each time I move rows to update the underlying view with changes that may have been done across the network. Problem is, when I use the scrollbar on a grid to move up and down the row pointer doesn't change until the body of the grid has focus (i.e. I click on it) so the records that are displayed are more often than not out of sync with those in the backend database. Is there any way of being able to update/refresh the view as the scroll takes place so it reflects the true data? Tag: how to open protected document using VFP program Tag: 239363
  - 6
    - FoxPro does not switch between work areas as focus changes between When a form is opened by a menu selection the form work area is not selected automatically as expected, even though a select alias is issued in the form?s activate event. There is no problem when the form is opened from another form, only when opened from the menu. I can not get the alias selected, it always remains on the background form until I select another forms and back, then it becomes OK. I am using VFP9 SP1 Any idea? Thanks, Thorkell Gudmundsson Tag: how to open protected document using VFP program Tag: 239349
  - 7
    - FS: older foxpro editions. For sale: - Foxpro 2.6 for Macintosh, STD edition, 8 diskettes. Unregistered - VFP 3.0, STD upgrade edition, 12 diskettes. Unregistered. Make offer. Contact me through my website http://www.abri.com/ ----------------------------------------------------------------- Paul Lee ........ Abri Technologies ........ http://www.abri.com/ 'Recover' - top rated FoxPro file repair utility. ----------------------------------------------------------------- Tag: how to open protected document using VFP program Tag: 239347
  - 8
    - Setting Fax Retries - XP PRO and VFP I'm successfully sending and logging fax events from my code, but I'm having trouble determining how to set the RETRY count down. I only want to try 2 times, an initial plus 1 more. Anyone know how to do this? Thanks in advance, Joe Todd Tag: how to open protected document using VFP program Tag: 239346
  - 9
    - automate Join Source Control Project command I want to automate the following task: File-->Join Source Control Project. I know how to automate build process (VisualFoxpro.IfoxProject.Build()) and source safe get latest version command (SourceSafeTypeLib.VSSItem.Get), but I cannot find "Join Source Control Project" function. The problem is that two developers are working on the same projects and when developer A adds the new file to the project (pjx file) and then to the source safe (Project-->Source control-->Update project list i.e. pjm file), the developer B project file becomes outdated (pjx file) Thanks in advance Sanjin Tag: how to open protected document using VFP program Tag: 239342
  - 10
    - how to create a user instance of sql server express 2005 from VFP9 how to create a user instance of sql server express 2005 from VFP9. This will help to keep the database on pen drive. Rajesh Tag: how to open protected document using VFP program Tag: 239341
  - 11
    - COM Port Access through VFP 6.0 Dear All, I need help in VFP 6.0. We have a device which is connected with Serial Port. I need to communicate with that Device through VFP 6.0 and i want to receive the value shown in that device. Please help me how to do workaround in VFP 6.0. Communication with Serial / COM Port. Thanks in Advance for your valuable suggesstions. Thanks, Guruprasath. B Tag: how to open protected document using VFP program Tag: 239338
  - 12
    - VFP Awful performance of Buffered Cursors Hi everyone, The program demonstrates how VFP fares extremely badly when dealing with Cursors that are indexed. *-----------------------------------------------------------------* * Try out this test program * The downloaded cursor is not made updatable for the Test program but in a real life scenario, * we set properties like Namelist, UpdatableFieldList,etc., on the downloaded cursor. *-----------------------------------------------------------------* CLOSE DATABASES USE XTR SCATTER MEMVAR =SQLEXEC(1,"SELECT * FROM TRFILE WHERE 1=2") INDEX ON subcd TAG subcd INDEX ON itemcd TAG ITEMCD INDEX ON co+branchid+TRANSFORM(trdno,"9999999999") TAG TRDNO INDEX ON branchid TAG BRANCHID INDEX ON DELETED() TAG DELETED INDEX ON trno TAG TRNO =CURSORSETPROP("Buffering",5) * I am going to add 10000 random records FOR m.Count=1 TO 100000 APPEND BLANK GATHER MEMVAR ENDFOR * Now I will delete every 25th record FOR m.Count=1 TO 100000 STEP 25 GOTO m.Count DELETE ENDFOR ***** Almost Hangs your system COUNT TO X *-----------------------------------------------------------------* You could use ANY table of your choice in SQL Server and Index them Randomly into multiple indexes. I have posted this question in a number of forums with no results. Everyone recommends "another" way of working with the data. However, I strongly believe that this could be a requirement of ANY application worth its salt. Abhay Tag: how to open protected document using VFP program Tag: 239333
  - 13
    - Word .doc in a VFP container Is it possible to display a .doc file in a FoxPro container (VFP 8)? Andrew McGurk Tag: how to open protected document using VFP program Tag: 239328
  - 14
    - Opening DB4 using VFP 6.0 I'm writing a program where I need to open DBF4 files and leave them in DBF4 format. I've put in these 2 statements: SET COMPATIBLE DB4 NOPROMPT SET CPDIALOG OFF I still get the Convert Memos box. What I am doing wrong here? And, is there a way to not convert the memo file? TIA. BR Tag: how to open protected document using VFP program Tag: 239322
  - 15
    - FoxPro 2.6 DOS Windows XP Pro Redirect LPT2 Printer Problem I recently tried to upgrade a client to Windows Professional peer-to- peer networking who is using an older FPD26 DOS application. Everything worked OK under his former networking with Lantastic with a mix of Windows XP PRO and Windows 98SE machines. Now, all his PC's are Windows XP PRO. His application prints to 2 different printers (LPT1 & LPT2) which are physically attached to one of the PC's named PRNTSRV. The 2 printers are an Okidata 321 and an Okidata 320 both using the built-in WIndows XP drivers. I am unable to redirect the print job from any of the PC's to LPT2: on PRNTSRV, however, PRNTSRV print to LPT2. I can redirect LPT1 to PRNTSRV with no problem. I am using the command NET USE LPT1: \\PRNTSRV\OKI321 /PERSISTENT:YES NET USE LPT2: \\PRNTSRV\OKI320 /PERSISTENT:YES The FPD26 command SET PRINTER TO \\PRNTSRV\LPT2: results in a "printer not ready error message." The redirected print job seems to vanish and it does not appear in the print queue. Any help would be appreciated. Tag: how to open protected document using VFP program Tag: 239316
  - 16
    - New XP installation- how can I import the old data from environment manager? Tag: how to open protected document using VFP program Tag: 239310
  - 17
    - Old FP2.6 app doesnt work in win xp i have this old app in fox pro 2.6 to dos, it has a input box with a space of 9 characters (in an windows 98) but if i run this app in win xp the input box just shows space for 7 characters. how can i fix this? Sorry for my bad english, i speak spanish :-). Thanks Tag: how to open protected document using VFP program Tag: 239303
  - 18
    - Creating Zip Folders (in vista) Hi. Would anyone know how to create a zipped folder from vfp 8? I have been using vfpcompression.fll to back up data from the server to a local pc. All is file with xp. Under vista, it does work if the data is on the local drive but if the data is on the server, vfpcompression is unable to create the zipped folder locally. I could create a folder from foxpro using mkdir and simple copy the data to it but if I could compress it, even better. Any suggesstions? TIA MIke Tag: how to open protected document using VFP program Tag: 239301
  - 19
    - MS Richtx32.ocx Is there a way to use richtx32.ocx to set justified alignment. It's not one of the options to .selAlignment but i'd hoped to use the .selRTF..... thisform.olertf.selAlignment = 1 thisform.olertf.selRTF = STRTRAN(thisform.olertf.selRTF,"\qr","\qj") But that just seems to be ignored (i.e. my \qj doesn't end up in the rtf). I also have a similar issue with page break. I can always type <<xyz>> in the rtf and replace before printing with the RTF code i want but that seems a bit fpw26 Thanks Nigel Tag: how to open protected document using VFP program Tag: 239293
  - 20
    - GRID HighlightStyle / DynamicBackColor I'm trying to make use of DYNAMICBACKCOLOR & DYNAMICFORECOLOR to allow users to select items from a grid (I use a UDF to control which rows have been 'tagged'). Problem is I also use HighlightStyle = 2 on the grid which stops columns from receiving focus. All works well except that the HighlightBackColor takes precedence over the DynamicBackColor so it's impossible to tell if the current row is actually tagged or not Is there anyway round this? Tag: how to open protected document using VFP program Tag: 239292
  - 21
    - FPW2.6, index does not match table error Hello group, long time no see.. I'm back momentarily to ask about this strange error; I was testing for how likely a random number collision would be when assigning random numbers to 50 records. I just stuck a DO WHILE loop around the code and set it running, after a few minutes the "Index does not match table" error occurred on the INDEX command :-/ Details here: http://www.rowan.nildram.co.uk/tmp/indexerr.png I'm guessing it's more to do with how Fox handles cursors when creating/destroying at high speed. Anyone have any other ideas how this happened? -- TIA Andrew Howell Tag: how to open protected document using VFP program Tag: 239288
  - 22
    - TRY...CATCH statements no longer work after regenerating binary via After regenerating form or class binaries via scctext (we use source control software), TRY CATCH statements produce a "TRY/CATCH/FINALLY/ ENDTRY mismatch or error" error. Simply resaving the binary fixes the problem. Any ideas? Thanks, Andrew Grandison Adelaide, South Australia Tag: how to open protected document using VFP program Tag: 239285
  - 23
    - Closing an external app since VFP An application must be closed to prevent troubles in my app. I´ve tried DestroyWindow without success. Had someone experience in doing this? I use VFP7 and WinXP SP2 THanks. Alejandro Fernandez Tag: how to open protected document using VFP program Tag: 239284
  - 24
    - Using the UPPER() function in a .prg with a variable. Need Help p Hi, Im having a small problem. I was writing a program in fox to read all fields then replace all data in the with uppercase data. The normal syntax i use for this is: REPLACE ALL address WITH UPPER(address) && address is the name of my field Now this will convert every record in the address column to upper case. Here is the strange part if i put this into a program and make this a variable it replaces every address record with the word address. Here is the short example. A='address' replace ALL address WITH UPPER(address) Here is the full deal to make all data uppercase no matter what structure the table is. CLEAR FOR gnCount = 1 TO FCOUNT( ) && Loop for number of fields ? FIELD(gnCount) && Display each field STORE ALLTRIM(FIELD(gnCount)) TO f1 REPLACE ALL (f1) WITH UPPER(f1) NEXT ? ? 'Number of fields: ' + ALLTRIM(STR(gnCount -1)) So i guess my question is why does it ignore the normal fox syntax once i make this a variable? Thanks for any help, Mike Tag: how to open protected document using VFP program Tag: 239274
  - 25
    - report problem Hello, I have a user that has had the program for years. And for years she has printed up her report just fine until just recently. This report has a company header and information on it. It is one page long. Now what it does is, it prints the company headoer the information and immediately after that repeats itself and reprints the company header and the information again. She tried reinstalling the program even. This is just a bizarre thing and and noting in the code has been changed to start this problem. Has any one had their reports go out of wack like this? Tag: how to open protected document using VFP program Tag: 239269

Hi I want to open a word document which is password protected using
VFP program. My application wants to open a series of protected and
unprotected word documents and printed. I know how to open an
unprotected document. but how a protected one? is there any option to
check a document a password protected or not?

Please help me!!!!!!!!!

Top

Re: how to open protected document using VFP program by Mike

Mike
Thu Feb 14 07:53:00 CST 2008

Send the password as the 5th parameter.

<kvjyothish@gmail.com> wrote in message
news:b24932f2-93ee-42dc-ab85-a0ba801c6701@e25g2000prg.googlegroups.com...
> Hi I want to open a word document which is password protected using
> VFP program. My application wants to open a series of protected and
> unprotected word documents and printed. I know how to open an
> unprotected document. but how a protected one? is there any option to
> check a document a password protected or not?
>
> Please help me!!!!!!!!!

Top