Answer Questions

• Trev72 Corrupted and not a table problem?

  Please tell me, how to repair vfp 9 tables with error : not a table or corrupted. Thx. There are some appication out there to fix a corrupted table. On I USED TO USE was "FixFox" but there are some others - google it. Also, in SOME cases, VFP6 will open and repair an older dbf file. For some reason they have removed this 'feature' from newer versions. Of course, check to see that your table is actually viable: Look and see that the size of the table on disk is not 0. If it is - nothing can fix it. Aleniko ...Show All

• tanmos how can i restore a form that failed to load?

  it happens when i compile my project. "Error Loading file-record number 3. cursoradapter < or one of its members>. Methods: c:\myprogram\forms\solditem.SCT is not an object file" is there anyway we can restore it since if we copy from the original, and or make another d'same form from scratch it's a long process. Thank you i locate that record # 3 at MS SQL Server table but it has no problem in there. i can't also modify it anymore because of that error. thank you for your help. I meant record #3 in your scx file. You should do something like this: -Take backup of .scx and .sct -Try a compiling and check if that works (that might be the only thing needed at times) compile form solditem.scx ...Show All

• Lamprey_ How to preview the data from formset to report designer?

  Hi I have problem setting the exact information from formset to report designer. For example There is re_depot field in the tnrepair.DBF. In tnrepair table, there are inputs such as CHEM, CPDG, SHOC, PTGS, etc… I key-in CHEM in the textbox on the formset and then CHEM is preview on the report designer. The coding is “ report from report designer for re_depot = thisform.textbox.value while not (deleted()) preview “ As for this coding, it cannot get to preview when after I click the command button. Why cannot it work well Thank you. I have 2 textbox for dates input to select the dates while preview the list of re_depot (CHEM). Da ...Show All

• Jahid Excel to cursor SPT problems

  I am using a SPT solution to take information from a .xls file and importing it to a cursor with this solution: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 However, I am now receiving problems where before I had not. Now I am getting Error 1466: Connection handle is invalid. Any ideas guys I can't see what the problem is but it occurs at the sqlstringconnect( ) line. Thanks! ie: If excel is a Turkish version then Sheet1 is named Sayfa1 and that's only a change with language settings. Like I posted above: It would seem that the error (#1466) comes during the sqlexec( ) function. Any ideas from that Dave M. might know best (as he generated the code), but you might a ...Show All

• Zac Boyles How to disable Foxpro screen?

  I have a project with one screen form only. When I run the execute, the screen form is within the foxpro's screen. How do I make the screen form as the only window form shown on screen Thanks. Joe. To use: Hide Window "Microsoft Visual FoxPro" You need to create a form set from menu and set the properties for form set: WindowType: Modal For the form: WintowsType: Modeless ShowWIindow: As top level form It is working fine and you may use read events for other methods in form. Just 3 eazy steps(Ialready posted) : 1.in formset WindowType: Modal 2.in form WintowsType: Modeless, ShowWIindow: As top level form 3.in form "init" HIDE WINDOW "Microsoft V ...Show All

• Dietz Grid class

  I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column heading centered vertically/horizontally and bold. With column # = -1, this cannot be done, as far as I understand (no columns in Propoerties). Thanks for your explanation, Andy. Hans L And when I set the When to .F. in my Grid class, and, for instance, Valid to .T., and I then ...Show All

• budbjames Vfp Converting DateTime Problem in MSSql

  Hi *. i have table on MsSqlServer "art" with 2 fields id int, date datetime and when try to put some value into datetime(), MsSql say go away :( mSql = "insert into art (id, date) values (2, '20061103141100')" =sqlExec(nHandle, mSql) Please give me solution for this problem in Vfp. p.s. Don't give me example with store procedure, 'coz i use mssql for storage only. Thx. Thx David. I have just one more question. How to insert empty datetime into sql server. Thx again. As always there is at least 3 ways to solve that problem in VFP. My favorite is parameters and VFP does the conversion for you as necessary. ie: mSQL = "insert into art (id, da ...Show All

• Mikaelm form help

  hi! i am new in vfp now i am creating new proj and icreate form with theree grid i would like to auto increment id field (tab not to stop on this field) also when i click add buton it will refresh only parent form field ( not grid field) thanks lavesh thanks for your reply i am using vfp 6.0 what is the code for when i save record it will auto increse no and when i add record i want to refresh parent field and grid field ( e.g if you create invoice with order detail and when you save invoice the new invoice no increses auto and customer and order detail both are blank for new invoice) NILKAMAL wrote: i am using vfp 6.0 what is the code for wh ...Show All

• FasT image from webcam

  hello! i am new in vfp and i have vfp6.0 now i create database include ole object field i need to tab skip image field and create one cmd button call take picture and i connect my web cam so image come from webcame and store in pic foleder also delete button so cancel only image not record thanks Here you can find some good information about capturing images from your webcam: Using Video Capture: displaying on FoxPro form frames and previewing video obtained from a digital camera http://www.news2news.com/vfp/ example=437 HTH Cesar thanks for your reply i have table with image field now in form i want to attach my webcam and i need the code for ...Show All

• Angel Kafazov using tow field index with codebase

  Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay I had the some problem, but with vfp 7. It seems to be a incompability database problem.In my case I converted database in foxpro format and I created a "cdx" index and it worked fine. Your not getting any error from codebase doesn't mean it doesn't h ...Show All

• cacu Grid check-box...

  Hi All, I am using a grid on a form which has a check-box included. My problem is when the users are navigating through the grid if they hit the return key when the check-box has focus it automatically checks the box. How can I prevent this from happening to ensure they must use the mouse to check the box rather than the return key. Thanks for the help, Pablo Jord. You can override. ie: LPARAMETERS nKeyCode, nShiftAltCtrl IF nKeyCode = 13 NODEFAULT KEYBOARD '{TAB}' endif Can I override the keypress event i.e. get the application to ignore the value keyed or should I include code to check if the return key has been hit and then set the check-box to f ...Show All

• Damien fromOZ Server 2000 v 2003

  Hi all, I'm working on a multi-user FoxPro product across a network. Up to recently we used a 2000 server and everything was fine. Since we've moved to a 2003 server we've ran into problems. We get 3 testers working on the same network tables and within a few minutes the application hangs and seems to lock the tables. The really frustrating thing is that it never hangs in the same area or on the one computer. Our error messages are very vague as well. Basically I was wondering if other people had problems going from Server 2000 to 2003. Is there maybe extra security or configuration in 2003 that 2000 doesn't have. Any help would be much appreciated, Don't know if this will help, but I had similar ...Show All

• globemast .

  oSheet.Paste(oSheet.Range('A30')) Looks like I'll end up writing your whole code step by step. Please create a new thread next time so others would also deal with your questions. oExcel = Createobject("Excel.Application") With oExcel .Workbooks.Add .Visible = .T. With .ActiveWorkBook.ActiveSheet .Range('A1:F10').Cells.Value = 'filledbefore' .Range("1:6").EntireRow.Insert Endwith Endwith I don't know what you mean by transparent. Maybe you meant this: oExcel.ActiveWindow.DisplayZeros = .F. ...Show All

• gparali Wrangling a Grid

  I know that this is bucking the norm, but I am trying to use a grid to edit data in a cursor that I have created from a local table. The problem I am having is that the columns containing numeracle values or integers, the control becomes readonly. I have the grid on a form, and I am assigning the recordsource and controlsource programmatically after creating the cursor in the Init method of the form. Thanks in Advance - Any help would be appreciated. >> The problem I am having is that the columns containing numeracle values or integers, the control becomes readonly. There are a couple of possible reasons why a column could set itself to read-only. First the column's controls ...Show All

• Marmot2006 Run /N *.CHM file

  we can't : RUN /N c:\help.chm Please help me to sovle the problem thanks Use ShellExecute. ie: declare long ShellExecute in "shell32.dll" ; long hwnd, string lpszOp, ; string lpszFile, string lpszParams, ; string lpszDir, long nShowCmd ShellExecute(0,'Open','C:\Program Files\Microsoft Visual FoxPro 9\foxtools.chm',0,0,1) Hi, You can use: RUN /N hh.exe c:\help.chm ...Show All