Answer Questions

• de_Stan Data deleted with ZAP

  Hi every body How can I recover data from a tabla that has been deleted with ZAP. Thanks a lot Hi Thanks, but this does'nt work for vf6.0, I have tried with vf 5.0 and this recover some records but the other one are garbage. Regards Hi, Check this out http://support.microsoft.com/kb/135905 Actually, ZAP sets the RECCOUNT() at 0 and puts and end of file marker just after the table header. If it did a DELETE and PACK, it would take much longer. When you do Zap in a table, a new table is created empty in another position inside your HDD. If you use a software for recover deleted files, you will find your old tab ...Show All

• AlexBB fix corrupted dbf

  hello, i'm opening a table in the command window and it display a message that the table is corrupted and needs to be repaired before it can be use again. Can anyone help me fix the dbf Is there a free software to fix the corrupted dbf any help will be greatly appreciated thank you jason Hi I used Xitech Foxfix... Great tool. if you can read in spanish,meaby this, can help you, because i am spanish helper.... and not sepeach well in english.(I was born in Argentina) Hay un programa que se utilizaba para reparar las tablas y se llamaba FIXFOX.EXE Este programa reparaba las tablas inmediatamente y solo habia que reparar el INDEX ejecutando el comando REINDEX. Fijate en la WEB si lo puedes conseguir.. caso contrar ...Show All

• Dave_is100 auto increment

  I have a table that I want to add a auto increment integer field. I go into the database designer, Right click on the table I want to add the field to then select modify. Then I insert a field and give it the name client_id set the type to Integer (autoinc) it defaults to a width of 4. Then I tell it to index it accending. This works but on all the existing records it sets the field to 0. If I add a new record it does increment. Thank You You may run once a small loop to update table for existing records. USE <tablename> GO top DO WHILE .T. REPLACE <field name> with <field name> + <increment value> IF !EOF() SKIP ENDIF IF EOF() ...Show All

• goh6613 TOP LEVEL FORM and AutoCenter

  Just curious how people are handling the Auto Center of Top-Level forms. The problem is that the form positioning does not account for the presence of the task bar. This is not a problem with monitors running at high resolution but we still have a large number of users running at 800*600. Stuart I don't have an issue as all my users are at least at 10x7. If it is an issue for you , then you cannot use auiocenter as it comes out of the box. You would have to do some calculations and maybe save a user-selected position for next time. Some frameworks already do this (the one I use, Visual MaxFrame Professional, does it). Basically you have a table with an entry per form, per user, where you save t ...Show All

• thiers Casting from character to numeric

  Any idea how to cast a characeter field to a numeric field. I have a table w/ 150 'character' numbers that i need to be 'numeric' numbers Thanks, Mike Numbers are integer only numval = val(myField) If you want to do at table level then you could use alter table along with one of the numeric types. ie: alter table myTable alter myColumn i alter table myTable alter myColumn b(2) alter table myTable alter myColumn y etc. ...Show All

• fighter92 Mixing XLS and DBF tables

  In l ieu of some latest trends in my FoxPro development I want to know how do you sensible mix Excel .xls tables, workbooks and projects with FoxPro .dbf tables and databases. I have followed Marcia's earlier suggestion to use convert .dbf into .xls for graphs and now I want to integrate my .xls into existing databases. I tried to attach an .xls table to my databases but only could do in the browser as free table. This was to now avail, however, since I could not open it in FoxPro anyway. Another question, somewhat related: I used a wizard to define the connection string to a FoxPro Database. How can I do it if I need to define a connection string to an .xls table What is the equivalent for a database in Excel: a workbook Is th ...Show All

• Gravy Connect to Outlook Express and Microsoft Outlook

  Dear Expert, Can I know how to connect to the Outlook Express and Microsoft Outlook using FoxPro Like the data in a memo feild how I connect or send out using the Outlook Express and Microsoft Outlook Or Can I generete email using FoxPro Thank you.     bankim wrote: WITH THE ABOVE CODE I GOT THE FOLLOWING ERROR' THE MESSAGE COULD NOT BE SENT TO THE SMTP SERVER. THE TRANSPORT ERROR CODE WAS 0X80040217. THE SERVER REPOSONSE WAS NOT AVAILABLE. Did you configure Outlook Express Can you send an e-mail successfully using Outlook Express bankim wrote: I have configured the outlook express perfactly. Were you able to ...Show All

• Andreas Hallberg gMinFilter

  Hello, I'm new here and with using FoxPro. I'm trying to modify an existing query from within my database. When I open the query it is asking me to locate the .dbc file. I located that with no problem but now it's asking me to "Enter the value for gMinFilter". Can anyone shed some light on what this means >> Any idea why I have to enter these parameters in every time I want to modify a query Look up Parameterized View in the help file. The reason is that the query is using a 'view' which is basically a query stored in the database. That view must have been defined with parameters (gMinFilter and gMaxFilter) and if they do not exist, VFP prompts you for the values. If you created the values before trying to run ...Show All

• CrashPlaxton autoincrement problem foxpro ADO and Visual C++.net

  Hi I am trying to enter a record into a table that has only two fields (for simplicity) the first (fielda) is of type auto increment and the other(second) is char 100. I can not insert data with the command INSERT INTO table (second) VALUES ("firstrecord") When i do this process driectly from an sql interface in VISUAL C++ IDE it runs ok. Looks like you are using the VFP ODBC Driver. The problem with that is that it was superceded in Version 7.0 by the OLEDB Provider and has not been updated to handle versions of FoxPro later than 6.0. This is not really a major issue UNLESS you have auto-incrementing columns in the data - they were introduced in Version 8.0 and ch ...Show All

• donkaiser "Flush" vs. "Tableupdate(1,2,.T.)" ?

  The question is: When is it wiser to "flush force" (data to disk) vs. =Tableupdate(.T.), =Tableupdate(1), etc. What is the usual paradigm Can I forget flush Is flush slow in the LAN setting(s) Does flush hog resources Does frequent-flush help prevent corrupting tables during intense LAN data-manipulation, crashes, and/or power outs Is is dangerous to rely too much on Tableupdate() alone when tables stay open all day As always, thanks in advance for any thoughts Thank you very much, Andy.  This helps immensely. Well, I rule out the first hypothesis of "data-safety" based on your strong logic.  We won't implement "flush force" in our EMR-apps.  I stand corrected.  Also I&nb ...Show All

• DevDiver install shield Express & FoxPro 9

  I am having a wierd problem creating my install with install shield Express. I seem to be creating the setup file okay and it is even installing good and running the app good, with 2 exceptions. the shortcuts that are created on the desktop and the start menu are only available for the user profile of the person who installed the app. The program seems to execute only when the installing person not anyone else. Even if the other person is an administrator. Please help I am new to this Install shield, before I used VFP 6 with its own installer. Thank You in advance. Hi, You got to select "Customer Information" dialog box from dialog node. This dialog provides "Only me&quo ...Show All

• TrevorW How do i use the WHERE clause in remote database connection?

  After connecting to and oracle database i want to select specific records using the where clause as below gctype = 'A' gquery = '1' = SQLPREPARE(gnConnHandle, 'SELECT fssno,floc,fcurrent_address1,fcurrent_address2,; fhome_address,ferno,fquery_code,fdate_approved,fcap30,fbenefit_paid FROM cif_hist; WHERE ftran_type = gctype and fquery_code = gquery','MyCursor') = SQLEXEC(gnConnHandle) It gives me an error message "SQL statement parameter is required for non-prepared SQLEXEC() calls. Can someone help me Thank you very much. Everything is okay now. i'm really grateful. It's done as you do. However there is a typo in your query. The problem is not with SQLPrepare syntax in other words. It'd fail if ...Show All

• willajo I need to create a barcode and would like to use FoxPro and Crystal Reports to print it. Any suggestions?

  I need to create a barcode and pass data to it and print the labels through Crystal Reports. Does anyone have any suggestions on barcode software. You just need a barcode font. For free Code39 font: http://www.barcodesinc.com/free-barcode-font/ ...Show All

• Robert Beaubien single line command for set topic

  I'm trying to type a command line that replaces two lines: Set topic to tableupdate() 'or any topic then help Is there any way to make this one line Help Tableupdate() Tamar ...Show All

• S 007 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 Would you try this (I don't use codebase to know if that'd work): Create index ind On person(trans(age)+name) Your not getting any error from codebase doesn't mean it doesn't have any error. Behind the scenes what command(s) cod ...Show All