Answer Questions
N_John Domain user as the anonymous account, problems...
Hi all I have a domain account called sa-inetcms, I run my ASP.Net 2.0 web service under this account (configured in IIS 6.0). However, when it tries to perform an INSERT into a local table on the service, it says that the table (a foxpro dbf) is read-only, I've checked all permissions on the server, the sa-inetcms account has full permissions to everything it needs, yet it still fails. Any ideas what I'm doing wrong Thanks Kev Kev, please make sure your application is configured for use Windows Authentication and that you have Impersonation feature turned on. Doing that, your application will run using your windows account. Regards, Rodrigo Moving this to the FoxPro fo ...Show All
Peter Peter Copy File Error in Visual FoxPro 7?
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" 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 usin ...Show All
MethMath How print continually in VFP?
Hi all, How print report continually in VFP (no eject after print finish) Thank! If our OKI Microline 320 turbo printer always ejects a page after the command <<REPORT FORM myreportfile.frx TO PRINTER NOPAGEEJECT>>, is this in all likelihood a VFP 9 software problem or is there a simple solution other than printing to a text file Hai, If u are not using VFP9 or if u dont want to use the reprot writer then write a program to print to a dos text file eg. if u have a employee.dbf with empid C(5),empname C(30),dept C(5),desig C(10),netsal N(12,2) then your program will be clos all clear private nrou nrou = 0 set device ...Show All
Daikoku Using Checkbox in a combo, or using Grids as combos?
Hi; I need a class which will act like a combo, but will let the user select multiple items using a checkbox. Can this be achieved by using a combo I seem to remember reading somewhere that a grid can be utilized to act as a more advanced combo. Anyone can point me to the right direction Thank, Aleniko Foxyclasses' Grids.vcx has one grid class that does that ( www.foxyclasses.com ). With a listbox if your items are few you could use bitmap(s) to mimic that. A third option could be a treeview activex. Depends on the number of records. If it is not too many then the native combo can do the trick with multi select turned on. If the number of recor ...Show All
James Mayer create index with visual foxpro 6.0
i'm trying to create index with visual foxpro 6.0 my sql command is: "CREATE INDEX id_index ON MY_TABLE (AGE1)"; I get an error : [syntax error]. does any know how to create index with visual foxpro 6.0 thank ishay You may use: INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName ] [FOR lExpression ] [COMPACT] [ASCENDING | DESCENDING] [UNIQUE | CANDIDATE] [ADDITIVE] syntax at: http://msdn.microsoft.com/library/default.asp url=/library/en-us/fox7help/html/lngindex.asp You are using DDL SQL syntax. You need to use XBASE syntax as DNI said: USE My_Table EXCLUSIVE INDEX ON age1 TAG age1 ...Show All
rta_llc Filename and nullchars
I hope everyone had a good xmas and santa gives you a lot of presents :) Now, my question: try this code in VFP9: pParam1 is a parameters which contains a folder name. The folder must contains EMLs, but can be another file, just change the extension. cString =pParam1 + Chr(0) nEMLs =aDir(aEMLs, pParam1 + "\*.EML") For iEMLs =1 To nEMLs cString =cString + aEMLs[iEMLs, 1] + Chr(0) EndFor StrToFile(cString, "C:\FileNames.TXT", 0) If you open the TXT file with Notepad.EXE you will see squares and other unreadable chars. If you open the file with FileToStr() and post the content in the VFP _screen, the names are ok, but if you send it to a messagebox() you'll see an empty messagebox. Thus, if you send to the messagebox( ...Show All
Jeff Lebowski sending email through Visual FoxPro
Sir, i have got one small program which has menu item report. when clicked on report push button the vfp generats a report (shareholders details who opted for adr). basically it is a 80 column report with just folio no,name of the shareholder, address of the share holder, no. of shares offered and weather some doucuments affixed. after viewing the report if the user clicks on email the report should be emailed to 2 common mail id's which i should be able to set inside the program. i will be greatful if any body can help me with the code thanks and regards (lakshminarayana r) Just a question, do you have OUTLOOK (not the express version) on the machine (if so, what version!) from where the report should be mailed ...Show All
Visual C&#35; Novice about vfp9 sp2
does vfp9 sp2 have bugs a month ago,I installed sp2,but when I closed the cursor (got by SQLexec() from SQL Server),the IDE opened a dialogbox containing mistakes,then the vfp9 IDE closed right away, SP2 is still in Beta stage. By definition it is not ready and it may have bugs. That is why Beta testers install the software to report on problems they may find. Never install a Beta version in a production system and do not install a Beta unless you are prepared to test the heck out of it. For the latest bug info in VFP SP2 see: http://download.microsoft.com/download/a/b/3/ab3fd0de-74e9-4b0e-9510-82e9bd3a49e4/VFP9SP2_OctCTP_FixList.htm SP2 is in beta yet. ...Show All
Wil Burton Copy a Text box to the Clipboard
In one of my projects I have a text box and i would like to be able to press a command button to copy whatever is in that text box to my clipboard. Any help would be great! _cliptext = YourTextBoxName. Value I knew it was somehting simple thanks! ...Show All
Balbiesas application and webdata interacting.
ok first off here is some info about my webserver: i dont no if you needed the information but maybe you do General server information: Operating system Linux Kernel version 2.6.17.11-grsechg Machine Type i686 Apache version 1.3.37 (Unix) PERL version 5.8.7 Path to PERL /usr/bin/perl Path to sendmail /usr/sbin/sendmail PHP version 4.4.4 MySQL version 4.1.21-standard cPanel Build 10.9.0-CURRENT 117 Theme cPanel X v2.6 ...Show All
ga2006 Not able to run foxpro exe file (urgent)
Hi , I have a foxpro forms and reports. when i run from desktop . it is showing 'CANNOT LOCATE THE MICROSOFT VISUAL FOXPRO LIBRARY' I got these files from client. i have installed my visual studio in 'C:\Program Files\Microsoft Visual Studio' So I have to anything in my WZSETUP file , In this file they have mentioned everything. Like source and destination. i have dbf files and forms and reports in this folders. Now i am not able to my client exe file. Kindy anyone tell me the solution Thanx and Regards Selva.R Hi Selva, I think there exist 'exe' files in foxpro...you've to include the runtime to make it standalone. Though you got your problem solved by opening the fxp directl ...Show All
WBAS Deleting records
Hi, I need to delete some records from a table that has the same values for some attributes. Some attributes are part of the primary key while others not. Thanks, You may try to use: DELETE [ Scope ] [FOR lExpression1 ] [WHILE lExpression2 ] [IN nWorkArea | cTableAlias ] [NOOPTIMIZE] You may include as manny atributtes after "FOR" OR after "WHILE": DELE ALL FOR h=>1 .AND. z="HHH".... Hi, It needs to be done inside a code that triggers when you click a button. Then, it is a one-off operation. Thanks I am sorry, but you are not giving us enough information here. How is this delete to be done In an application, or ...Show All
Cristian Botiza FoxPro 6 Class problem in FoxPro 9
Hello: I have a class that works great in FoxPro 6 and in FoxPro 8 but when I tried to move it to FoxPro 9, half the stuff in it was missing and it was showing as dammaged! Does anybody know what I am doing wrong Any suggestions would be appreciated, I am just trying to get in to FoxPro 9, I have been a FoxPro 6 user for some time now. Thanks in Advance Just a guess. VFP 9 does a stricter integrity check on tables. All callses (and forms and reports and so on) in VFP are actually tables. My guess is that maybe the class (VCX/VCT) is corrupted and VFP9 complains. Work on a *COPY* of the files. Open them on exclusive mode in VFP9, setting Tablevalidate off. See SET TABLEVALIDATE: http://m ...Show All
Samuel I FOXPRO running slow on POS Machine
Hi guys, Me running Ximeta netdisk RAID 1 on FOXPRO Programming, 2 POS Machine are running slow on the programmed menu buttons. I am linking them to a full mode Switch 10/100 Ethernet. Can anyone help me So what's your take on this Hi, What is the speed to copy few MB files from server to POS machine Is your query optimized Any antivirus installed Dear Chanmy8, I use embedded pictures for some buttons, thus query was optimized. Norton Antivirus... basically no server as i am saving costing . Just 2 Mirrored NETDISK to do the job. Ravefred . Hi, Try to exclude *.dbf, *.cdx abd *.fpt from scanning or temporary disable anti-virus for testing. HTH ...Show All
Ganesh sethuraman pass contents to C#
hi! this is sort of connected to my other post regarding Foxpro and C#.. in the foxpro program i will type in a name and when i call the C# program it will also contain the name entered in the foxpro program. is this possible How can i do this thanks! From C#, you use ADO.NET, connect to the database that contains the data and query it. There is nothing to it, and it is not related to VFP. A SQL Server database is a repository of data. Which client you use to access that data is immaterial to SQL Server. So it is perfectly OK to insert data from a VFP front-end and retrieve it from C# as you want to do. If you are unfamiliar with C# and ADO.NET, there are forums here for them where you ca ...Show All