Answer Questions

• UnKnown Nick Printing directly to LPT port.

  Hi everyone; I have 2 dot matrix printers installed on a win98 machine. I can successfully print from other machines to the printers on the win98 machine by issuing: set printer to \\win98machine\invoices or set printer to \\win98machine\reports The problem is that I can't find a way to print to these printers from the win98 machine itself. The above set printer command won't work. Neither would set printer to LPT1: or set printer to LPT2: They are simply disregarded and the printer is still the default windows driver. Any ideas would be greatly apreciated. As always - thanks. Cetin; Set printer to name will not print direcly to the port. It ...Show All

• pc_bond programmatically finding out if dbf is part of dbc??

  I'm going through a directory that has free tables and a dbc. I can get all the dbf names and info, but I don't know how to identify if a dbf is in the dbc or is a free table. Is there a function that will give me that info or does someone have code that pulls this out of the dbf header file Thanks!!! ** Code snippet with problem in red below** ADIR(laArrayTables,".DBF","D",1) lnNumberTables = ADIR(laArrayTables, '*.DBF') && Create array FOR nCount = 1 TO lnNumberTables && Loop for number of databases lcDBC = "" lcTable = ALLTRIM(laArrayTables(nCount,1)) lcTable = SUBSTR(lcTable,1,AT('.',lcTable)-1) IF "|" + lcTable + "|" $ "|STABLES|SFIELDS|SINDEXES|" LO ...Show All

• Pascal Frey anything wrong ?

  is there any thing wrong with this expression because its giving me an error. thanx for the help SCAN FOR BETWEEN (ldDate,from_date,to_date) ! EOF () There is not any operator or scope clause between 2 functions. scan for between(ldDate, from_date,to_date) && no need for eof() check scan does that for you   scan for between(ldDate, from_date,to_date) while !eof() Actually, it's easier than that. SCAN FOR implies WHILE !EOF(), so leave that off. The statement can be: SCAN FOR BETWEEN(ldDate, From_Date, To_Date) ...Show All

• mdemler date format in datagrid

  Hello everybody, I am using datagrid control with two date fields. I have set the date format to italian (dd-mm-yyyy). When I run the forn within foxpro it works as desired. that eans the dates in grid and reports generated are in desired format. But when I build the exe and execute it standalone, the dates in datagrid and in reports are displayed in american format (mm/dd/yyyy), but in textbox controls the dates are shown in italian format. I want to display the dates in italian format in all the cases when i execute the exe standalone. can anybody help me thanks in advance. Dear Marcia G. Akins, U r simply great ! your suggesstion worked. thank u very very much. May know your emai ...Show All

• Jim Aksel Report designer - Creating an argument for a field

  This is probably a really basic one for you guys but I'd appriciate some help. I have a table which contains multiple rows and I want to pull out a specific value within that I would type into a command runner: use emmfil set filter to fileid="02" Then I would want the field Value1 How do I do this in a report designer Thanks Ben THanks for that....I'll give those a try Normally you prepare the records beforehand, then run the report command to show your report on the filtered set. Beware of your example use of SET FILTER. If you do not have the proper Rushmore-optimized conditions, depending on the size of ...Show All

• Mr.XX HTML Reoport Output Includes Vertical Scrollbar

  Using vfp9 report output to html. Finding that report field controls that are set to "stretch with overflow" include a vertical scrollbar (even though displaying entire contents of the field). Has anyone experienced this and/or found a way to eliminate the scrollbars ...Show All

• KidVB "When" firing after "Valid"

  Hi all; I am temporarily using an older SPR in VFP 9 as it is. I have had some problems with the code, and after using the debugger I have learned that in a "Get, when, valid" command, the "When" fires AFTER the "Valid". Anyone had experienced a simillar probem Any ideas why Thanks, Aleniko When fires before the next control receives the focus. So when you are leaving a control, and the focus is going to the next one in the sequence (in a form or container for example), the next control's When fires. See: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/a06d2f38-2e33-4e77-bca2-c71d99bb6af9.asp frame=true http://fo ...Show All

• marina B. Errors running FoxPro Stored procedures in .NET windows app

  Hi I want to run a stored procedure in user selected database which basically creates two new tables to be persisted in the same database. I am able to call this stored procedure but I keep getting the same error "One or more errors occurred during processing of command." There are no details of what the error is specifically about. I am able to run the same stored procedure using Microsoft Visual FoxPro 9.0 software. My Connection string is "provider='VFPOLEDB.1';data source='strPathName.dbc';password='';user id='';Mode=ReadWrite". Any ideas or suggestions are appreciated. Try If VFP7Connection Is Nothing Then VFP7Connection = New OleDbConnection(VFP7ConnectionDefinition) If VFP7Connection.State = ConnectionSt ...Show All

• Allen Razdow sharing connections between applications

  Pehaps I better wrote: sharing databases between applications . This is the thing. I have a VFP application which is 99% complete. Occasionally I add some embelishments or premium features. I am also in the process of developing a C# app of Winsock style. It is a console app in Visual Studio 2005. It is supposed to use some of the same ODBC VFP9 databases. I've read that VFP databases are much superiod to SQLServer databases in terms of speed. I spent a day trying to figure out why I could not open a connection while my VFP app was open all the time and those databases were linked to it. Finally, even superstupid get their break and I realized that there was nothing wrong with my connection string. I shut the VFP app down. This brings m ...Show All

• mmonte Help with code for updating table on website

  This is the code I am attempting to usw to add/edit date in a free table on my website. It opens the table fine and will display what is already in the table, but any changes I try to make do not arent being saved. I dont get any errors. Any help USE \\www.infotizer.com\lotterydata\NewData.dbf SET SAFETY OFF SELECT NewData INDEX ON state TO IdxState SET SAFETY ON SELECT StateLinks SET ORDER TO STATE && STATE GOTO TOP DO WHILE !EOF('StateLinks') SELECT StateLinks ThisState = ALLTRIM(State) SELECT NewData SET ORDER TO IdxState SEEK ALLTRIM(ThisState) IF FOUND() SELECT NewData SCATTER MEMVAR m.g1date = g1date m.g1name = ALLTRIM(g1name) m.g1num = ALLTRIM(g1num) m.g1b1name = ALLTRIM(g1b1name) m.g1b1num = ALLTRIM ...Show All

• radek_m 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 ( ...Show All

• Kendal Walton How to overwrite a disk file that is read-only?

  While trying to run oFS = Createobject('Scripting.FileSystemObject') ...... oFS.CopyFile (file1,file2,.T.) I get an error on statement # 2 if file2 is read-only. It is a errant situation. This file is not supposed to be this way. I have to transfer about 2,000 files each time and a couple of them turn out to be this way for no apparent reason. The program breaks down. How can I change this property on the fly programmatically Thanks. Function ModifyFileattribs lparameters tcFileName, tlReadOnly, tlHidden, tlSystem #define FILE_ATTRIBUTE_READONLY 0x00000001 #define FILE_ATTRIBUTE_HIDDEN 0x00000002 #define FILE_ATTRIBUTE_SYSTEM 0x00000004 local lnNewAttr lnNewAttr = iif(m.tlReadonly,FILE_ATTRIBUTE_READONLY,0 ...Show All

• ConfigSSIS We can not post images on this forum?

  A picture is worth a thousand words I have been using rapidshare.com for uploading files. I like it, you can upload for free and give the link to ones who you want it to download. You also get a delete link, to delete the file before default delete period of 90 days. It is fast. It would be much easier to explain for error messages, form examples, report problems if displayed in an image. Member can even share their codes by compressing a small project and upload to the forum. I guess the major concern is the virus attack. But it is a good feature anyway. Believe MS has the strong wall against virus. I try this but it not work. I ...Show All

• jayaraja Dot matrix printers with Visual Foxpro

  Hello all, We are in the process of converting an old Foxpro 2.6 (DOS) software into VFP, the problem that we face is that the printing is very slow on dot-matrix printers We cannot shift to laser printer as the stationery is pre-printed and has to be multi-part. Can anybody offer the solution Thanks in advance thanks Lashmi your reply, your first report saying me cust.txt is read only when i run this. and scond is working well. but when print the report all page eject. acctuly my report is nog big than one line, when one line is print, i want printer stop after printng one line, than my next report which has alos one line, print with pervious line. thanks If the printers are on ...Show All

• Predator14567 foxpro training and/or classes

  Hi there. Does anyone know of any good training sessions or classes for VFP I'm from vegas myself, and there's nothing out here. I have an alright grasp on it (VFP), but I would like to really dive into it. It's not too easy to learn on your own when there's not much out there to teach ya, ya know I appreciate it in advance. Thanks MarciaAkins - very helpful. The website is actually www.swfox.net - I appreciate it! thereisnomike wrote: Hi there. Does anyone know of any good training sessions or classes for VFP I'm from vegas myself, and there's nothing out here. I have an alright grasp on it (VFP), but I would like to really dive into it. Sign up for Southwest Fox at www.swfox.org . The price is reasonable, i ...Show All