Reconstructing a DBF from its index

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Index asc and Desc Hi Everybody. What technic you are using to combine in one index ascending and descending orders? I have two 12 Characters fields which I want to combine into one Index, But I want first field to be in ascending order and second in descending order. Thanks in advance. Tag: Reconstructing a DBF from its index Tag: 231642
  - 2
    - barcodes I am having trouble finding a way to send a bar code image to the printer. In VB you would write: Printer.PaintPicture barcode.barPicture, leftpos, toppos Can somebody provide me with a code snippet that will do similar in VFP9? Is there some way that ??? will do the job? Gleason Tag: Reconstructing a DBF from its index Tag: 231641
  - 3
    - Hide forms maximise button Is there any way to hide (as apposed to simply disable) the maximise button on a forms title bar? I need to allow the user to minimise & close the form but not maximise it and would prefer it to be hidden from view rather than greyed out. Tag: Reconstructing a DBF from its index Tag: 231639
  - 4
    - Telnet control from VFP This is a multi-part message in MIME format. ------=_NextPart_000_003C_01C7760F.0DA8C5E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi All, I have the need to create a CDR Server (Call Detail Record) in VFP. I = need to connect via Telnet to a VOIP gateway to read the CDR data. Does anybody knows a good Telnet control (ActiveX, DLL, etc) which can = be use with VFP? Thanks! --=20 Edhy Rijo ------=_NextPart_000_003C_01C7760F.0DA8C5E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16397" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>Hi All,</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>I have the need to create a CDR Server (Call Detail = Record) in=20 VFP.  I need to connect via Telnet to a VOIP gateway to read the = CDR=20 data.</FONT></DIV> <DIV><FONT size=3D2></FONT> </DIV> <DIV><FONT size=3D2>Does anybody knows a good Telnet control (ActiveX, = DLL, etc)=20 which can be use with VFP?</FONT></DIV><FONT size=3D2> <DIV> </DIV> <DIV>Thanks!<BR>-- <BR>Edhy Rijo</DIV> <DIV> </DIV> <DIV></FONT> </DIV></BODY></HTML> ------=_NextPart_000_003C_01C7760F.0DA8C5E0-- Tag: Reconstructing a DBF from its index Tag: 231638
  - 5
    - Select Sum(nField) Hi, I have a SQL command in VFP8 Sele Sum(nField) from History where cEmpCode=lcEmpCode Into Cursor tHistory If there is no Employee that matches lcEmpCode, the command returns a cursor with 0 records. I used the same command in VFP9 and it returned a cursor with one record with a NULL value. Is this correct? Thanks, Herbert Tag: Reconstructing a DBF from its index Tag: 231607
  - 6
    - Why does this VFP code not send a fax properly via Winfax Pro? Hi, I have Winfaxpro and am using this code to send a sample fax. However, as soon as I run it, it brings up the Winfax pro dialog box with blank fields and wants me to enter the fax #, etc. Can someone tell me what I am doing wrong? Thanks ---- Code ---- oWinFax = CreateObject("WinFax.SDKSend") &&Create instance of Winfax oWinFax.SetSubject("Test Fax") oWinFax.SetNumber("5551212") &&Fax Number of recipient oWinFax.SetAreaCode("") &&Area Code of recipient oWinFax.SetCompany("Some Company") oWinFax.AddRecipient() && Required oWinFax.SetPrintFromApp(1) oWinFax.AddAttachmentFile("") oWinFax.Send(1) SET PRINTER TO NAME Winfax set print on ?"this is a test" set print off SET PRINTER TO LPT1: RELEASE oWinFax Tag: Reconstructing a DBF from its index Tag: 231603
  - 7
    - How to send a fax from VFP via WinfaxPro Hi, Would someone be able to guide me to sample code in VFP to send a fax via Winfaxpro SDK. I tried some of the examples on the web and the fax gets sent to the Winfax Printer driver but Winfax never dials out. Thanks much, Zoom Tag: Reconstructing a DBF from its index Tag: 231602
  - 8
    - Corrupted Tables Hi, What is the best way to fix corrupted tables programatically? My tables are open in the Data Environment. Thanks. Herbert Tag: Reconstructing a DBF from its index Tag: 231601
  - 9
    - remote view - MySQL add records? Hello, I've been using remote views for a variety of DB formats for years....but never had to write back to the DB....until now that is. Have a local MySQL installed, hooked up to ODBC (3.51 driver) and VFP 9.0, have remote connection and remote view established. But when I add records to the view (cursor) it doesn't actually write it back to the MySqlDB. Can I create a remote view, add records then write them back to the MySqlDB or is there a different process required? TYIA =B Tag: Reconstructing a DBF from its index Tag: 231600
  - 10
    - 2.6 FILE COPY Server 2003 SP2 Date Time Bug FILE COPY in VFP9 SP1 and Foxpro 2.6 are both supposed to make an exact copy including date and time. On Windows 2003 SP2 with a recent update... FILE COPY under 2.6 now stamps the copied file with the current date and time (rather than the file date and time). It still works fine under VFP9 SP1, and also both still work under Windows XP SP2. I report this wierdity only because some code that has been working forever recently failed... and because I have just spent too much time carefully trying to understand what was going on ;). Thanks for listening, Alan Tag: Reconstructing a DBF from its index Tag: 231599
  - 11
    - Play WAV files Hi, What is the best way to play WAV files in VFP? Been using Set Bell to and CHR(7) but been having problems. For some unknown reason, there are times that the sound will not play or will play at a later times and overlaps with another playing sound. Thanks. Tag: Reconstructing a DBF from its index Tag: 231585
  - 12
    - Browse window from V6 to V9 I just updated and very happy. However, I rebuilt my project in V9 and ran the .exe in another directory. The first time I go to open a browse window I get "Invalid Browse Setup -- Default Setup Used" and everything runs fine after that. But I think I'm missing something new about the browse window. I found SET REPORTBEHAVIOR 90 and the reports work great. Is there a setting I can't find for the browse windows. I can't have my customers seeing the popup "Invalid Browse Setup" LOL Tag: Reconstructing a DBF from its index Tag: 231582
  - 13
    - VFP sending 8 character date in runtime with SET('CENT')='ON' I have an application I run from both development FoxPro and from a compiled EXE. I have CENTURY set to ON, and when running from the EXE and writing the date to a memo file in a table (e.g. DTOC(chargedate) ) it gets written as 03/31/07. When running from the development environment it's written as 03/31/2007. Also vexing is the fact that when running the EXE, date fields in the table are seen as 03/31/07 until mouse-clicked, when they expand to 03/31/2007 (i.e. if cursor is in the field). When running from the development version of FoxPro (VFP 7.0) all the date entries are seen as 10 character (e.g. 03/31/2007). Why am I getting this behavior and is there a fix or workaround? TIA. Dan Email: dmusicant at pacbell dot net Tag: Reconstructing a DBF from its index Tag: 231572
  - 14
    - Any way to send a fax from VFP via Activex? Hello, Does anyone know of any ActiveX to send a fax from within VFP? Preferably something that also send Microsoft Word files as faxes. Thanks Zoom Tag: Reconstructing a DBF from its index Tag: 231570
  - 15
    - Shellexecute - modal? I need to run an external exe from a foxpro application. For that I use shellexecute in shell32.dll. Now I would need make this call "modal", i.e. so my foxpro app waits until the external exe returns a value and then grabs this value and continues. How can that be done? Tag: Reconstructing a DBF from its index Tag: 231561
  - 16
    - vfp9 code page Group, Our app was ported from the mac 8 yrs. ago so the tables have code page 10000. Windows has code page 1252 (english). Should that make a difference in speed when opening screens with hundreds of objects linked to database table fields? Should we change all the many tables to code page 1252? Any thoughts will be appreciated. Wade Tag: Reconstructing a DBF from its index Tag: 231552
  - 17
    - Scrolling in a Grid Hi, Is there a way to check if the Record Pointer in a Grid is not anymore visible when a user scrolls the Grid? What I want to do is when the user scrolls and the record pointer is not visible, I will set the record pointer to the record on the top row that is visible. Thanks. Tag: Reconstructing a DBF from its index Tag: 231550
  - 18
    - Minimize window outside application For maintenance purposes, I find it very convenient to start a vfp9 application from a batch file. Is there a way for vfp to know how it was started and to then find and minimize the command window? Thanks Tag: Reconstructing a DBF from its index Tag: 231545
  - 19
    - SET variable for VFP 6 and 9 How can I point my VFP 6 and 9 to different CONFIG files? Right now, we use SET foxprocfg for the DOS version and SET foxprowcfg for VFP 6/9. TIA. -S- Tag: Reconstructing a DBF from its index Tag: 231542
  - 20
    - External array not working - VFP 9 sp2 I have a program system with a main program that calls lots of forms. In the main program I define an array gaAccess as public In some of the forms I reference the array in the refresh method of some of the buttons. external array gaAccess this.enabled = gaAccess[2] != 'R' I have also put the external array command in the load event. when I build the project I am still getting the undefined error and would like to clean them up. What am I doing wrong???? czeb Tag: Reconstructing a DBF from its index Tag: 231540
  - 21
    - Sys(1037) and GetPrinter() Hi, Since changing to Vista we have a problem saving the printerenvironment. The sys(1037,1) button doesn't have the "printer" button anymore, so you need to call the Getprinter() first. I changed my code like this : use myreport.frx sys(1037,2) && Restore old printer info lcPrinterOld = SET("PRINTER",2) lcPrinter = Getprinter() if NOT lcPrinter = lcPrinterOld SET PRINTER TO NAME (lcPrinter) SYS(1037) && Call the page setup SYS(1037,3) && Save current printer settings endif When I try this, it just restores my report settings to the default settings. Also the helppage on this subject is very confusing. Thanks for any help Greetings Xavier Tag: Reconstructing a DBF from its index Tag: 231534
  - 22
    - Can This Grid Behavior Be Altered? Hello and thanks in advance for the help. Suppose you have a grid that is based on a cursor. Lets say that 10 rows are visible on the screen. Lets also say that there are 30 records in the cursor that is being "browsed" by this grid. If you use the down arrow on the scroll bar to scroll through the cursor, it will keep scrolling until the last record of the cursor is in row 1 of the grid. The behavior that I would prefer is that it stop scrolling when the last record is fully visible in the grid (row 10 in this example). Is there any way to make this behavior happen? Thanks, Jeff Tag: Reconstructing a DBF from its index Tag: 231532
  - 23
    - PETITION asking to Microsoft to continue with the Visual FoxPro development This page is opened by an idea from the Visual FoxPro Spanish community, this page is opened for doing a campaign asking to Microsoft to continue with the Visual FoxPro development, release the full source code as Open Source or make an agreement with a 3rd party for continued development of future versions of VFP. MasFoxPro campaign: http://www.masfoxpro.com Martin Brtna Tag: Reconstructing a DBF from its index Tag: 231529
  - 24
    - Distorted Image Hi, Im trying to display Employee Pics in a Form from a general field in a table. form.stretch = Isometric. Picture is distorted. What is the best way to display a Picture from a General field? Thanks, Herbert Tag: Reconstructing a DBF from its index Tag: 231527
  - 25
    - Space bet Detail Band & Page Footer Hi, Recently upgraded to VFP9 and my reports from VFP8 suddenly have a space between the Detail Band & the Page Footer. Is there something I need to change in my report. I have tried set Report Behavior to 80 & 90 but it has the same result. Thanks, Herbert Tag: Reconstructing a DBF from its index Tag: 231526
- Next
  - 1
    - VFP 9 project question I have a vfp system where the source is in two folders. Dev folder for forms, prgs, frx, etc. Plus a sub folder containing all graphics, bmp, jpg, gif, ico, etc. The graphics are mainly used on forms and buttons on forms. I have added a createobject routine that creates a form from a prg. this form contains a graphic that is not used anywhere else. I manually added the graphic file to the project in the other files section. It is not marked as excluded When I build the project no errors are encountered but when I run the exe from the production location the graphic cannot be found. I tried placing a reference to the graphic into the main program within an if statement that is never true but this didn't help either. If I copy the graphic to the production folder to the same relative folder location as development it is found. Why isn't this found. Anyone with experience in getting this to work correctly??? Czeb Tag: Reconstructing a DBF from its index Tag: 231518
  - 2
    - how to get the no of month of a given date range Dear friends How to get a no of months & years of a given date range e.g. dldate=date(2000,05,25) now if i substract the dldate from current date ie. x=date()-dldate it will give result no of days but i want no of months in a single statement. if any function is available in VFP6 or any other way to get it. Thanks -- sanjib Tag: Reconstructing a DBF from its index Tag: 231507
  - 3
    - [fw] Display the tree shown by Class Browser http://fox.wikis.com/wc.dll?Wiki~ClassBrowserTree~VFP Next step is to scan the forms .... -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Reconstructing a DBF from its index Tag: 231504
  - 4
    - Oracle ODBC driver from Microsoft vs Oracle Hi, I have some applications written in VFP9 accessing Oracle databases thru ODBC, for some unknown reason, I always install the ODBC driver provided by Oracle, but it seems to be more heavy and time consumming to install it, so I wonder how would it be to use the ODBC driver provided by microsoft that is already installed on any PC, has somebody onthe forum used the microsoft driver? I would appreciate any advice or info about comparision and reliability of both ODBC drivers thanks Oscar Taboada Tag: Reconstructing a DBF from its index Tag: 231502
  - 5
    - VFP 9: Compiling in a VFP .exe The build procedure for my app has gotten a bit more complicated, so I want to automate it. How do I get build project and build exe to execute in a VFP .exe called from the command line? I got a feature not available message when I tried. There is a full VFP system on the computer I used. I am trying to get both the build and zip done in a batch file. Sincerely, Gene Wirchenko Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Computerese Irregular Verb Conjugation: I have preferences. You have biases. He/She has prejudices. Tag: Reconstructing a DBF from its index Tag: 231500
  - 6
    - Any last requests? I could work with VFP for a while more if only I could read and write = UTF-8 in Sql Server without double byte translations leading to ??? = (unless somebody knows how to do this with the current VFP) What are other requests that people would still have? Robert Tag: Reconstructing a DBF from its index Tag: 231490
  - 7
    - Making a calling form invisible I have developed an Output class to handle reporting, exporting etc. This is called from scores of forms with a few parameters. After it has all been designed I have decided that I would like to make invisible whatever form calls the Output form. I can do this by: thisform.visible = .F. DO FORM <outputform> thisform.visible = .T. but I would like to avoid having to edit so many forms. Is there a way I can achieve this from the Output class without having to edit all these calling forms. I am NOT passing the calling form as an object parameter to the class. I wish now that I was! Thanks Stephen Tag: Reconstructing a DBF from its index Tag: 231475
  - 8
    - What's in the 71st byte of FXP files? We're using an utility who checks differences between FXP from different releases of a VFP software, and it uses a simple file compare logic. We cannot base that on "data and time modified" because these are unreliable, expecially after another utility recompiles all of the files. This morning we started noticing that the comparison found differences in all of the FXP even if we modified only a few, and the reason is that the 71st byte is always different from the past releases. It looks like something has changed in the output of the "compile xxx nodebug" command, starting from yesterday or today. Has anyone else had an issue as this? What could have triggered this situation? And, BTW, who knows where I can find info on the FXP file structure, of about the 71st byte of FXP's? -- Microsoft News Tag: Reconstructing a DBF from its index Tag: 231474
  - 9
    - Combine aggregate records from a UNION? Say I have 2 tables of invoices, one containing 2006 invoices and the other 2007. In a single SQL statement, I want to sum up the invoice amounts, grouped by customer number: SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2006 GROUP BY CustNo UNION ALL SELECT CustNo, SUM(Amount) AS InvTotal FROM Inv2007 GROUP BY CustNo INTO CURSOR Tmp ORDER BY CustNo If a given CustNo exists in both Inv2006 and Inv2007, the UNION will produce 2 records for this CustNo: one with the total amount for 2006 - the other the total for 2007. How can I modify my SQL statement to consolidate the results of the UNION so that I only end up with ONE record for the CustNo - with InvTotal equal to the total customer spent in 2006 plus 2007? Many thanks! -Mike Tag: Reconstructing a DBF from its index Tag: 231461
  - 10
    - missing subreport? ireponame = 'REPT_360.rpt' isubreponame = 'subtotal' SetCrRpt(thisform.olecontrol1) with Thisform.olecontrol1 .reportfilename = ireponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = isubreponame .datafiles(0) = fnd .connect = 'DSN=TEMP' .subreporttochange = '' .destination = outputtype .printreport() endwith I found that there is no "subreport.rpt", only a "rept_360.rpt". Is this sub-report a fake? -- iTech Consulting Services Limited Expert of ePOS solutions Website: http://www.itech.com.hk (IE only) Tel: (852)2325 3883 Fax: (852)2325 8288 Tag: Reconstructing a DBF from its index Tag: 231459
  - 11
    - Tableupdate failure-index does not match..... I have a parameterized view. I put a few records in it. I update the records. I issue tableupdate. If I don't update the first record in the view, the tableupdate fails, and aerror() shows me Index does not match the table..., error 114. I know for a fact that there is nothing wrong with the index, and this only happens if I don't enter a value in the first record. I've seen this before, but don't remember where or when. Anyone recognize this issue? Tag: Reconstructing a DBF from its index Tag: 231456
  - 12
    - Customzied papersize setting Hi all, I have defined a new label size for printing labels using barcode printer. It works fine in my pc when running my foxpro program. However, when it is printed from the others pc, the label size gets the other size although new label size is already set. I have tested many times by setting the default printer which refered to the new label size. It still failed. Finally, I discovered that it's the problem of papersize. My PC papersize for the new label is 134 and it works in my pc but not on the others. However, I have set the papersize to 154 and it doesn't work on my pc, but it works on one of my colleagues pc. Is there any default papersize setting that refer to customized size on window XP ? Thanks a lot! -- sze Tag: Reconstructing a DBF from its index Tag: 231455
  - 13
    - Disable Menu Items Hi, How do I disable Menu Items (Using Define Menu) when I preview a report? Thanks, Herbert Tag: Reconstructing a DBF from its index Tag: 231453
  - 14
    - How to get the form object ? Dear All, How to get the "Form Name or Form Object" in object "ytxt" ? e.g. ytxt = thisform.pgf1.page1.pgf2.page3.txtbox Thanks ! Tag: Reconstructing a DBF from its index Tag: 231441
  - 15
    - test -- Thanks ! Tag: Reconstructing a DBF from its index Tag: 231440
  - 16
    - Import UTF-8 text from Excel Is it possible to import or read texts from an Excel file that include = UTF-8 texts? Robert Tag: Reconstructing a DBF from its index Tag: 231435
  - 17
    - Intermittent Error 12 - Variable Not Found I have a situation where I am intermittently getting Error 12's trapped to my application (VFP7 based). The code path is something like the following: In my form: snparptr = 0 =gnssadd(,,,,) In gnssadd the following code is executed: =gnaddrec() REPLACE fddate WITH DATE(), ; fcsnaptime WITH TIME(), ; fnparent WITH snparptr, ; fccancel WITH vccancel, ; fctable WITH lctable, ; fcaction WITH vcaction, ; fnrecno WITH lnrecno, ; fcprompt WITH vcprompt SAVE TO MEMO fmdata ALL LIKE f* The gnaddrec either adds a new record to a table or reuses a deleted record. The error 12 error nominates the snparptr as the variable that is not found I cannot see a code path were the snparptr variable is disposed of. The problem is very intermittent and in most cases once the error has been received you can re-enter the program and execute the same function and have it work fine. Is there some resource that is being depleted that is causing this error? or any suggestions of another cause? thanks pete Tag: Reconstructing a DBF from its index Tag: 231428
  - 18
    - eReports on vfp6 untracable error Using DBX tech eReports, we have a report to pdf conversion that works fine in the IDE and locally compiled but returns a code 124 on a clients system running under terminal services. the oReports.ErrorLog seems not to be returning a string any help to resolve this would be appreciated John Tag: Reconstructing a DBF from its index Tag: 231426
  - 19
    - do work intellisense , form , with , endWith This is a multi-part message in MIME format. ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all i would like to have intellisense for my form, With the operator With = EndWith i would like to have my custom Method or Custom Property. With ThisForm as Form of G_RUE.SCX EndWith it's doesn't work , have you an idea ? thank's=20 Olivier ------=_NextPart_000_00B0_01C76FB5.AC335F00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.3059" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>Hi = all</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 = size=3D2></FONT></STRONG> </DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have=20 intellisense for my form, With the operator With = EndWith</FONT></STRONG></DIV> <DIV><STRONG><FONT face=3DArial color=3D#000080 size=3D2>i would like to = have my=20 custom Method or Custom Property.</FONT></STRONG></DIV> <DIV> <DIV><FONT face=3D"Courier New" color=3D#0000ff size=3D2><BR>With = ThisForm as Form of=20 </FONT><FONT face=3D"Courier New" size=3D2>G_RUE.SCX</FONT></DIV> <DIV> <P><FONT face=3D"Courier New" size=3D2>EndWith</FONT></P> <P><FONT face=3D"Courier New" size=3D2><STRONG><FONT face=3DArial = color=3D#000080>it's=20 doesn't work , have you an idea ?<BR><BR>thank's=20 <BR></FONT></STRONG></FONT><STRONG><FONT face=3DArial color=3D#000080=20 size=3D2>Olivier</FONT><FONT=20 face=3D"Courier New"></P></FONT></STRONG></DIV></DIV></BODY></HTML> ------=_NextPart_000_00B0_01C76FB5.AC335F00-- Tag: Reconstructing a DBF from its index Tag: 231416
  - 20
    - vfp9 speed issue group, our app has several screens with hundreds of objects. They open instantaneously in vfp6 but they take over 10 seconds in vfp9, making 9 totally useless for us. Has anyone come across this type of behavior? We use vfp9sp1. Wade Tag: Reconstructing a DBF from its index Tag: 231410
  - 21
    - Active Directory User name and Password How can I read the user name and password from Active Directory? in other words how can I authenticate a user through Active Directory? Thanks HME Tag: Reconstructing a DBF from its index Tag: 231406
  - 22
    - print dbf file How do i print dbf file Tag: Reconstructing a DBF from its index Tag: 231382
  - 23
    - Which Tags Are Used? Hello and thanks for the help. Is there any data in the CDX file that would indicate that last time an index tag was used? I have a table with a lot of tags some of which I sure are never used. I can search the code but that doesn't tell me which ones might have been created to speed up an SQL query. Is there any index tag usage data available? Thanks, Jeff Tag: Reconstructing a DBF from its index Tag: 231367
  - 24
    - Fox Programmer .... Need Jobs Sir, My name is Tommy from Thailand. With my Visual FoxPro experience more than 6 years. I need more jobs. Who have jobs for me, feel free to contact me anytime Thanks Tag: Reconstructing a DBF from its index Tag: 231366
  - 25
    - Check to see if SQL table has been updated by another user Hi... What's the quickest and simplest way to check if a row has been changed (by another user) on a remote SQL table? Obviously TABLEUPDATE returns .F. if it encounters and error but it would be better to 'test' the condition before even attempting to perform the update. Any help would be much appreciated. Tag: Reconstructing a DBF from its index Tag: 231364

My client lost a DBF. However, I am not too worried because it is indexed on
two fields which are the only essential ones. Here's the situation:
USE XY
INDEX ON X+Y TO XY.IDX
(X and Y are character fields).
I've looked at XY.IDX with MODIFY FILE XY.IDX, and it doesn't look too
arcane. It does have stretches of nulls and control characters (maybe that's
the famous Rushmore!), but the fields X and Y are clearly visible.
My question is: does anybody have a utility or method to recreate XY.DBF
from XY.IDX? has anybody actually done it? (that would be encouraging).

Top

Re: Reconstructing a DBF from its index by Man-wai

Man-wai
Tue Apr 03 21:15:45 CDT 2007

> My question is: does anybody have a utility or method to recreate XY.DBF
> from XY.IDX? has anybody actually done it? (that would be encouraging).

http://msdn2.microsoft.com/en-us/library/x0btabez(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/s8tb8f47(VS.80).aspx

Not difficult to DIY once you understood the sturctures....

--
iTech Consulting Services Limited
Expert of ePOS solutions
Website: http://www.itech.com.hk (IE only)
Tel: (852)2325 3883 Fax: (852)2325 8288

Top