--------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DER00004 Date: 10/20/96 From: AHMAD KHIARY Time: 08:27pm \/To: BEN CAVANAGH (Read 2 times) Subj: HOW 2 KNOW IF IT'S A DBF Reference your message, BC>> Does somebody know if there's a function to check if a file of any BC>> extension is a DBF file. Because when I'm opening a non-dbf file BC>> with the command (USE) my program stop and say a error message. BC>> BC>> I need to load all the dbf file's (that they can have any extension), BC>> of a directory into an array to show them after in a menu. In Clipper V5.01 and later versions you have a function Directory() which will give you exactly what you need. Regards. Ahmad Khiary (Jeddah, Saudi Arabia) Internet ID : khiary@netbox.com --- RoseReader 2.52 P007485 --- QScan/PCB v1.19b / 01-0045 * Origin: Saudi BBS. Jeddah. Saudi Arabia +9662 667-2293 (2:542/100) --------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DER00005 Date: 10/20/96 From: FABIO FRANCA Time: 08:10pm \/To: ALL (Read 2 times) Subj: Exospace/Ca-Tools Hi All, I would like to know if anyone to be able to compile and link a program with CA CLIPPER 5.2e/EXOSPACE 1.0/CA TOOLS III. Whenever I link a program with exospace and CA Tolls the following error message appear: Warning 4023. And when I try to run the .EXE another error message appear: Error 35. Please, help me. Thank you. Fabio Franca. --- FMail/386 1.02 * Origin: CentroIn! +55-21-205-0281, 41 lines, 24h, RJ/Brazil (4:802/21) --------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DES00000 Date: 10/21/96 From: CHAZ HELLER Time: 08:23pm \/To: WALTER CO (Read 2 times) Subj: ASM FILES/PROGRAMS BH> WC> I mean do you know or do you have a program that can peek at BH> WC> the pc's bios password? Thanks.. well i have the program called killcmos.exe it does what you are talking about. if you want me to e-mail the program to you send your e-mail address to me at dr.seuss@juno.com with a subject of killcmos program needed. later chaz --- OLX 2.1 TD will the information superhighway ever get a traffic jam? --- FLAME v1.1 * Origin: ANCESTRY TBBS Shadows of forgotten ancestors 941-382-9061 (1:18/230) --------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DES00001 Date: 10/22/96 From: RAYMOND PESEK Time: 11:44pm \/To: CAREL FRIK (Read 2 times) Subj: Problem ca tools iii vs a CF -> I have seen a program running on a AMD K5 100 Mhz. It disabels the -> Level 1 cache and since then the internal Error from Clipper is gone. (R6003) -> It works! CF -> The program name is CACHECTL.EXE CF -> I have also found another program called CACHECHK.EXE CF -> I realy don't know if the program CACHECTL.EXE is also written by this -> Ray van Tassle but i do know both programs have the same date and time -> stamp. The docfile from cachechk has a different timestamp. They are, and are normally included in the same zip file. Unfortunately, this is a pretty poor workaround as disabling the internal cache makes the computer run like a pig, and if you're running under a multitasking system, you're affecting everything running at the same time. There's a few people working on this problem. If and when a fix becomes available, I'll post it here. Raymond Pesek * 1st 2.00 #2448 * Moderator - Clipper Echo --- InterEcho 1.18 * Origin: PC-Ohio PCBoard * Cleveland, OH * 216-381-3320 (1:157/200) --------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DET00000 Date: 10/21/96 From: ROBERT GAGNE Time: 09:19pm \/To: BEN CAVANAGH (Read 2 times) Subj: HOW 2 KNOW IF IT'S A DBF In a Message Dated 10-15-96, Ben Cavanagh wrote to All: BC> Does somebody know if there's a function to check if a file of any BC> extension is a DBF file. Because when I'm opening a non-dbf file BC> with the command (USE) my program stop and say a error message. Hi Ben, One way would be to built your own function to handle error, using the errorblock() function along with the error class functions. But this may be a lot of work... Another way would be to perform some checks on the header, which could confirm or infirm with reasonable accuracy that the file is a dbase/clipper database file. In case You are interested, here are some specs for the header : ------------------------------------------------------------------- DBASE - File header structure (DBASE III) Offset Size Description 00 byte dBASE vers num 03h=dBASE III w/o .DBT 83h=dBASE III w .DBT 01 byte year of last update 02 byte month of last update 03 byte day of last update 04 dword long int number of data records in file 08 word header structure length 10 word data record length 12 20bytes version 1.0 reserved data space 32-n 32bytes ea. field descriptors (see below) n+1 byte 0dH field terminator. dBASE - Field Descriptors Offset Size Description 00 11bytes null terminated field name string 11 byte data type, Char/Num/Logical/Date/Memo 12 dword long int field data address, (set in memory) 16 byte field length 17 byte number of decimal places 18 14bytes version 1.00 reserved data area ------------------------------------------------------------------- I hope this will help a little... Robert Gagne. --------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DET00001 Date: 10/21/96 From: BRYAN SMITH Time: 11:19am \/To: BEN CAVANAGH (Read 2 times) Subj: HOW 2 KNOW IF IT'S A DBF On 15 Oct 96 Ben Cavanagh said to All... BC> Does somebody know if there's a function to check if a file of any BC> extension is a DBF file. Because when I'm opening a non-dbf file BC> with the command (USE) my program stop and say a error message. I wonder why you allow your users to create .DBF files with other extensions ? You might try testing the file by reading in the first few bytes of the file with FREAD. You could check the first byte. If this is a regular Clipper .DBF file using dBase 3+ format, then bits 0,1,2 (values 1,2,4) should total to 3. Something like this (warning - untested code, for example only) ... nHandle := FOPEN(cFileName) cBuf := SPACE(4) // pre-allocate some memory (else VMIF !) FREAD(nHandle,@cBuf,4) // must be "@cBuf", not "cBuf" FCLOSE(nHandle) nAsc := ASC(cBuf) // ASCII value of 1st char. only nAsc := nAsc % 8 // modulo 8, i.e. 0..7, takes 3 low bits IF nAsc == 3 etc. ........... // then this MAY be a Clipper .DBF Also the next three bytes, which are the "last update" date, should translate to a reasonable date. I believe the bytes are year, month, day in that order. So the second byte (year) should be say 90..99 or 0..10, the third byte (month) should be in the range 1..12, and the fourth byte (day) should be in the range 1..31. You may need to reset the clock on your PC and update a DBF file, then use DEBUG to find out if year 2001 is listed as 01 or 101 in the DBF's header. It is also a good idea to get the system date from the PC's clock, and to scream murder if the year is 1980 (clock not set, in which case last update date is probably also invalid). IF YEAR(DATE()) < nYearIWroteCode .... // e.g. 1996 - then scream at user ! nAsc := ASC(SUBSTR(cBuf,2,1)) IF ((nASC > 90) .AND. (nAsc < 100)) .OR. (nASC < 10) ...... Year looks OK nAsc := ASC(SUBSTR(cBuf,3,1)) IF (nASC > 0) .AND. (nAsc < 13) ...... Month looks OK nAsc := ASC(SUBSTR(cBuf,4,1)) IF (nASC > 0) .AND. (nAsc < 32) ...... Day looks OK --- PPoint 2.00 * Origin: Kingston Canada (1:249/109.11) --------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DET00002 Date: 10/16/96 From: RADEK KAFKA Time: 11:27am \/To: RAYMOND PESEK (Read 2 times) Subj: Re: problem ca tools iii Hello Raymond! 13 Oct 96 20:53, Raymond Pesek wrote to Radek Kafka: RK ->> This is deasembled code for __wait.obj posted here. I have RK ->> changed ->> it to make it compatible with protected mode. RP> Did you do the work and can you try it on an AMD K5? Not in protected mode but in real mode it works. . Ufffff. :-)))) As for my problems with sixcdx I've looked to SucessWare's WWW and there are no updates to my version ( I have the most recent - 3.1.0 I thing ).. :-) Still problem with stack...1011 errors etc ... :-(((( RP> Raymond Pesek RP> * 1st 2.00 #2448 * Moderator - Clipper Echo RP> -+- InterEcho 1.18 RP> + Origin: PC-Ohio PCBoard * Cleveland, OH * 216-381-3320 (1:157/200) Radek [Team OS/2] E-Mail Radek Kafka Fido 2:423/34.7@fidonet.org --- FMail/2 1.02 * Origin: ORIMEX POINT (voice) 42-47-562-00-61 (2:423/34.7) --------------- FIDO MESSAGE AREA==> TOPIC: 202 CLIPPER Ref: DET00003 Date: 10/21/96 From: PETER HUYBERS Time: 10:03pm \/To: BEN CAVANAGH (Read 2 times) Subj: HOW 2 KNOW IF IT'S A DBF BC> Does somebody know if there's a function to check if a file of any BC> extension is a DBF file. Because when I'm opening a non-dbf file BC> with the command (USE) my program stop and say a error message. BC> I need to load all the dbf file's (that they can have any xtension), BC> of a directory into an array to show them after in a menu. I know that the first 2 byte of a DBF-file are 03 60 Hex. You can check (fopen,fread) if its the case, if not its NOT a valid DBF file. if its the case, it MAYBE a DBF file. Peter. --- * Origin: -= Gewoon BBS/2 Heumen. V.34/V.FC =- (2:284/603)