Paul B Walker
When a COPY File Command is executed and a space is in either a folder name or a file name, the instruction is unable to handle it. I have tried a technique to put in " quote marks in the manner '"<path><filename>"' but then it gives me a syntax error. Is this a bug or am I entering the full path and filename wrongly
If this is a known bug, is there a patch for it
If not, how do later versions of VFP do with this "bug"
Copy File Error in Visual FoxPro 7?
Visual FoxPro General
-
- Previous
- 1
- 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: Copy File Error in Visual FoxPro 7?
- 2
- 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: Copy File Error in Visual FoxPro 7?
- 3
- 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: Copy File Error in Visual FoxPro 7?
- 4
- 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: Copy File Error in Visual FoxPro 7?
- 5
- 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: Copy File Error in Visual FoxPro 7?
- 6
- 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: Copy File Error in Visual FoxPro 7?
- 7
- 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: Copy File Error in Visual FoxPro 7?
- 8
- 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: Copy File Error in Visual FoxPro 7?
- 9
- 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: Copy File Error in Visual FoxPro 7?
- 10
- 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: Copy File Error in Visual FoxPro 7?
- 11
- 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: Copy File Error in Visual FoxPro 7?
- 12
- 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: Copy File Error in Visual FoxPro 7?
- 13
- 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: Copy File Error in Visual FoxPro 7?
- 14
- 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: Copy File Error in Visual FoxPro 7?
- 15
- 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: Copy File Error in Visual FoxPro 7?
- 16
- how to store encrypted passwords .. is there some kind of algorithm in fox that can store and encrypted password so that if anyone got a hold of the data they couldn't read the password. Thanks in Advance Tag: Copy File Error in Visual FoxPro 7?
- 1
- Next
- 1
- SQL Select help. Hi; I'm using this command: SELECT polgr.pono,po.podate as podate,polgr.design,polgr.qopen,IIF(isnull(poarrivals.design)," ","Y") ; FROM; krcbp!polgr ; LEFT JOIN krcbp!po ; ON polgr.pono = po.pono ; LEFT JOIN poarrivals ; ON polgr.pono = poarrivals.pono ; WHERE polgr.design = "SU-115" AND polgr.qopen <> 0; ORDER BY podate But I'm trying to get only the FIRST result from the poarrivals table. I need to show "Y" if there are any entries in the poarrivals table. Instead, I'm getting multiple results (Because there are multiple entries in the poarrivals table) I tried to use group by but I was getting errors. Can someone give me the right syntax Thanks. Tag: Copy File Error in Visual FoxPro 7?
- 2
- need help converting printing from foxpro 2.1 Unix to VFP 7.0 Hi , I need to transfer a printing program from foxbase 2.1 for Unix to VFP 7.0.... The usage is the following, on the unix system, the employes are entering a 2 digit number on a client table so he can receive a specific letter i have a client table with name, address etc... i have a second table with the different letters each line of the letter is a field by itself all the output to the printer is made with @x,y say variable or @x1,y1 say "text message" the output on paper contains bold, underlines, double height, double width all generated by the control characters sent directly to the printer, when the program is executed, i have about 300 letters going out to clients and they are not the same depending on the employee request. I guess i'm getting old but is there an easy way to convert this so i can use it with VFP If not, can somebody give me a hint a a sample of a prog so I can understant please...... Thank's Tag: Copy File Error in Visual FoxPro 7?
- 3
- Visual Foxpro Grid is hiding something from me :( ok ! I have a form with a pageframe and two pages. i have a grid on page 1 for sales_items. i have two MySql tables 'sales' and 'sales_items'. i have set the allowaddnew property of the grid to .T. . try to add a new record to the grid and save it (it works fine) now on the grid press the down arrow more than 4 times so that it will look like ur adding more than 4 new records, and then run the update on both tables and walah ! the grid loses its data, but if you browse the table using a button or something, you will see that the data is actually still there but the grid wont show it. here is a sample of how i requery my child table. Please read the notes with a NOTE marker ThisForm.pageframe1.page1.Grid1.RecordSource="" NOTE the problem starts here, after the grid1 recordsource is set to "" after this, grid hides the content NOTE the grid is set to "" before requerying the sales_items table to retain the actuall layout of the grid lcSQLStmt="Select * from sales_items where TRIM(s_ctrl)='"+ALLTRIM(sales.s_ctrl)+"'" =sqlexec(lnHandle,lcSQLStmt,"sales_items") IF !make_updatable("sales_items","si_uid","sales_items","",.F.) =MESSAGEBOX("sales_items",0,"c") ENDIF with ThisForm.pageframe1.page1.Grid1 .RecordSource="sales_items" NOTE here we set the recordsource back, u can even place a messagebox here to see if the grid recordsource NOTE has been updated (it is updated) but the grid doesnt show anything .columns(1).controlsource="sales_items.is_code" .columns(2).controlsource="sales_items.is_Ctrl" .columns(2).combo1.requery() .columns(3).controlsource="sales_items.emp_Ctrl" .columns(3).mycombobox1.requery() .columns(4).controlsource="sales_items.si_qty" .columns(5).controlsource="sales_items.si_price" .columns(6).controlsource="sales_items.si_amount" .columns(7).controlsource="sales_items.si_discount" .Refresh ENDWITH what is weird is that from my button "ADD" "EDIT "SAVE" "CANCEL" ,after the grid shows no sign of life and i press SAVE (still nothing) , and then press ADD and CANCEL the grid shows its contents back , but i cant keep on simulating the ADD CANCEL buttons everytime i execute the SAVE button , this could decrease the performance of my applications especially if im using Large Tables. NEED HELP PLSSS any1 T_T Tag: Copy File Error in Visual FoxPro 7?
- 4
- How to show properties window to a file in foxpro Hi I want to show the properties window to the file selected by user on right click -> properties option. (as this is shown with any file when we right click on that file and click on properties option in widows explorer) If anybody knows about it , please tell me how to do this If any one knows to do this in Visual Foxpro then it will be good for me. Tag: Copy File Error in Visual FoxPro 7?
- 5
- Get column name in SQL query How can i obtain all the records in a specific column like: select field1 from table but instead of the name "field1" use a column number i'm guessing : select 2 from table // The number 2 being the third column (starting at 0)... is this the right way Thanks. Tag: Copy File Error in Visual FoxPro 7?
- 6
- Autoincrement and default values with Foxpro tables and ADO CursorAdapters approach ?? Using VFP 9 SP1 is very easy and powerfull to connect to different Database providers (SQL Server, Oracle, etc.) using ADO Cursoradapters (CA). Using ADO CA we can retrieve from the database server the values for Autoincrement fields and the default values if there are defined and woks just fine. The question that I have is there is possible to do the same using Foxpro Tables: to get in the CA the values for Autoincrement and default values Thanks Ivan Tag: Copy File Error in Visual FoxPro 7?
- 7
- Combo LOCAL nCnt FOR nCnt = 1 TO thisform.cboCourse.ListCount IF thisform.cboCourse.List(nCnt) = ALLTRIM(a_Courses.CourseName) thisform.cboCourse.Selected(nCnt) = .t. ENDIF ENDFOR But selected item is not apearing on top of the combo's list. Tag: Copy File Error in Visual FoxPro 7?
- 8
- is it possible to bold a section of a textbox in a report? I have a sentence that needs a portion of field bolded. ie. "I need this portion bolded." I've only managed to create three text boxes and put them all together. It's kind of a pain. I thought maybe there was an easier way. thanks in advance Tag: Copy File Error in Visual FoxPro 7?
- 9
- datatype casting Hi, I want to know how to convert or cast a string to an int. Thanks Tag: Copy File Error in Visual FoxPro 7?
- 10
- Get column name in SQL query How can i obtain all the records in a specific column like: select field1 from table but instead of the name "field1" use a column number i'm guessing : select 2 from table // The number 2 being the third column (starting at 0)... is this the right way Thanks. Tag: Copy File Error in Visual FoxPro 7?
- 11
- SQl Select question I have a problem that I hope there is a solution. I am trying to search through several tables to find records that match the data the user enters. On finding the records, I want to be able to show that information in a list box on the form. For eg, the user will enter a customer number they are looking for and I then have to search through several tables to find the records that are tied to this customer number. The structure of each table is the same, it is that some of the files are archived tables which I have to search through. Initially I had a SQL select statement but that was when I had all the information in one file and I didnt start archiving the data into other tables. I tried running the sql select and sending the information to a text file with additive at the end but I cannot find out how to access the records to show in the list box. Also for each addition to the text file, the headings of the fields are being repeated. If anyone has any suggestions it would be greatly appreciated. Thanks. Tag: Copy File Error in Visual FoxPro 7?
- 12
- Forum Usage Since this thread has gone off-topic, may I please ask few questions about this forum usage. 1) How can I see replies in the chronological order E.g. I only want to see the latest replies but I can not figure out how to do it. 2) Can I turn off Alerts for good I often forget to uncheck them when posting a message. 3) Why most of the messages appear in a very small unreadable font and how can this be made better 4) Why quite often the latest replies do not appear for quite a long time, as it was few days ago Thanks a lot in advance. Tag: Copy File Error in Visual FoxPro 7?
- 13
- field valid method pl.help what i am doing wrong cos when i add new dl_no( my field name) it same message coming " already exists" i want to seek dl_no in checkcust table and if found get the message and focus on same field and if not the go to next field SELECT CHECKCUST SET ORDER TO DL_NO && DL_NO SEEK dl_no IF FOUND() =messagebox("ALREADY EXISTS") return .F. ELSE ENDIF Tag: Copy File Error in Visual FoxPro 7?
- 14
- File In Use Trying to execute a delete command from .NET with OleDb driver I get an error: File in Use. It seems strange that a similar command appeared to have executed once before. That command is downstream of this one and that worked while the code around this one was not yet debugged and this ExecuteNonQuery was simply bypassed cmdm . CommandText = "execscript('USE crossRefTable in 0 EXCLUSIVE ' + chr(13) + chr(10) + ' SELECT [crossRefTable]' + chr(13) + chr(10) + ' " + comndText + "' + chr(13) + chr(10) + ' PACK' )" ; Console . WriteLine ( cmdm . CommandText ); cmdm . ExecuteNonQuery ( ); The comndText string is built by a StringBuilder and the resulting overall CommandText (from a Console printout) looks like this: execscript('USE crossRefTable in 0 EXCLUSIVE ' + chr(13) + chr(10) + ' SELECT [crossRefTable]' + chr(13) + chr(10) + ' DELETE FROM crossRefTable WHERE (pointer_one = [C000149] and pointer_two = [C004116]) ' + chr(13) + chr(10) + ' PACK' ) Any hope for any insight Thanks. Tag: Copy File Error in Visual FoxPro 7?
- 15
- Refresh the whole column of 'Amount' on the grid Hi all I have a textbox, namely p2_labhr and a grid, namely dqqrid that contains 3 columns (Product Code, No. of Hours, Amount). There is details displayed on the grid. IĄ¯m citing an example as below. Labour Hour : {textbox - p2_labhr ~~ *input: 100*} Product Code No. of Hours Amount AA1 3 300 BB2 4 400 CC3 2 200 DD4 1 100 The user wants to amend from 100 to 300 in the textbox. I like to see the whole column of Amount on the grid after the user changes the value in the textbox. I tried this coding as below. It refreshes only one row instead of the whole column of Amount on the grid. LostFocus procedure of p2_labhr object select tdepotq *RecordSource of grid goto top do while .not. eof() if not empty(p2code) p2amount = (this.value*p2hours) endif skip enddo goto top So, I need your help to correct my coding to achieve to refresh on the whole column of Amount on the grid. Thank you. Tag: Copy File Error in Visual FoxPro 7?
- 16
- delete currant rec hi! i am new in vfp here is my problem when i delete it delete first record in table not which i view (or currant record) here is code #DEFINE MSGBOX_YES 6 #DEFINE C_MSGBOX1 36 #DEFINE C_DELETE1_LOC "Are you sure you want to delete this customer - " #DEFINE C_DELETE2_LOC " " lcMessage = C_DELETE1_LOC + ALLTRIM(CHECKCUST.First_NAME) + C_DELETE2_LOC lcLAST_NAME = CHECKCUST.lAST_NAME IF MESSAGEBOX(lcMessage,C_MSGBOX1) = MSGBOX_YES USE customer Exclusive DELETE IF !EOF() SKIP 1 ENDIF IF EOF() AND !BOF() SKIP -1 ENDIF PACK THISFORM.Refresh ENDIF Tag: Copy File Error in Visual FoxPro 7?
- 1
- Previous
Re: Copy File Error in Visual FoxPro 7?
AndyKr
This is not a VFP bug, it is general to Microsoft tools (including Word and Excel) and is one of the oddities that Microsoft allow you put spaces in paths, but don't hanlde them directly in their products. Ah well.
The solution is to enclose the path in quotes, but not as a quoted string as you are showing:
COPY FILE
"D:\VFP90\APPLICATION DEVELOPMENT\trycatchtest.prg" TO "C:\Program Files\ComPlus Applications\aktest.prg"should work just fine in any version of VFP.
Re: Copy File Error in Visual FoxPro 7?
Paul B Walker
Thanks Andy. I believe that I tried the solution you mentioned, but it failed to work. It may have been further impaired by the fact I was using macro variables for the path filename and I don 't believe the quotes got through to the final command
The party in question has now removed the spaces in the path and filename, so it's a moot point.
Thanks Andy. I believe that I tried the solution you mentioned, but it failed to work. It may have been further impaired by the fact I was using macro variables for the path filename and I don 't believe the quotes got through to the final command
The party in question has now removed the spaces in the path and filename, so it's a moot point.
Re: Copy File Error in Visual FoxPro 7?
AndyKr
>>Thanks Andy. I believe that I tried the solution you mentioned, but it failed to work. It may have been further impaired by the fact I was using macro variables for the path filename and I don 't believe the quotes got through to the final command
I didn't just make it up you know. I actually tested it and I can assure you it does work. Now the possibilitiy that you were stripping the quotes off would certainly account for the fact that it didn't work for you, you must delimit pathnames that contain spaces because, as it states in the Windows Help file "Spaces are significant in File and Path names" .
But your solution is MUCH better - to paraphrase what Andy Ross McNeil once said about using long field names..."You can use spaces in directory names, but arsenic is quicker and less painful"
Re: Copy File Error in Visual FoxPro 7?
SharathMum
if your using the macro are you using &cPath make It (cPath) it will work
e.g.
cPath = "C:\Program Files\My App\Out Put\Some file.xls"
COPY TO (cPath) TYPE XLS
AndyKr method as to work,
the thing is that u have not mentioned that your using macro
if your using the macro are you using &cPath make It (cPath) it will work
e.g.
cPath = "C:\Program Files\My App\Out Put\Some file.xls"
COPY TO (cPath) TYPE XLS
AndyKr method as to work,
the thing is that u have not mentioned that your using macro
Re: Copy File Error in Visual FoxPro 7?
Paul B Walker
Is &cPath a special word or function Please explain. I was using my own words for the macros.
Is &cPath a special word or function Please explain. I was using my own words for the macros.
Re: Copy File Error in Visual FoxPro 7?
SharathMum
u said that your are using variables for the path filename
cPath is the variable name which contains the Path
& is Macro substitution
i have posted the example code also
cPath = "C:\Program Files\My App\Out Put\Some file.xls"
COPY TO (cPath) TYPE XLS
Paul B Walker wrote:
Is &cPath a special word or function Please explain. I was using my own words for the macros.
u said that your are using variables for the path filename
cPath is the variable name which contains the Path
& is Macro substitution
i have posted the example code also
cPath = "C:\Program Files\My App\Out Put\Some file.xls"
COPY TO (cPath) TYPE XLS
Re: Copy File Error in Visual FoxPro 7?
Tamar E. Granor
& is the macro operator in VFP. It expands the string and inserts the result into the command. So, for example:
cFile = "MyTable"
USE &cFile IN 0
is equivalent to writing:
USE MyTable IN 0
However, even if you need the indirection in that command, using a macro is a bad idea, because you can use what's called a "name expression":
USE (cFile) IN 0
What do you mean by "using my own words for the macros"
Tamar
& is the macro operator in VFP. It expands the string and inserts the result into the command. So, for example:
cFile = "MyTable"
USE &cFile IN 0
is equivalent to writing:
USE MyTable IN 0
However, even if you need the indirection in that command, using a macro is a bad idea, because you can use what's called a "name expression":
USE (cFile) IN 0
What do you mean by "using my own words for the macros"
Tamar