--------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4V00001 Date: 04/25/97 From: GERRY DANEN Time: 12:51pm \/To: JEROEN VAN KALKEN (Read 2 times) Subj: FoxPro 2.5 Win transform() GD> I've got the strangest thing happening in FP2.5 for Windows. GD> Try this little program: GD> GD> amt = 8999.98 GD> ? transform(amt, '999,999.99') GD> GD> and I get this result: GD> GD> 9,000.00 GD> GD> Can anyone confirm this? Is this a known bug? The transform() GD> function started going strange about April 3rd of this year. Could GD> this be a date- related thing? JvK> Yes confirmed. (with fpw 2.6) JvK> But you forgot some essential line: JvK> set decimal to 0 JvK> apperently foxpro rounds amt to 'decimals' before executing the JvK> transform function. Actually, Windows was the culprit. Decimals were set to 0 in the international section of the control panel. Fixed that, and the problem went away. Gerry Danen gdanen@accessweb.com CompuServe: 102736,3352 ... What!? This isn't the Files section? --- Maximus 3.01 * Origin: C+Net BBS. Programming & Networking. (1:342/1017) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4V00002 Date: 04/25/97 From: STEVEN READ Time: 10:27pm \/To: GERRY DANEN (Read 2 times) Subj: Foxpro 2.5 win transform( On 04-18-97 (11:54) GERRY DANEN wrote to ALL About FOXPRO 2.5 WIN TRANSFORM( GD> I've got the strangest thing happening in FP2.5 for Windows. GD> amt = 8999.98 GD> ? transform(amt, '999,999.99') GD> and I get this result: GD> 9,000.00 GD> Can anyone confirm this? Is this a known bug? The Not a bug. Probably your SET DECIMAL TO command is your culprit. You want two decimals in your TRANSFORM() but have SET DECIMAL set to less than two decimals. Sounds like the SET DECIMAL statement wins the arguement. * Comfirmed the results from as far back as FoxBASE+ 2.10 * up thru FoxPro 2.6 for DOS/Win amt = 8999.98 set decimal to 0 ? transform(amt, '999,999.99') * -- prints 9000.00 set decimal to 1 ? transform(amt, '999,999.99') * -- prints 9000.00 set decimal to 2 ? transform(amt, '999,999.99') * -- prints 8999.98 Later, Steve, in western New York state (USA) --- * QMPro 1.53 * stevenreadpcohiocom "junk mail fouler" --- InterEcho 1.19 * Origin: PC-Ohio PCBoard * Cleveland, OH * 216-381-3320 (1:157/200) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4V00003 Date: 04/24/97 From: DAVID POWELL Time: 06:58pm \/To: GERRY DANEN (Read 2 times) Subj: Re: FoxPro 2.5 Win transform() Hi Gerry: DP> I tried the same thing and got the correct result: 8,999.98 GD> With version 2.5 of the Windows version? Yes. David in Dallas. --- Maximus/2 3.01 * Origin: * MacSavvy OS/2 BBS * Dallas, Texas * 972-250-4479 * (1:124/1208) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4V00004 Date: 04/24/97 From: DAVID POWELL Time: 07:08pm \/To: RANDY W FOGG (Read 2 times) Subj: FP 2.5/DOS AND NOVELL 3.11 Hi Randy: I ready your explanation to Disen. Nicely put. (Wish I'd written it!) RWF> Another point that should be looked at is HOW records are currently RWF> locked. For instance I RARELY use append or append RWF> blank because both require not only a record lock, but also lock the RWF> database header momentarily to update record counts etc. Or, as I do, you can use INSERT INTO ... David in Dallas. --- Maximus/2 3.01 * Origin: * MacSavvy OS/2 BBS * Dallas, Texas * 972-250-4479 * (1:124/1208) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4V00005 Date: 04/24/97 From: DAVID POWELL Time: 07:12pm \/To: GEORGE CLARK (Read 2 times) Subj: Databases vs Tables Hi George: GC> Now for my question, which is the better method (and why)? GC> Put all related tables into one big database. GC> It looks like this way only one call to use the GC> database loads everything. For simple management of the tables, this is the easiest. GC> Put only each related set of tables into separate databases. GC> Can use each database separately and may be able to GC> write separate modules without the extra overhead. The next easiest to manage .... until a relationship changes connecting tables from different .DBCs. GC> Non-related tables remain as Free Tables. Ah, 1.x technology. Actually, the advantage here is that other apps can directly read these .DBFs. They cannot do so when they are in a .DBC. The disadvantage is the data security and data integrity which must be programmed as you did in the early FoxBase. David in Dallas. --- Maximus/2 3.01 * Origin: * MacSavvy OS/2 BBS * Dallas, Texas * 972-250-4479 * (1:124/1208) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4V00006 Date: 04/24/97 From: DAVID POWELL Time: 07:18pm \/To: ABB NAKLIE (Read 2 times) Subj: Re: VFP 5 Books Hi Abb: AN> I was truly surprised. I wish I had seen her book before I bought AN> Alan Simpson's Mastering Access 97 because I would have bought it. AN> Alan is an Access defector because buried somewhere I know I have a ook AN> or two on dBase IV (or III+?) from him. Ah, Alan Simpson! He taught in San Diego when I was first learning dBASE. Nice fellow and a good instructor. He did a book on Lotus 1-2-3, too, if I remember correctly. Quite prolific -- as is Miriam. Although I prefer Miriam's works to Alan's, I still have fond memories of his classes. David in Dallas. --- Maximus/2 3.01 * Origin: * MacSavvy OS/2 BBS * Dallas, Texas * 972-250-4479 * (1:124/1208) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4V00007 Date: 04/25/97 From: ABB NAKLIE Time: 07:57pm \/To: LAWRENCE GARVIN (Read 2 times) Subj: Re: VFP 3.0 Database w/Ac -=> Quoting Lawrence Garvin to All <=- Hi Lawrence, LG> What would be required to permit Access 2.0 to work properly with VFP LG> 3.0 databases? I tried both to link and import a VFP 3 .dbf file into Access 2 with no luck - probably because the VFP 3 table is 32 bit. But I _did_ do it. What you have to do is use VFP 3 and _export_ your table to a FoxPro 2.5/2.6 format 1st. Then use Access 2 to either link or import the new table. That worked with me. Hope this helps, Abb ... I'm no teacher, but knowing me is certainly an education. ___ Blue Wave/DOS v2.30 [NR] - JetMail v1.20 6 - Unregistered QWK Mail Door for Spitfire --- SFScan v2.00 * Origin: (1:246/89.0) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4W00000 Date: 04/26/97 From: ERIC BARTE Time: 09:11pm \/To: ALL (Read 2 times) Subj: Foxpro and WIN NT Greetings, I have a Foxpro 2.6 (for DOS) application (EXE file) that won't run on the WIN NT server. It looks for the .ESO file (a foxpro overlay file). Everything works well on Windows 95, and on Novell. Can anybody help me with this problem? Eric eric.barte@iqbbs.com.ph --- Platinum Xpress/Win/Wildcat5! v2.0 * Origin: IQ BBS - Cebu City, Philippines (6:754/10) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4W00001 Date: 04/25/97 From: DAVID POWELL Time: 04:01pm \/To: ABB NAKLIE (Read 2 times) Subj: Re: VFP 3.0 Database w/Ac Hi Abb: AN> What you have to do is use VFP 3 and _export_ your AN> table to a FoxPro 2.5/2.6 AN> format 1st. Then use Access 2 to either link or import the new table. That will work, of course. Still, doesn't it seem surprising that the resources of Microsoft cannot give Access any better option that this inconvenient kludge? Where is all the "Connectivity" MS keeps talking about when two of its own products don't communicate directly through OLE2 or ODBC? Inquiring minds want to know. David in Dallas. --- Maximus/2 3.01 * Origin: * MacSavvy OS/2 BBS * Dallas, Texas * 972-250-4479 * (1:124/1208) --------------- FIDO MESSAGE AREA==> TOPIC: 139 FOXPRO Ref: E4W00002 Date: 04/26/97 From: ABB NAKLIE Time: 04:16pm \/To: DAVID POWELL (Read 2 times) Subj: Re: VFP 5 Books -=> Quoting David Powell to Abb Naklie <=- Hi David, DP> Ah, Alan Simpson! He taught in San Diego when I was first learning DP> dBASE. Nice fellow and a good instructor. He did a book on Lotus DP> 1-2-3, too, if I DP> remember correctly. Quite prolific -- as is Miriam. Although I DP> prefer Miriam's works to Alan's, I still have fond memories of his DP> classes. You were in this guy's class???? Yes, he is a good writer. Too bad he didn't write anything (that I know of) for FoxPro. He also wrote the first Mastering Access book (for V1.0) as well cause I bought it. And I believe you're right about a 1-2-3 book because I vaguely remember looking at a 1-2-3 language book by him. When I was browsing Miriam's Access book, I noticed no more "National Widgets" (her fictional company that I would see in all her books). She's still one of my favourites! Have a good one, Abb ... Humans are hard to train but they are the only servants cats have. ___ Blue Wave/DOS v2.30 [NR] - JetMail v1.20 6 - Unregistered QWK Mail Door for Spitfire --- SFScan v2.00 * Origin: (1:246/89.0)