Search results for query: *

Hi Thomman, I would direct you to the thread290-44654 - "Not a DBAse database error" on this forum. The most valuable parts are J Scannell's replies on Jan 11 & 14 and MiggyD's extension on Jan16. Hope this helps GEMS :-)

Dear Csub Quick Fix No 2 Actually this should be Quick Fix No 1 as it ought to be the first action in these circumstances. Whenever you modify the structure of a database file, dBASE makes a backup copy of the main data file for safety reasons. If the database has a memo field, it also...

dear csub, We'll assume this is error 41 - dBASE cannot open the database because it can't find the .DBT file or considers the file to be corrupt. If the .DBT is there, rename it because it may be possible to save its contents at a later date. The following procedure merely gains you access to...

GEMS Well done Jerry - I like your .exe solution and it it gets a vote from me! I was behind you in writing a fix (well behind it seems!) as I got really stuck with the command to call an application which would open, close the database and time stamp its third byte? What did you use? I stand...

Beware of impostors! Something about this problem, especially with lupdate() being credible stirs a memory. In a very large UK company, certain operators on specific stations were losing work and on later occasions, finding it mysteriously restored. Date-stamps on the files were screwed up as...

Mike, I’ve stayed out of this discussion, as I’m a DBIII only man. However, something about this problem rings a bell. DBIII stores a “date file last updated” in the .dbf file header. It enters a value when the file is first created and is only amended when… · the .dbf file is packed (with or...

WOW MiggyD - I like that Notepad idea. And then a light went off! I quickly typed in ! C:\PROGRA~1\MICROS~1\OFFICE~\EXCEL /p <filename> And nothing happened. Then I recalled something about command lengths &amp; orders and I tried ! C:\PROGRA~1\MICROS~1\OFFICE~\EXCEL <filename> /p And out of my...

Glad to hear that the hex editor solution is working. But have you tried the exporting methods I posted earlier? These export options should be available to you in Excel's “Save as type“ scroll box. If they are not there, were they omitted on installation to save space? Maybe you could get them...

BryantH is right on. Having done some digging, hope you all don’t mind if I show off. The header of a database file holds the essential data on file setup, no. of records, etc and the last date of update which is stored as bytes 1-3 of the header - for example 03640103 67010000...

Dear Mlima &amp; Denise - Sorry it took a while for you to get an answer, but it is the Christmas hangover period. The problem is date related! If you can reset the date to something like 03/01/1999 and perform your export, the resulting file will open in dBASE. I’ve tested this a few times and...

Dear klopez &amp; MiggyD I've posted a list of error codes and messages in the FAQ area. Hope these prove helpful to whomever. I've lot's more error data which I'll publish as &amp; when I unearth it in my system and tidy it for better understanding. Meanwhile back at klopez's problem, thanks...

Most DBIII+ manuals only give a selection of error messages. To complicate it further, Ashton Tate for some reason didn't number all the error codes. In desperation, I once managed to extract an almost complete list from the innards of the DBIII files.(I've led a sad life!) Sadly, no. 150 is the...

Dear geosta, Wow – When I read ‘rayleo’s reply I thought the guy was a super-genius – accomplishing the task in 23 lines of code and not 60 as in my attempt. Then I realised that his code only replaces the sought character in one specified field and only for one record. Phew!. I thought I’d got...

Dear rayleo, I used a series of DBIII+ applications on a network for a large company for many years. Despite trying LPT1, LPT2, COM1 etc, they could not be made to print to any local printer. I asked the network gurus at the company and the network provider for a piece of code or whatever to...

Dear geosta This is a long reply so I'll try & be brief. The following dbIII+ application will search and replace characters within a dbase file that the operator selects. It's a little rigid in that it's case specific. For example, to replace all occurrences of the letter ‘a’ with the letter...

Dear Geosta, Sorry you've had no replies and I felt I was the least likely person to help you have on this one - however here goes. I strongly suspect that the error message you have means there's a corrupt section on the disc. Try installing dbase V using these discs on another machine. The...

Here's another solution that is similar to the &quot;remainder&quot; technique already suggested. In the follwoing command, substitute CHOICE with the number you require - ie in your stated case - 10. The table is then restricted to that fraction ie a CHOICE of 10 gives a tenth - every tenth...

Sorry about the delay but I've only recently joined the group. I have written a DBIII+ routine which &quot;floats&quot; boxes above the screen (drop shadows), each box can be highlighted in turn via cursor keys and then selected with Enter. I also wrote another routine which mimics the pressing...

Where can I legally obtain the softaware to generate db III plus programs into stand alone exe files? I know I could convert to the current version of dbase/access/clipper/whatever - but serious illnes is cutting my time short for learning new systems. I'm not being morbid - merely practical. GEMS