--------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5N00001 Date: 05/16/95 From: RICHARD CLARKE Time: 08:54am \/To: JAN HOOLWERF (Read 6 times) Subj: Pdox 4.5 (DOS) / WARP In a msg on , Jan Hoolwerf of 2:283/203.1 writes: JH> I had the same problem with PDox 4.0 DOS and also with 4.5 DOS. Ditto for Pdx 4.5 DOS ... under Warp JH> As far as i can tell it has something to do with the use off the JH> mouse. If i do not use the mouse i can work at least 30 min. JH> (didn't try longer ) without problems and with mouse use i get JH> that error and sometimes within a few clicks. Found that just moving the mouse quickly could crash it. In our case, it was caused by a nonstandard mouse, mouse was switched, and the problem went away. Next time I get close to this machine again, I'll check settings to make sure that's all that was necessary (tried different session settings also). You could probably have worked all day, provided you didn't move the mouse. ttyl Richard --- msgedsq 2.0.5 * Origin: Richard's Private Point System. (1:134/15.20) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5N00002 Date: 05/16/95 From: GARY MCQUIGG Time: 01:30am \/To: ALL (Read 8 times) Subj: ROUND() FUNCTION Date: 5/15/95 From: Gary Mcquigg To: All Subject: P4W 5.0 Round() Could some one demonstrate an example of the Round() function. I do a Calc in a query; Calc Miles (Integer)*.275+Parking (,2) as Total Paid. Total Paid displays rounded but its not that easy as the sums in reports use the unrounded values. My attempts to solve this with ObjectPal have met with failure. This is what I thought should have worked, it didn't. Please laugh quietly :-), this is only my second try at ObjectPal. method pushButton(var eventInfo Event) var roundMe Number myTab Table myTC TCursor myQuery Query tv TableView custRpt Report endVar myTab.attach(":PRIV:ANSWER.DB") myTC.open(myTab) scan myTC: roundMe = myTC."Total Paid" format("W.2",roundMe.round(2)) endScan Am I even close? Thanks for your help. --- ConfMail V4.00 * Origin: YABBS,Bellevue Ne, 1:285/29 HST/DS/V.32bis 402-293-9065 (1:285/29) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5N00003 Date: 05/15/95 From: JEFF KUZMA Time: 10:39pm \/To: DAVID SHERMAN (Read 6 times) Subj: Paradox runtime error Dave: DS>KU>I believe I got that abort message before? Is your version 5.1? If not DS> >Borland has patch out. If you call them, for $10.00 they will send you DS> >new (complete) set. DS>I will do it! PMFJI, but isn't 5.1 the maintenance release from last December? Or is it a full-fledged upgrade release? Jeff === * OLX 2.1 TD * "Bother," said Pooh, and formatted his drive. --- TosScan 1.00 * Origin: Colossus - The Columbus Computer Society - Columbus, OH 1:226/120) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5N00004 Date: 05/18/95 From: DAVID GRANGER Time: 08:26pm \/To: PETER READER (Read 6 times) Subj: Adding procs to queries <** On 05-18-95, PETER READER said to ALAIN CLAVERIE: **> Hi Peter: PMFJI and although I am not sure what the original problem was, I would like to comment. I have been using Pdxwin since Ver. 4.5, and have built a substantial program for a friend in California to look after his business. PR>Nothing wrong with your English! But you're right-- this isn't the only PR>thing I've had trouble implementing in Paradox. I'm used to stand alone PR>applications that launch from an icon--Paradox seems to want to run PR>everything from within Paradox. Although Access does that too, Access While I may be misinterpreting your statement "Paradox seems to want to run everything from within Paradox", in my application, I start with the following command line: "c:\pdoxwin\PDOXWIN.exe /[lots of switches] config.sdl". The command line is setup in the "add program item" setup in Windows, so clicking the resulting Icon starts my program. The "config.sdl" is a delivered script file that invokes coding that "takes over control of the system", and only allows the user to see and do what I have allowed in the code. The "switches" involved, disable writing to PODXWIN.ini, disables writing to win.ini and sets up it's own XXX.ini file to save the application's configuration. As an example, the script, among other things, hides the "toolbar", sets up a Menu system and disables any keyboard input that is not specifically required by MY program. Disabling some keyboard input also "keeps" the user out of Paradox quite effectively. This places my application in TOTAL control. I have even disabled the Paradox signon screen, so the user sees little if any of the Paradox program. Just as an aside, the application also "calls" PCTools Backup when the user attempts to exit from the application, and if the user chooses "yes" to the backup dialog box question, the data is backed up. When this finishes, the application ends giving control back to Windows. Pardon my rambling, but I "can't help myself(gg)". You know what DB programmers are like.(gg) Hope this helps. Kindest Regards. David. ...coming to you from CANADA - the greatest country on the planet! ...now flying on Windows '95 --- * VbReader 2.22 #545 * "...ever feel like the only tree in a dog kennel?" --- QScan/PCB v1.15b / 01-0348 * Origin: FidoNet: CRS Online, Toronto, Ontario (1:229/15) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5N00005 Date: 05/18/95 From: PETER READER Time: 06:35pm \/To: LANCE LEONARD (Read 7 times) Subj: Adding procs to queries --------------------------------------------------------------------------- LL>Peter, LL>PR> Say I want a QBE field to contain LL>PR> either the contents of table field A or table field B depending on the LL>PR> contents of table field C. In Access I could write LL>PR> IIF(FieldC="Something",FieldA, FieldB). LL>What you want is a CHANGETO query, probably more than one. Consider the LL>following: LL> TABLE | FieldA | FieldB | FieldC | LL> | _A | | Something, CHANGETO _A | LL> | | _B | not Something, CHANGETO _B | Thanks a lot -- I think I can make this work. Glad to see you're still monitoring this echo. Maybe Version 6 will let us embed functions in a query! Still getting a lot of use out of Inside Paradox 5 for Windows. . . Peter peter.reader@nwcs.org * SLMR 2.1a * All hope abandon, ye who enter messages here. --- WILDMAIL!/WC v4.12 * Origin: NWCS Online (1:105/362.0) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5Q00000 Date: 05/19/95 From: LIZ MARR Time: 01:10pm \/To: JOE LABONTE (Read 7 times) Subj: Smartdrive - WFWG JL> I was thinking about removing SMARTDRIVE and the system cache and see if that helps. This machine is a 386 - 25 or 33 with 8 Meg RAM running WGFW. WFWG has caching built in, so you don't need to run Smartdrive unless you are also running DOS apps that need it. Liz Marr --- * CMPQwk #1.4 * UNREGISTERED EVALUATION COPY --- WILDMAIL!/WC v4.12 * Origin: EMERALD ONLINE * (503)343-1308 * 10GB * 11 NODES * (1:152/22.0) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5R00000 Date: 05/21/95 From: LANCE LEONARD Time: 02:12pm \/To: ALLAN WHITWORTH (Read 6 times) Subj: Page X of Y in PdoxDOS Allan, AW> ...Convenient PAL features NPAGES() AND PAGENO() sounded like a AW> good place to start. (They usually report only page WIDTHS). Even with free-form reports? -- Lance --- Maximus 2.02 * Origin: Mountain Retreat (1:216/506) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5R00001 Date: 05/21/95 From: LANCE LEONARD Time: 02:13pm \/To: JEFF KUZMA (Read 6 times) Subj: Paradox runtime error Jeff, JK> PMFJI, but isn't 5.1 the maintenance release from last December? JK> Or is it a full-fledged upgrade release? Only a maintenance release, though it does use a later version of IDAPI. Hope this helps... -- Lance --- Maximus 2.02 * Origin: Mountain Retreat (1:216/506) --------------- FIDO MESSAGE AREA==> TOPIC: 119 PARADOX Ref: C5R00002 Date: 05/21/95 From: LANCE LEONARD Time: 02:14pm \/To: GARY MCQUIGG (Read 6 times) Subj: ROUND() FUNCTION Gary, GM> Could some one demonstrate an example of the Round() function. GM> ... Try myTC.open( ":PRIV:ANSWER" ) myTC.edit() scan myTC : myTC."Total Paid" = round( myTC."Total Paid", 2 ) endScan myTC.endEdit() myTC.close() Hope this helps... -- Lance --- Maximus 2.02 * Origin: Mountain Retreat (1:216/506)