Problem With Vfp8

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
    - Distributing Application: Netsetup wouldn't work, Disk144 does I have spent over 6 hours today trying to make my distributed program work using Netsetup in step 3 of the Setup Wizard in VFP 6.0. With the Netsetup, the application installs fine and some options even work. However, I have two databases that are distibuted with the application named wwdata and wwtables. Database wwdata has its dbf files stored in \\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the application tried to open a table in wwtables, I keep getting the message "Error instantiating cursor object. File City not found in \\....\wwtables.dbc" or something like that. I tried numerous times by cleaning up the project and making sure that dbc file is not corrupted or something, but couldn't get rid of the error. Finally, I reluctantly selected the 1.44 MB option (I want to distribute the application on a CD in stead of floppies), and BOOM, it work the first time installation. However, it created six subdirectories DISK1 to DISK6 in the main directory named DISK144. Does anyone know the cause of this behaviour and is there any other way I can create Distribution files under one directory. Thanks in advance for heliping out...... Tag: Problem With Vfp8 Tag: 207488
  - 2
    - How do I capture mouse events to a control - MouseHook Hello, VFP 9 WIN2K I need to capture the mouse events for a specific control and when done with the control return the mouse events back to normal. Does anyone know how to do this in VFP Thanks in advance, -CraigB Tag: Problem With Vfp8 Tag: 207482
  - 3
    - I am looking for a 3rd Party VFP friendly RTF Reports ocx or dll product Hi All, I have been using Microsoft's richtx32.ocx in conjunction with apiprinter.vcx by Rasmus Moustgaard to view and print rtf documents created in MS-Word. I do not need the end-user to be able to edit the document. I am in the market for a integrated replacement control that will HANDSOMELY print and print preview MS-Word created RTF documents. Also, looking to be able to distribute the control royalty free. Any suggestions would be appreciated. Best Regards, Tom Clark Tag: Problem With Vfp8 Tag: 207479
  - 4
    - forrm.autocenter I have encountered an issue with some of my forms. All of my forms are based on a class called cform. Cform has its autocenter set to .t. and this works just fine. I have a few forms that I don't want to autocenter to I changed that forms value to .f.. But, their still autocentering. Its not the foxuser , and ini or some registry setting. I have no code in cform to force it back to .t. And after the form has run a check of that property reveals it to still be .f. Suggestions? Alan Tag: Problem With Vfp8 Tag: 207469
  - 5
    - Error opening exe I'm upgrading vfp 2.x to vfp 9. I fixed all compiling errors - and built a new.exe. When I run new.exe I get an the error Window 'command' has not been defined. I can click ignore, the main menu runs but it then claims my files are corrupt (which they are not because I checked them). Tag: Problem With Vfp8 Tag: 207465
  - 6
    - Class location I have put the classes in my project into files according to logical grouping. So sales.prg, purchases.prg, stock.prg etc. I am finding it a bit of a pain however trawling through pages of code to get to the bits I want. A colleague of mine who is experienced with C and Delphi says he normally puts each class into a file of it's own. Do you do this? Is it a good idea? -- Regards Darren Woodford - MCP, MCSE Woodford Computer Systems Ltd http://www.woodfordcomputers.co.uk http://www.accountancy-software.co.uk/pegasus-opera-ii/pegasus-opera-ii.php Tag: Problem With Vfp8 Tag: 207455
  - 7
    - Build Project Error When I try to build project, I get this error: Program d:\windowwizard\prgs\winwizprocs.prg has the following errors: Unknown AARRAY - Undefined Form d:\windowwizard\forms\frmcustomerentry.scx has the following errors: Unknown ALEADTYPE - Undefined Here is the source code in the project I am trying to build: Public aLeadtype Dimension aLeadtype[5,2] fillarray(@aLeadtype,"'A','Architect','B','Builder','P','Private Owner','R','Renovator','D','Dealer'") Function Fillarray(aArray, cValues) Local nLen,i,cValtype for i = 1 to alen(aArray) cVal=token(cValues,',',i) do case case type(cVal)='L' aArray[i] = evaluate(cVal) case type(cVal)='C' aArray[i] = strtran(cVal,"'",'') otherwise aArray[i] = val(cVal) endcase next return aArray Any ideas are greatly appreciated. BTW, Token is another function that I wrote and that function works flawlessly and returns expected values. Thanks. Tag: Problem With Vfp8 Tag: 207453
  - 8
    - Outlook Mail Automation Hi We have developed a VFP6 app for a customer that sends mail through Outlook. However our customer doesn't want all the recipients to be visible to each other so I thought it would be ideal to use BCC if it is available. I am currently using the following code to handle the mail olMessage = olOutlook.CreateItem(olMailItem) olRecipient = olmessage.Recipients.Add(addresslist) olmessage.send() Could this be modified to send via BCC instead of straight addresses ? Thanks in advance Andy Tag: Problem With Vfp8 Tag: 207448
  - 9
    - slow reporting With REPORTBEHAVIOR = 80, a report preview pops up instantly. With REPORTBEHAVIOR = 90, the same preview takes 12 seconds to appear. Is that normal? Tag: Problem With Vfp8 Tag: 207435
  - 10
    - Excel error I am getting a strange Excel error in my application. <snip> tmpsheet=getobject('', 'excel.sheet') XLApp=tmpsheet.Application XLApp.Visible=.f. <snip> I am getting an error on the "XLApp=tmpsheet.Application" line. OLE error code 0x80010108: The object invoked has disconnected from its clients Can anyone tell me how to fix this? Thanks, Scott Tag: Problem With Vfp8 Tag: 207434
  - 11
    - VFP9 in MSDN? Anyone know which MSDN distribution will include VFP9? I was expecting it in the January shipment, but no dice. Yes, I know it is available for download, but I live out in the boonies and have a snail-like dial-up connection that gives me 26kbps on a good day. :^( -- TRW _______________________________________ t r w 7 at i x dot n e t c o m dot c o m _______________________________________ Tag: Problem With Vfp8 Tag: 207426
  - 12
    - VFP 9 Rebate offer This may be old news to some: watch for url wrap [ http://www.microsoft.com/products/info/popup.aspx?view=22&type=rebate&cont ent=7b9bb6aa-f6c0-43b4-b315-6cfd9eb3e39a ] and of course - buy yer VFP Version 9 here: http://www.foxtoolbox.com/ Enjoy ! mondo regards [Bill] -- William Sanders / Electronic Filing Group Remove the DOT BOB to reply via email. Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html Mondo Cool Satellites -> http://www.efgroup.net/sat VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting mySql / VFP / MS-SQL Tag: Problem With Vfp8 Tag: 207421
  - 13
    - Transaction problem in VFP9 Dear all, The code beneath generates an error in VFP9. In VFP8 it runs fine. The purpose of the original code is to store data from a view into the database. The sample code doesn't really make sense anymore. We stripped the code down to its bare minimum. It's just a way to show the error. We don't think this code is illegal. So, is there a bug in VFP9? Regards, Roel, Bas and Benno. *=========== BEGIN CODE ============================ CREATE DATABASE database OPEN DATABASE database CREATE TABLE test (FIELD_KEY I, FIELD_DATA I) INSERT INTO TEST (FIELD_KEY, FIELD_DATA) VALUES (0, 0) CREATE SQL VIEW MYVIEW AS SELECT * FROM test USE MYVIEW IN 1 CURSORSETPROP("buffering", 5, 1) CURSORSETPROP("keyfieldlist", "FIELD_KEY", 1) CURSORSETPROP("UpdatableFieldList", "FIELD_KEY, FIELD_DATA", 1) REPLACE FIELD_DATA WITH 1 IN 1 SAVE_VIEW() APPEND BLANK IN 1 REPLACE FIELD_KEY WITH 1 IN 1 SAVE_VIEW() PROCEDURE SAVE_VIEW() LOCAL nRecno nRecno = GETNEXTMODIFIED(0, 1) BEGIN TRANSACTION GOTO (nRecno) IN 1 IF (nRecno > 0) REFRESH(1, 0, 1) CURVAL("FIELD_DATA", 1) ENDIF TABLEUPDATE(0, .F., 1) END TRANSACTION ENDPROC Tag: Problem With Vfp8 Tag: 207420
  - 14
    - valid views built in view designer can't be opened by view designer When building remote views, I've noticed that I can build queries with the View Designer on back ends that have non-Fox features, like spaces in the field names. The View Designer works fine, the query works fine. But if I try to reopen the view with the View Designer, I get "syntax error" messages, so if I want to modify the view, I have to do it programmatically. The View Designer in VFP9 is very good, and a big improvement over VFP8's (which was a big improvement over VFP7's). But it really should be able to open views that it itself created, don't you think? Tag: Problem With Vfp8 Tag: 207419
  - 15
    - Reset Browse Last to match Browse Preference? Reset Browse Last to match Browse Preference? I have about 6 aliased and related browse windows of the same .dbf that I'm using to manually clean up data. The records are quite long so even with some fields sized smaller than their actual field length in the browse window, I still have to scroll right and left as I go about my cleanup, or expand a field (with my mouse) I have covered up, to check it or enter data. As I skip back and forth and alter the alignment or size of the displayed fields I want my changes to the browse windows to be kept and reflected with a Browse Last, WHICH THEY ARE. That's why I'm using Browse Last (from a On Key Label F8) Anyhow, sometimes things get screwed up and I wish I could revert one or more of the windows back to my more or less starting browse appearance, like with a Browse Preference to sort of reset things and then go back to using a Browse Last. I don't think Browse Preference and Browse Last play well together. They seem to be totally independent. Isn't there a way to get Browse Last to absorb Browse Preference? Is there some other work around i.e. a way to set up a particular look for all the browse windows that will be a sort of reset for Browse Last? -- JJ John "J.J." Jackson Tag: Problem With Vfp8 Tag: 207418
  - 16
    - execute pc code from a command button What is the proper procedure that would be used to have a command button do something like: comment - file copy in process y:\ MD test c: CD\temp COPY *.* y:\test comment - file copy complete Dan Tag: Problem With Vfp8 Tag: 207417
  - 17
    - Store column positon and width. Hello all, I would like some advice, what is the best way to store grid column positions and width. I thought about using .ini files. Any advice would be appreciated. Regards Richard -- To reply remove 'NoSpam' from email address Tag: Problem With Vfp8 Tag: 207408
  - 18
    - blat Can't use Blat if you have Norton Antivirus installed! Scan type: Auto-Protect Scan Event: Threat Found! Threat: Bloodhound.OutEmail File: C:\WINDOWS\system32\blat.exe Location: Quarantine Computer: STEVEFISHER User: steve.fisher Action taken: Quarantine succeeded : Access denied Date found: 10 February 2005 13:43:02 I haven't worked out how to exclude blat from scan. Everything is greyed out on my machine so will have to check the w2003 server and the book. Steve Tag: Problem With Vfp8 Tag: 207403
  - 19
    - error "File not open" when building For the past couple of days this error has appeared when I try to build a project in FPW2.6 I click "build", then select "executable" and when I click OK, instead of asking for the output file name it just says "File not open" Why? I've tried CLOSE ALL, CLEAR ALL but the only thing that seems to fix it is quit and restart. -- TIA Andrew Howell Tag: Problem With Vfp8 Tag: 207396
  - 20
    - RUN exe and hide the box This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C50F6F.FD914630 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, How do i "RUN ipconfig.exe > ip.txt" by not showing up the disturbing = dos look windows box ? I can't use /N7 because I need to read for the created ip.txt=20 regards Hoe ------=_NextPart_000_000E_01C50F6F.FD914630 Content-Type: text/html; charset="windows-874" 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=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2135" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>How do i "RUN ipconfig.exe > = ip.txt" by not=20 showing up the disturbing dos look windows box ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I can't use /N7 because I need = to read for the=20 created ip.txt </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML> ------=_NextPart_000_000E_01C50F6F.FD914630-- Tag: Problem With Vfp8 Tag: 207392
  - 21
    - How to print continuously Hello, I am trying to output my report to a roll of labels on my printer but it skips at the end of each page. How can I make it to print continuously without the page break? Thanks. -- jw Tag: Problem With Vfp8 Tag: 207391
  - 22
    - Test dropped-collapsed state of dropdownlist Is there any way to test the state of a dropdownlist to determine if it is currently dropped or collapsed? I'm looking to write a procedure to toggle it, but not knowing its current state makes this a wee bit challenging. Perhaps there is another way, but right now I have tunnel vision and seem to want to do it this way. Jim Tag: Problem With Vfp8 Tag: 207385
  - 23
    - Printing Labels from record to record. There has to be a way but I have not stumbled on it yet. I want to print labels between records. Something like label form mylabel record 1 to record 8. Tried all but between does not work, less than greater than don't work. What works. Do not know what I would do without all the help I get on this newsgroup. TonySper Tag: Problem With Vfp8 Tag: 207381
  - 24
    - Memo Binary What is the Field type code for Memo binary? i.e. C Character, M Memo. Many thanks Shahriar Tag: Problem With Vfp8 Tag: 207355
  - 25
    - Text not showing Upgrade Fox 2.6x to 9.0 A screen contained text on upper portion and controls on lower portion. The screen contols work but the text doesn't appear. In a .prg reads cNotes = ; "^ XXXXX XXXXXXXXXX# XXX: XXXXXXXXX-XXXX " +; "XXXXXXXXX XXXXXXXXXX ^^" +; WRAP("This xxxxxxxx requires multi-level " +; "contractors to place job titles in the xxXXX " +; "where the selection decision is made for " +; "those jobs (Higher Level Plan) rather " +; "than in the XXX where the jobs are " +; "physically located (Lower Level Plan). ",104) +'^^'+; WRAP("These job titles remain in the Workforce " +; "Analysis of the Lower Level Plan but " +; "are excluded from the Utilization Analysis " +; "and Goals and Time Tables of the " +; "Lower Level Plan.",104) +'^^'+; "These xxx xxxxx are included in " +; "BOTH the Workforce Analysis and Utilization " +; "Analysis and Goals ^and Time Tables of the " +; "Higher Level Plan.^^" +; WRAP("The affected job titles are marked with an "+; " * when they appear in both plans. " +; " " +; " ",104) This is info only - how can I get it to show on the screen? Thanks. Tag: Problem With Vfp8 Tag: 207351
- Next
  - 1
    - return value from sproc with spt Hi, How can I retrieve a return value from a MSSQL server sproc using SPT? I'm not using any output param in my sprocs. All I need is to retrieve the sprocs' retval from my vfp appl, and NOT just the status of the sproc exec. In other words, I need an equivalent to following VB.NET statements: sqldataadapter1.selectcommand.parameters("@return_value").value. Thks & brgds, andy Tag: Problem With Vfp8 Tag: 207350
  - 2
    - ms winsock activex control This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C50F07.515EC440 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, what file name is this ms winsock activex control in vfp 7.0 or 9.0 ? can this file royalty free for distribution with our vfp exe ? can we buy it without purchase of the vfp license ? regards hoe ------=_NextPart_000_000A_01C50F07.515EC440 Content-Type: text/html; charset="windows-874" 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=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2135" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>what file name is this ms winsock = activex control=20 in vfp 7.0 or 9.0 ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>can this file royalty free for = distribution=20 with our vfp exe ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>can we buy it without purchase of the = vfp license=20 ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>hoe</FONT></DIV></BODY></HTML> ------=_NextPart_000_000A_01C50F07.515EC440-- Tag: Problem With Vfp8 Tag: 207340
  - 3
    - need some advice on user impersonation and vfp 8 We have an application that spans several generations of VFP and now have to make some modifications to it. It runs client/server to a sql database or an oracle database for starters. The app launches and the user must log in. This is a user and password that resides in our app and db. It is not integrated with the OS user in anyway. There in lies the problem. Now, we need to make all the properites of the user accounts in the app behave like OS users where you can require strong passwords, minimum lengths, expirations, memory, encryption, etc. All the things the OS generally handles. What I am thinking I might do is somehow map those user accounts to the domain user accounts (at least for windows domains) thru the use of thier account SID or something. Then give them a cmd line switch on launch to use that feature or not or something like that. Is this possible? If so, how? Do I hook into some windows API for this? Not really sure. If anyone can shed some light I'd be greatful. TIA Tag: Problem With Vfp8 Tag: 207339
  - 4
    - Auto Dial and Disconnect in VFP Friends, Some months ago I was looking for a way to programatically dial and disconnect a SPECIFIED dial-up networking connecion. Although no VFP solution was found, today I came across a topic by the name of RASDIAL in windows help. There is an internal application in windows by the name of rasdial.exe which did what I wanted. (My OS is win XP Pro, however this application seems to be there in Win95 upwards) However while I was searching for topics related to RASDIAL in windows web knowledgebase, it appeared to me that there is an RASDIAL API also. My knowledge of API call is as good as none. I will appreciate it very much if some members please guide me towards better usage of this feature. I used the following code to connect and disconnect: run rasdial "Connection_name" "username" "password" run rasdial "connection_name" /d (I found details about the utility by searching by keyword "rasdial" in win XP help) Now I am looking forward to have following features: 1. To know if connection has been successful, else redial. 2. To be able to do these things without the usual black window. Please accept my gratitude for the helpful and useful posts in the group. I will look forward to have a detailed sample code because I do not have detailed knowledge of API calls. Best Regards S Bans Tag: Problem With Vfp8 Tag: 207338
  - 5
    - Excel Auomation - Adding Textbox I'm hoping to have better luck posting this the second time around. I've gotten most of the elements to creating Excel sheets down and adding data to them. I want to add a textbox to a sheet for some free flowing data. I'm having a problem getting the code from VB to VFP. Here is the VB code: ActiveSheet.OLEObjects.Add(ClassType:="Forms.TextBox.1", Link:=False, DisplayAsIcon:=False, Left:=11.25, Top:=322.5, Width:=428.25, Height:=47.25).Select If anybody would know how to, also, add text to it, I'd much appreciate. Thanks. Tag: Problem With Vfp8 Tag: 207335
  - 6
    - checkbox in listbox? Hello, In a listbox, is it possible to show a logical field using a checkbox, like it does in a grid? If it is, how is it done? Thank you. -- jw Tag: Problem With Vfp8 Tag: 207332
  - 7
    - odbc driver for vfp9.0? Is there an updated odbc driver for vfp 9.0 Thanks, John Tag: Problem With Vfp8 Tag: 207329
  - 8
    - Crystal Reports Question I have a parameter field named group defined as a string range. From this I have a formula field named mingroup defined as follows minimum({?group}) In the display string of mingroup I have the following code if trim({@mingroup}) = "" then "Earliest" else {@mingroup} This code does not work, is there any way to detect wether {@mingroup} is empty. I have tried different comparisons to an empty string and nothing seems to work. Thanks in advance Dave Tag: Problem With Vfp8 Tag: 207323
  - 9
    - Image I have images stored in a SQL 2000 database and have created views in VFP to access the tables. How do I actually read the binary data stored in the table to be displayed lets say in a image control? I was hoping something like this would work: thisform.image1.picture=mysqltable.image && but if doesnt. Is there a different control I need to use or is there a way to make the above example work. Many thanks Shahriar Tag: Problem With Vfp8 Tag: 207319
  - 10
    - get dynamic internet ip ? This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C50EB9.2074A0A0 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, how do i programmatically retreive current internet ip ? regards Hoe ------=_NextPart_000_0008_01C50EB9.2074A0A0 Content-Type: text/html; charset="windows-874" 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=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2135" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>how do i programmatically retreive = current internet=20 ip ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML> ------=_NextPart_000_0008_01C50EB9.2074A0A0-- Tag: Problem With Vfp8 Tag: 207316
  - 11
    - GDI+ Hello ! I recently downloaded from UT Alexander Golovlev's class "GpImage.prg" That´s a really terrific tool! That enables resizing and converting image files, using GDI+ I started studying it, and would like to Draw some string on an image. But I don't have any experience dealing directly with the APIS. I researched on MSDN and www.news2news.com and there I found the method GdipDrawString , that has the syntax below. How can I implement it ? Thank you very much in antecipation Cesar Chalom Sao Paulo - Brazil *!* DECLARE INTEGER GdipDrawString IN gdiplus; *!* INTEGER graphics,; *!* STRING widechar,; *!* INTEGER length,; *!* INTEGER fnt,; *!* STRING @ rectf,; *!* INTEGER stringFormat,; *!* INTEGER brush Tag: Problem With Vfp8 Tag: 207312
  - 12
    - copy to throws error 202 I have a table open and have to copy it to a csv: COPY TO (lcStatusFile) TYPE DELI lcStatusFile = "D:\temp\DAWN\load_status_prob_20050208\200501 DAWN_Status_Submittal.csv" The file itself exists, so there should be no problem with the path. When the COPY TO executes I get error: Invalid path or file name (Error 202) I tried this: COPY TO ( JUSTFNAME(lcStatusFile) ) TYPE DELI and it worked. I tried this: ?DIRECTORY( JUSTPATH(lcStatusFile) ) and it was .T. What else can I try? Thanks, Woody Tag: Problem With Vfp8 Tag: 207309
  - 13
    - copy to throws error 202 I have a table open and have to copy it to a csv: COPY TO (lcStatusFile) TYPE DELI lcStatusFile = "D:\temp\DAWN\load_status_prob_20050208\200501 DAWN_Status_Submittal.csv" The file itself exists, so there should be no problem with the path. When the COPY TO executes I get error: Invalid path or file name (Error 202) I tried this: COPY TO ( JUSTFNAME(lcStatusFile) ) TYPE DELI and it worked. I tried this: ?DIRECTORY( JUSTPATH(lcStatusFile) ) and it was .T. What else can I try? Thanks, Woody Tag: Problem With Vfp8 Tag: 207307
  - 14
    - Vanishing forms I'm upgrading from 3.0b to 9.0. If I show a form with buttons or boxs and attempt to click the option, if the mouse touches the option all contents disappears. I fixed one screen by changing the default Themes to F. That worked for one screen but not others. Also the look of the screen is not that attractive. Any clues??? Tag: Problem With Vfp8 Tag: 207306
  - 15
    - how to remove the AutoInc of a field? Anyone out there knows how to drop the AutoInc of a field? I need to remove this temporarily to udpate this field & set it back. I just need to be able to drop the autoinc feature off for a while. Tag: Problem With Vfp8 Tag: 207305
  - 16
    - The Definitive Chord & Scale Bible - Literally EVERY chord and scale! Finally it exists!! IF YOU PLAY GUITAR, YOU NEED THIS BOOK!! Listen to my story: In the process of teaching myself guitar, I went looking for a book that simply had the all the chords, scales and modes, and nothing else. I was totally surprised to find that such a book didn't exist. There are plenty of places to find this information, but it tends to be spread out over the coarse of a long book or in a poorly organized workbook. I found some of it on the web in the form of calculators and such, but that wasn't helpful since I wanted to practice away from my computer. That is why I created THE ULTIMATE GUITAR RESOURCE, which has LITERALLY EVERY CHORD, SCALE and MODE in an easy to download and print document. Its a full 37 pages for only $3.99! (hardcover is available) What makes this guide even better is that you don't need to read music to use it, so it can help every player at any level. I guarantee you'll use this guide for years! For way less than you spent on lunch, you'll learn: -EVERY CHORD (in every position) -EVERY SCALE, including the jazz and blues scales -ALL THE MODES -LITERALLY EVERYTHING YOU NEED TO KNOW - solo and play chords without reading music today. A free sample is available at: <http://keystone-music.com/> <http://keystone-music.com/> <http://keystone-music.com/> Good luck and God Bless! p.s. I apologize if this message annoys, aggravates, miffs, disturbs, bugs or angers you. I'm actually just a dude who wrote a book that hundreds of people are using and apparently liking very much. While this may fall into a spam-like category, (since I am selling something, and you didn't ask for this message), I think that its not totally over that line since I'm not pitching a porn site, a refinance loan or a cock enlargement. Peace! everychordandscale@yahoo.com Tag: Problem With Vfp8 Tag: 207294
  - 17
    - Strange Problem - Please Help Thanks in advance for the help! I have the following code in the VALID method of a Text control in column in a grid: SELECT TERMS LOCATE FOR ALLTRIM(TERMS.LONG == ALLTRIM(THIS.VALUE) IF NOT FOUND() ... ELSE ... ENDIF When this code executes the locate is failing where it shouldn't. When I put a SET STEP ON above the SELECT TERMS line and step through the code it works correctly. When I put the SET STEP ON inside the IF NOT FOUND() block I observe the following in the watch window: FOUND() is .F. (as you would expect since it is in the NOT FOUND() block) THIS.VALUE is what I am expecting it to be ALIAS() is TEMPTRAN and not TERMS If I go to the command window and type SELECT TERMS LOCATE FOR TERMS.LONG == ALLTRIM(THIS.VALUE) ALIAS() in the watch window changes to TERMS FOUND() in the watch window changes to .T. Does anyone know why this code might be failing when it is not run from within the debugger? Tag: Problem With Vfp8 Tag: 207284
  - 18
    - vfp9 dlls ? This is a multi-part message in MIME format. ------=_NextPart_000_0010_01C50E47.66E5F2E0 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: quoted-printable Hi, what are the royalty free dll files to distribute with vfp application = developed in vfp v9 ? Regards Hoe ------=_NextPart_000_0010_01C50E47.66E5F2E0 Content-Type: text/html; charset="windows-874" 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=3Dwindows-874"> <META content=3D"MSHTML 6.00.2900.2135" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>what are the royalty free dll files to = distribute=20 with vfp application developed in vfp v9 ?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML> ------=_NextPart_000_0010_01C50E47.66E5F2E0-- Tag: Problem With Vfp8 Tag: 207282
  - 19
    - Folder name - short notation How can I get the result from getdir() to be displayed in the short form like c:\locals~1 rather than the long name form 'c:\documents and settings'? I would like to do it in VFP7. Aaron Tag: Problem With Vfp8 Tag: 207280
  - 20
    - OWC10 still stuck One last attempt. I apologize for second post in advance, not trying to inflame I'm simply not up to speed on objects and arrays. Since this should be easy I'm looking for a quick solution here before attempting an outsource. If you feel this post is beyhond the intentions of this group simply don't reply, I'm not here to offend anyone but would like to save a buck if I can! Here's the specification and yes, there is a reason I need to do it this way. Overview: VFP function that creates and exports line chart to "gif" format using OWC10.dll in background using bare minimum VFP 6.0 code. Parameters passed: cDestFile: target GIF destination file name. cDataSource: Comma delimited source file name. Will always have two fields 1.) Data Labels and 2.) Values cTitle: Chart title label cLineColor: Series line color cBackColor: Chart background color lShowLegend: Logical value determines whether to show legend nLabelAlign: Label orientation (0 horizontal, 90 vertical, etc.) Parameters returned (numeric): 0=Failure 1=Success Sample VFP6 code to call this function (MakeChart): && Set parameters cDestFile="c:\Graph.gif" cDataSource= "c:\source.txt" cTitle="My Chart" cLineColor="Red" cBackColor="Black" lShowLegend=.f. nLabelAlign=90 && Call function MakeChart(cDestFile,cDataSource,cTitle,cLineColor,cBackColor,lShowLegend,nLa belAlign) Sample Data Set (c:\source.txt): "Label","Value" "John","36" "Jane","25" "Fred","52" "Mike","65" "Otis","47" TYIA - Ben Tag: Problem With Vfp8 Tag: 207269
  - 21
    - _genxtab doesnt work in compiled EXE file in Foxpro for Dos 2.6 -- _________________________________________ Zahid Maqsood zahidbutt@onlinestiching.com zahidbutt@hotmail.com zahidbutt@yahoo.com itmanager@crescentsugar.com Tag: Problem With Vfp8 Tag: 207266
  - 22
    - Zipping in WinXP Friends, Some months ago (on 14th Dec 2004) there was a posting of code for Zipping in Window XP (code is appended below), it is working fine if 1. I compress a complete folder (giving only path of the folder) 2. I compress a complete folder (giving wild card like - "C:\myproject\*.*" as source) 3. I compress a ZIP file again However we get an empty ZIP folder if we want to zip ONE specific file in a folder, like we do not get desired results if we give "C:\myproject\test.txt" as source. I will appreciate any further guidance about how to compress only SPECIFIED files from a folder. Regards S Bans ************************* Cheap and build in to Windows XP. Use the Windows Shell to Control Zip folders Ex: ZIP("C:\myproject\*.*", "C:\Temp\MyZipFile.ZIP") You even get the flying folders animation PROCEDURE ZIP(lcFromFileOrFolder AS STRING, lcZipFile AS STRING) LOCAL lcEmptyZip AS STRING LOCAL oSHELL AS SHELL.APPLICATION lcEmptyZip = "PK"+CHR(5)+CHR(6)+REPLICATE(CHR(0),18) TRY oSHELL = CREATEOBJECT("Shell.Application") IF NOT EMPTY(lcZipFile) lcFullName = FULLPATH("&lcZipFile.") IF UPPER(JUSTEXT(lcFullName)) <> "ZIP" lcFullName = lcFullName + ".ZIP" lcFullName = STRTRAN(lcFullName,"..",".") ENDIF IF FILE("&lcFullName.") IF MESSAGEBOX("File "+lcFullName+" already exist Override?",256+64+4,"Warning") <> 6 EXIT ELSE DELETE FILE "&lcFullName." ENDIF ENDIF IF STRTOFILE(lcEmptyZip, "&lcFullName.") <> 22 = MESSAGEBOX("Error creating " + lcFullName, 16, "Zip file creation error") EXIT ENDIF ELSE = MESSAGEBOX("No Zip file name specified",16, "Missing info") EXIT ENDIF IF NOT EMPTY(lcFromFileOrFolder) lcFromFileOrFolder = FULLPATH("&lcFromFileOrFolder") TRY loFolder = oSHELL.NameSpace("&lcFromFileOrFolder.") IF ISNULL(loFolder) && not full folder lcFolder = JUSTPATH(lcFromFileOrFolder) loFolder = oSHELL.NameSpace("&lcFolder.") IF ISNULL(loFolder) = MESSAGEBOX("Invalid Folder name",16,"Error") EXIT ELSE loFolder = loFolder.ITEMS() loFolder.FILTER(-1, JUSTFNAME(lcFromFileOrFolder)) ENDIF ENDIF loZipFolder = oSHELL.NameSpace("&lcFullName.") IF NOT ISNULL(loZipFolder) loZipFolder.CopyHere(loFolder) DECLARE INTEGER "FindWindow" IN WIN32API; STRING @lpClassName, STRING @lpWindowName WAIT "" TIMEOUT 3 DO WHILE .T. lnHWnd = FindWindow("#32770","Compressing...") IF lnHWnd <> 0 WAIT "" TIMEOUT 1 ELSE EXIT ENDIF ENDDO ENDIF CATCH TO oexception ? oexception.lineno, oexception.errorno, oexception.message ENDTRY ELSE = MESSAGEBOX("No files to ZIP",16, "Missing Info") ENDIF CATCH FINALLY ENDTRY ENDPROC Tag: Problem With Vfp8 Tag: 207265
  - 23
    - Unzip WinXP Friends, Some months ago there was a posting of code for UNZipping in Window XP (code is appended below), it is working fine, however it creates an EXTRA folder under: C:\Documents and Settings\USER\Local Settings\Temp\ by the name of Temporary Directory 1 for UNZIPPEDFILE.zip Temporary Directory 2 is also created if the same file is unzipped again. After repeat runs on the same file, we may start getting curious results and messages. It we unzip big files, then the Hard Disk can get filled up without our knowledge. It there some solution so that this folder is either not created or deleted automatically after unzipping. I will look forward to have your comments. Best Regards S Bans ***************** PROCEDURE UnZIP(lcZipFile AS STRING, lcToFolder AS STRING) * LOCAL lcEmptyZip AS STRING LOCAL oSHELL AS SHELL.APPLICATION lcEmptyZip = "PK"+CHR(5)+CHR(6)+REPLICATE(CHR(0),18) TRY oSHELL = CREATEOBJECT("Shell.Application") IF NOT EMPTY(lcZipFile) lcFullName = FULLPATH("&lcZipFile.") IF UPPER(JUSTEXT(lcFullName)) <> "ZIP" lcFullName = lcFullName + ".ZIP" lcFullName = STRTRAN(lcFullName,"..",".") ENDIF IF NOT FILE("&lcFullName.") = MESSAGEBOX("Zip File "+lcFullName+" not found",16,"Error") EXIT ENDIF ELSE = MESSAGEBOX("No Zip file name specified",16, "Missing info") EXIT ENDIF IF NOT EMPTY(lcToFolder) lcToFolder = FULLPATH("&lcToFolder") TRY loFolder = oSHELL.NameSpace("&lcToFolder.") IF ISNULL(loFolder) && does not exist (create) MKDIR "&lcToFolder." loFolder = oSHELL.NameSpace("&lcToFolder.") ENDIF loZipFolder = oSHELL.NameSpace("&lcFullName.") IF NOT ISNULL(loZipFolder) lnZipFileCount = loZipFolder.ITEMS.COUNT lnFileCount = loFolder.ITEMS.COUNT loFolder.CopyHere(loZipFolder.ITEMS) && unzip executes asynchronously ENDIF CATCH ENDTRY ELSE = MESSAGEBOX("No files to ZIP",16, "Missing Info") ENDIF CATCH FINALLY ENDTRY ENDPROC Tag: Problem With Vfp8 Tag: 207264
  - 24
    - remove read only attribute--please help how can I remove read only attribute of a label.lbx (label file type) before I replace new information into label.lbx. THANY YOU Ming Tag: Problem With Vfp8 Tag: 207261
  - 25
    - user-adjustable reports I have reports with one record in a tall detail band, no header, footer, title, nor summary. These are intended to be printed on pre-printed forms, with the text boxes filling in the blanks. As expected, there are alignment differences for different users using different printers. Alignment between the individual controls does not change, but margins do. I can allow the user to edit the report, but these users are not particularly computer savvy. I have grouped all the controls on the report, and I would like to allow the user to specify something like "move everything up 1/8 inch and right 1/4 inch", then have the app make the adjustment. Can this be done with report listeners? Or is it best to hack the report? Something like REPLACE hpos WITH hpos + 10 FOR objtype = 8 Or, since I have grouped the controls, is there a simple way to reposition the group? How are groups represented in the frx? Tag: Problem With Vfp8 Tag: 207243

Hi 2 all.
The vfp8 exe file are not runing when i bulid this project into vfp7 it runs.
i copy all vfp8 dll files into project directory.i have winxp install.

waiting for good reply

--
Qaiser Me

Top

Re: Problem With Vfp8 by Wolfgang

Wolfgang
Sun Feb 13 06:46:53 CST 2005

Hi!

IMHO you should go to ftp.prolib.de/public/VFP8SP1RT.EXE to get a
installable runtime enviroment.

--

------------------------------

Mit freundlichen Güßen aus der Zigarrenstadt

Wolfgang Schmale

------------------------------------------------
"QaiserMehmood" <qaiserme@fastmail.fm> schrieb im Newsbeitrag
news:897CC6FE-191F-4370-BFB8-7AA0ABE84887@microsoft.com...
> Hi 2 all.
> The vfp8 exe file are not runing when i bulid this project into vfp7 it
> runs.
> i copy all vfp8 dll files into project directory.i have winxp install.
>
> waiting for good reply
>
> --
> Qaiser Me

Top

Re: Problem With Vfp8 by David

David
Sun Feb 13 11:05:43 CST 2005

Qaiser,

What error messages are you getting?

--
df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro

"QaiserMehmood" <qaiserme@fastmail.fm> wrote in message
news:897CC6FE-191F-4370-BFB8-7AA0ABE84887@microsoft.com...
> Hi 2 all.
> The vfp8 exe file are not runing when i bulid this project into vfp7 it
> runs.
> i copy all vfp8 dll files into project directory.i have winxp install.
>
> waiting for good reply

Top