ftp and vfp

Visual FoxPro General

‹ Visual FoxPro
- Archive
  - VFP
  - Smart Device
  - Windows Vista
  - Windows Live
  - Game
  - VS 2008
  - IE
  - Visual Studio
  - Visual C#
  - VB
  - SQL Server
  - Dotnet
  - Office
  - VS Express
  - Windows Forms
  - SharePoint
  - ISV
  - Architecture
  - VC++

- Previous
  - 1
    - "Multiple-step operation generated errors. Check each status value." I am getting the following error when trying to update an existing Foxpro database using the VFPOLEDB.1 provider and ADO: "Multiple-step operation generated errors. Check each status value." I have tried about every combination of cursor types and locations but cannot get it to work. Here is my code: Dim ADODBConnection As New ADODB.Connection() ADODBConnection.ConnectionString = "Provider=VFPOLEDB.1;Data Source=F:\xmgmt\data\client.dbc" ADODBConnection.Mode = ADODB.ConnectModeEnum.adModeReadWrite ADODBConnection.Open() Recordset = New ADODB.Recordset With Recordset .ActiveConnection = ADODBConnection .CursorType = ADODB.CursorTypeEnum.adOpenDynamic .CursorLocation = ADODB.CursorLocationEnum.adUseClient .LockType = ADODB.LockTypeEnum.adLockOptimistic .Open( "SELECT recordnumber FROM [events] WHERE recno <=0" ) End With Dim CurrentRecordNumber As Integer = 0 While Not Recordset.EOF CurrentRecordNumber += 1 Recordset.Fields.Item( "recordnumber" ).Value = CurrentRecordNumber 'The field 'recordnumber' is of type 'Numeric' Recordset.Update() 'This is where I receive the error Recordset.MoveNext() End While Any help would be greatly appreciated. I have searched all over the web for any answer but have come up with nothing. Steve Tag: ftp and vfp
  - 2
    - Remote View Select table1.field1,table1.field2,iif(isnull(table2.field1,spac(10),table2.field1) as Name From table1 left join table2 ................... What i want to ask is how to do IIF part when using remote view Can I use the same Select in Remote View Or may be there is another command to use to substitute the IIF when using Remove View Tag: ftp and vfp
  - 3
    - New Word breaks old DDE code A user of our legacy VFP 7 app is finding that the program blows up on the following DDE command being sent to Word 2003 SP2. Older versions of Word 2003 handle the command with no problem. maxed= DDEExecute (ddehandle,"[If AppRestore()=0 Then AppRestore]") Any idea where the last few living DDE experts hang out Tag: ftp and vfp
  - 4
    - userprompt How to promt user to enter the date in prg file. once it is entered i would like to save it to variable. I am using vfp6.0 Tag: ftp and vfp
  - 5
    - Server Name? Dearest Friends, FoxMasters, Geeks and/or venerable MVPs, Looking at Sys() commands, etc. I can't seem to be able to 'display' a name for the LAN Server(s). Sys(5) works for the "Drive" of course, but Sys(5) fails to be meaningful for a Server Name : ...eg. "DellDimension4300", "Martha", "Ivan", "MyLanServer", etc. I've searched help files repeatedly to just find a way to display the lan-server name, but failed. (As always, much thanks and respect for your precious time and thoughts.) Tag: ftp and vfp
  - 6
    - Removing Tomb Hi, An VFP application form is closed with the right upper corner x sign. User does not aware the application has not been terminate completely. A tomb xyz.exe remain unclosed. Since "close all" can not be used, what else can avoid the tomb formation (Thisform.release or else ) Regards, Bit Tag: ftp and vfp
  - 7
    - how could i close a program with-in VFP? Good day to all How could i close an open program (ex. word, excel or any open program) from VFP thank you very much for any help Tag: ftp and vfp
  - 8
    - Updating DBF from SQL server Hi to everyone. I have the following issue; I need to update some information in DBF files but with a SP from SQL server. I have a linked server in my SQL server pointing to DBF directory. When I execute the following commands, I get everything ok: Select * from LinkedServer...mytable Insert into LinkedServer...mytable values('fiel1',’field2','') But when I execute Update and Delete commands I get the following message: Could not fetch a row using a bookmark from OLE DB provider 'VFPOLEDB'. Can anybody help me L I’m using the latest VFPOLDB driver… Tag: ftp and vfp
  - 9
    - keyboard {leftarrow} Dear Experts, The previous post was incompleted, sorry. I am working on a data entry grid with 20 columns, when the user reach the last record and press down arrow, then append blank and move the cursor to column1 of the new record, I put the following code in keypress event : If nKeycode = 24 select cr_1 appe blank thisform.grid1.SetFocus _col = thisform.grid1.ActiveColumn for a = 1 to _col - 1 keyboard "{leftarrow}" endfor endif _col showing a correct value but the cursor only moved left once, no matter what the current column is! Any suggestion will be appreciated and thank you for your time. Milton Tag: ftp and vfp
  - 10
    - form in add mode hi! i am new in foxpro some one help me out for this problem from my main menu to add new record (one to many) in form , form open good but it show me a first record i need append should blank and cursor need in first field Tag: ftp and vfp
  - 11
    - VFP Fax Integration Hi, I tried #2 method and stuck. Then I tried #1 method, it works for report with graphic. However, I need a way to pass parameters to Send Fax Wizard. Thanks for your help. Emery ------------------------------------------------------------------------------------------------------------------------------ Method #1: When I used the following code to fax a report (which also contains graphic/image), Windows XP Send Fax Wizard came up: .... SET PRINTER TO NAME 'FAX' REPORT FORM (fform) TO PRINTER Does anyone know how to programmatically pass recipient's info (name, fax #, etc) to Send Fax Wizard ------------------------------------------------------------------------------------------------------------------------------ Method #2: The following codes work only for pure ASCII text: ..... myFaxDocument = createobject("FaxComEx.FaxDocument") myFaxSender = myFaxDocument.Sender myFaxSender.LoadDefaultSender() myFaxDocument.Subject = "Test" myFaxDocument.Recipients.Add(faxnumb, name) REPORT FORM (fform) TO FILE (faxFile) ASCII myFaxDocument.Body = (faxFile) myFaxDocument.Submit(ServerName) ...... However, if I omit ASCII option (my report alos contains image/graphic), it printed out PCL text if I name the output file using '.txt' extension. (This is because the report got rendered is of printer driver format, in my case PCL). It failed if I name the output file using '.pcl' extension because FaxDocument.Body only supports .txt, .doc and .xls extensions, Does anyone know how to resolve it ---------------------------------------------------------------------------------------------------------------------------- Tag: ftp and vfp
  - 12
    - Problem selecting a font in Visual Foxpro 9.0 When I select the FontName property in the Property window, my default font Arial has disappeared from the selection list above. Arial is corrected installed in my system and I can select it in any other application, even with getfont() in the command window. Any idea Thanks. P.D.: My english is not so good. Sorry. Tag: ftp and vfp
  - 13
    - Installshield error (neophyte "programmer") I have developed a VFP prg file and built an exe file, both of which run without errors. I want to distribute the exe file to another location. I am attempting to use InstallShield for the first time. After building the installation program I attempted to test it. The installation program stops before completion, with an error dialog which states "Internal error 2602," then names the exe file which was to have been installed. Can someone help me understand what I have done wrong Thanks. Tag: ftp and vfp
  - 14
    - ERROR FOXPRO WHY EVERTIME I REBOOT MY P.C GET BOX MESSAGE, CANNOT LOCATE M.S VISUAL FOXPRO SUPPORT LIBARY Tag: ftp and vfp
  - 15
    - CursorAdapters and UDF in FoxPro 9 Hi, I like to know if is possible to create a Cursoradapter (ADO) with a select CMD using a function. For example if I have a function concat(par1,par2) that returns par1+par2. I like to use as select command something like select concat(lastname,firstname) as name from personal Thanks Ivan Tag: ftp and vfp
  - 16
    - Determining if multiple EXCEL spreadsheet tabs exist before import Is there a way to determine if an EXCEL spreadsheet contains multiple tabs, and if so, bring back the name of each tab in order to select the one that you want to import data from I'm trying to import data into VFP from EXCEL, and normally use the IMPORT function and identify the spreadsheet tab by name. This time, I want to know 1) the total number of tabs in the spreadhsheet, and 2) the names of the various tabs found in the spreadsheet. This will let me choose which one I'd like to import the data from. Any help or suggestions to accomplish this would be appreciated. Thanks. Tag: ftp and vfp
- Next
  - 1
    - Foxpro7 crashing with "fatal error exception code=c0000005 ..." Hi I have a tricky issue in my VFP7 application. At least tricky for me. The application is crashing with fatal error C0000005. Sometimes I see a message like this one in the eventlog: "Faulting application <appname>.exe, version 1.4.82.0, faulting module ntdll.dll, version 5.1.2600.2180, fault address 0x00010f29.". Sometimes the application just hangs. I also see the Windows error "The instruction at "0x...." referenced memory at "0x.....". The memory could not be "read"", and then the application is closed, of cource. The error does only appear in situations where I print, but it does not occur in an exact pattern, or when I pass a particular code line. I use a third party dll called foxpp.dll (fox power printer) to get my "hands" on the windows printernames and properties. (I don't think the supplier exists anymore ). Since the crash does not occur when i run a particular line of code, and even sometimes when i close a window, it is hard to tell the exact reason. I am suspecting the printer dll, but it might also be other reasons. Does anyone know of a tool (or a method) to find the point where the illegal memory access occurs The error seems to appear more often after a couple of consecutive prints. So I am thinking that a "reset" of the print objects (the loaded dll) might be a way to reduce the problem, if not removing it. Any hints how to do this "reset" in a good way Helpful hints are highly appreciated on this "blurred" question :-) Best regards, Endre Tag: ftp and vfp
  - 2
    - SQL query too long doesn´t work with SQLEXEC() Hi fellows! I’m doing a big sql query with 2 memory variables (cSQL and cWhere). Something like this: cSQL = "Select ....From.....Inner Join...." cWhere = "Where field1 like '%" + upper(textbox1.value) + "%'" + "Or field2 like '%" + lower(textbox2.value) + "%'" ...and so on until I can check out several possibilities of writing. Something like 30 fields that I verify 5 possiblities for each one. A big query! Then I do: cSQL = cSQL + cWhere SQLEXEC(myConnection, cSQL, "cursorName") Man! It doesn’t work! And i do the same query on console (I use both Firebird and SQL Server) and it returns my records. I don’t know what to do. I think it’s related to 255 characters limitation per query, am I right If so, how to concatenate this "monster" together and send to database !!! Thanks a lot, Everton Tag: ftp and vfp
  - 3
    - new to FoxPro...in search of answers Let me start by saying I've never used FoxPro. A client is looking at converting a FoxPro db to SQL Server (or Oracle) and I need to do a cost analysis for it. Since I'm not familiar with FoxPro, I have no clue what it would take to convert. The client application has an interface to update the data. Is it possible to keep the same interface but change the backend db to SQL Server Also, what is the best way to convert the FoxPro data to SQL Server Looks like there are 161 .dbf files. Any info to get started would be great! Tag: ftp and vfp
  - 4
    - Some questions about VFP 1) When i delete a record from VFPs table, it is marked as deleted but not deleted permanently. How to delete permanently 2) How to select select the records that are not marked in a table 3)iF i use 'Clear' method in a form, the control that are placed on form start vanishing, how to stop that Tag: ftp and vfp
  - 5
    - Creating a folder using VFP6 I have a query within a loop that will be creating many files. It is based on a (variable) 'where clause'. What I wanted to do was to grab the first 3 characters of the (numeric) variable 'where clause', and create a folder named with that variable, and place the results of the query in that folder. I think I can get the program to work if I figure out how to tell VFP to create a folder named as part of a variable. ie. 'a' is the variable that changes each time in the loop. It is a numeric value. i want to grab the substring of a [eg.: b = subs(a,1,3) ] and create a folder named whatever b is storing and put the results of the query in it (probably use an if statement or something) Any help would be greatly appreciated. Thanks Tag: ftp and vfp
  - 6
    - Retrieve Recno() of a newly inserted row into a table You'll have to bear with me as I am not very well versed in databases in general, but even more so with Foxpro. I am using the latest Foxpro OleDB driver and need to find a way to retrieve the recno for a newly inserted row into a table. I have tried the following, assuming that the newly inserted row would be the last one in the table but this does not seem to work as I thought it would. "select recno() as Oid from [TableName]". This is returning the recno of the first item in the table that is not marked for deletion. Any help would be greatly appreciated. Thanks, Steve Tag: ftp and vfp
  - 7
    - MSCHRT20.ocx erro I have just restored a machine in which a program is loaded for testing. (I am not the programmer I was just hired). When I try to start the program i get the following error; mschrt20.ocx or one of its dependencies is not correctly registered. I did a full restore from backup to the new machine. The program will not start. Any Ideas I am not a seasoned programmer I am a network administrator. Your help is greatly appreciated. Thanks Christina Tag: ftp and vfp
  - 8
    - ActiveX control with FoxPro I have an MFC ActiveX control with support for SimpleFrame. I added OLEMISC_SIMPLEFRAME for MiscStatus and call EnableSimpleFrame in the constructor. I used this control in MFC and Vb and it works fine. but when I used it in FOXPro, I get a problem with scroll bars. but if I comment out EnableSimpleFrame the scroll will work fine with Fox Pro. Tag: ftp and vfp
  - 9
    - CONFIG in top-level application Hi, I am using VFP6.0. Acouple of questions about application creation. 1) I notice a config.fpw is created in the progs area by the application builder, which is presumable just for setting up config for this application. If i modify the fpw by putting a 'Command = XXX' line in it and generating the application then it doesn't seem to run the command when the app starts. Similarly using the _STARTUP = "XXX.prg" doesn't seem to run the prog specified either. In both cases the application starts to the desktop and goes straight to the menu system and waits for user input. What am I doing wrong Thanks. 2) I have chosen to use the user logins option for the application. It is working well but where do i administer the user database from Thanks Don Tag: ftp and vfp
  - 10
    - unique hi! please help me out for this problem is it possible scan image from scanner for perticular size cos when i scan it scan blank space too and also in my table have like 10 field with id is primary key but i need one field no duplicate (e.g if driver Lic # i need unique no , no duplicate ) thanks Tag: ftp and vfp
  - 11
    - Problem selecting a font in Visual Foxpro 9.0 When I select the FontName property in the Property window, my default font Arial has disappeared from the selection list above. Arial is corrected installed in my system and I can select it in any other application, even with getfont() in the command window. Any idea Thanks. P.D.: My english is not so good. Sorry. Tag: ftp and vfp
  - 12
    - InstallShield vaporized project? (neophyte user) I generated a VFP prg and build an exe version which run without errors. I then attempted to use InstallShield to prepare for distribution to another site (I am completely inexperienced with InstallShield), but the test installation halted before completion and provided an error code. NOW I FIND THAT MY PROJECT, WITH ALL TABLES, FORMS, AND REPORTS NO LONGER EXISTS. Have I so offended the InstallShield gods Is there life after death Is it possible to recover the lost files Tag: ftp and vfp
  - 13
    - SQL Join question. Hi; I have 2 tables. polgr.dbf and po.dbf. I want to query all the records from polgr and some matching info from PO. The problem is that in some cases there will be 2 records in PO with the same PO#. The following query produces duplicates if there are 2 records matching in PO. select polgr.qopen,po.acct from polgr left join po on polgr.pono = po.pono Is there a join condition or other way to avoid the duplicates Thanks. Tag: ftp and vfp
  - 14
    - Fax Report Using VFP9 As resolved in "VFP Fax Integration" thread , I have been using Jaime's method to fax Reports with graphic/image and it works very well for VFP6. set printer to name "Fax" report form myReport to file "myfile.tif" noconsole Recently I compiled and ran my program using VFP9, I got the following Program Error: OLE IDispatch exception code 0 from FaxComEx.FaxDocument.1: Operation failed... I found out my VFP9 program will work without error if I select Fax device in 'Printer and Faxes' window and 'Set as Default Printer' before running it (I don't need to do this with VFP6). But it is not a good solution. Does anyone know how to best resolve the problem Thanks, Emery Tag: ftp and vfp
  - 15
    - replace image with own name hello! is any way replace my image with include reeno or any field data like i take image from my webcame and it store in one folder after that i use replace command so it save path in my field but when i replace that time image name want to change here is my code below DO [C:\Program Files\EZTwain\VFP\EZTwain.prg] TWAIN_SelectImageSource(0) * Get list of devices into memory TWAIN_GetSourceList() LOCAL lcFile, lnImageHandle, lnReply lcFile = "C:\Documents and Settings\sony\My Documents\New Folder (2)\PHOTO\.BMP" * Get the image lnImageHandle = TWAIN_AcquireNative(0,0) * Write the image to a disk file lnReply = ; TWAIN_WriteNativeToFilename(lnImageHandle,lcFile) * Release the image handle TWAIN_FreeNative(lnImageHandle) * Check for errors IF lnReply = 0 * image successfully written to file ELSE * something went wrong ENDIF clear resources thisform.image1.picture = m.lcFile REPLACE TABLE1.IMAGE WITH THISFORM.IMAGE1.Picture Tag: ftp and vfp
  - 16
    - Linking Foxpro table to Access 2003 I am trying to link a foxpro table in Microsoft Access 2003 using ODBC. The package I'm linking to is in VFP 9 (I believe). When I do the link, and then try to open the table, it says: "The field is too small to accept the amount of data you attempted to add...." When I view the structure in Access, I notice that there are several binary fields. When I query the table specifically leaving out the binary fields, I don't get the error. These fields would normally be character fields since they contain addresses, phone numbers and zip codes, but for some reason they used a binary field instead of character fields. These fields do not appear to be memo fields since they have a length on them such as 12, 15, etc. I can open this table up in Excel and I see the data in those fields and it appears to be the hex version of the character data. How do I read this information in Microsoft Access Thanks in advance for your help. Tag: ftp and vfp

jmom

I know very little about ftp's, so please bear with me. Can vfp dbf's or reports be transferred through ftp or does it do better being formatted into excel

Top

Re: ftp and vfp

CetinBasoz

FTP is File Transfer Protocol and could be used to transfer any type of file.

DBFs are files so you could transfer them. Reports are files from one point of view (their definiton are in .frx files). However a report output can be a file or not (a postscript,ASCII,html etc).

Developers generally prefer to output to a PDF or HTM to send it over to an FTP or email client.

Top