Thread 25 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Table Repair in Version 10Using version 10, when I try and run the table repair utility, I get a message that state "Invalid Alias" and the table repair won't run. What gives? Anyone else run into this? Is there a work around?, , Any help would be appreciated.
|
 3314 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 24 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: limit on export paradox to excelI have not run into the this message myself. But my guess would be that it's a limitation in the number of Excel row allowed. It's a Microsoft limitation. I have run into similar thing in Excel before., , Question, why would you want to but that many rows in Excel in the first place. It would take for ever to load the file and be almost impossible to work with. |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 23 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 Rick Jasperson | Printing reports from Paradox 9 app in Windows XPI have a Paradox 9 runtime app that I recently installed on a box runing XP professional. All features of the app run fine except for the printing of reports. When trying to print a report a General Fault error ocurs. Does this mean that Pdox9 and XP are incompatible or do I need to change something in the print code. , Any thoughts would be appreciated., , Rick Jasperson  CliffSuttle | What happens if you don't open it first? Try going straight to the print command. |
|
 3730 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 22 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Printing reports from Paradox 9 app in WindowsWhat happens if you don't open it first? Try going straight to the print command. |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
|
|
Thread 19 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 Paul Castelow | Simple InventoryI have a simple Inventory system with three tables, Product.db, Purchases.db and used. the "taking in" of stock is done with a PushButton with the following and the "Stock out" is converse :-, var, tc tCursor, endvar, , if PurchaseIn = "" then msgStop("No Data","You didn't put a number in the field!") return endif, if ProductName = "" then msgStop("No Data","You didn't pick a product!") return endif, , tc.open("Prod.db"), tc.edit(), if not tc.locate("ProductName",ProductName.value), then msgStop("Error","Product not found"), tc.endEdit(), tc.close(), return, endif, , tc.Amount = (tc.Amount+PurchaseIn), tc.postRecord(), tc.endEdit(), tc.close(), Trouble is you have to toggle the Navigation bar forward and back a record before the code works. Can anybody solve this one?, Cheers,, Paul |
 1853 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 18 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Simple InventoryGlad it worked out. |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
|
|
Thread 15 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Word DucumentYes, there is a way to do this with the execute command. Here is an example that calls a WordPerfect document, but word would work too., , wpProg = "c:\\Program Files\\Corel\\WordPerfect Office 2002\\programs\\wpwin10.exe", docName = "sample.wpd", , execute(wpProg + " " +docName,No,ExeShowNormal), , Should be simple enough to change it for your application., , Good luck,, Cliff Suttle, Antler Software Technologies |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 14 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 weefo | Transfer NUMBERS to ALPHA field ???I'm trying to transfer data from a number field to a alpha field by using a tcursor and scanning the table. The numbers represent small percentages (i.e. 0.000781 or .000015). , , The problem is, for small numbers, the tcursor only transfers two digits after the decimal. Consequently, any number less than ".01" gets transferred as ".00". , , Is there another way to do this? Ideally, I would like to transfer the data to six digits after the decimal., , THANKS for your HELP!, , Keith Siegel, Keith@ricoequipment.com  CliffSuttle | Look into the "Format" command. That should do it. |
|
 1559 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 13 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Transfer NUMBERS to ALPHA field ???Look into the "Format" command. That should do it. |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 12 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Top 25 Customers ReportThis one is real easy., , var, darr dynArray[] anytype, tc tCursor, rev currency, endVar, , ; sort your table first as in your email, , tc.open(":priv:sortme.db"), tc.moveToRecNo(25), rev = tc."revenue", darr["Revenue"] = ">=" + string(rev), tc.setGenFilter(darr), tc.copy(":PRIV:top25.db"), , ; that's it |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 11 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Aparadox 9.0 Application on network using ORACDelete any PDOXUSER.LCK files, PDOXUSER.NET, or PARADOX.NET files you may find either on the network or on the work stations. Also, any other "*.LCK" files you may find in Paradox data directories. These could have the same name as tables in your directory. Don't delete all "*.LCK" files because other applications often use this extension too including Netware. Only delete them from Paradox data directories or Private directories on the workstations., , These files can, under certain cercumstances, become corrupted. When you delete these files, Paradox will rebuild them as needed., , In 99% of the cases, this will do it. |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 10 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: PDOXUSRS.NET on LaptopsI'm sorry about that. I just looked it up, it's "-p" |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
|
Thread 8 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: BIG problem with speed of application. Very URSetGenFilter is NOT very fast. It doesn't use or respect indexes. Are you running queries? They normally run pretty fast. Also, if you have to use a lot of fitlers again non-indexed tables, concider using the "Index" command first. |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
|
|
|
|
Thread 3 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 watekco | Converting Paradox 4.5 Library Script to ObjectPalDoes anyone knows about a utility or a way to convert Paradox 4.5 scripts (library) to Paradox 9 or 11 ObjectPal. I have just purchased a copy Paradox 11 for this project. My client is very happy with their 4.5 application but would like to migrate it to Paradox 9 or 11. That you for whatever you can do. |
 3630 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 2 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Converting Paradox 4.5 Library Script to ObjecHi,, , Is this Paradox 4.5 for dos or 4.5 for windows?, , If it's 4.5 for windows that an easy one. Just open up the library in design mode and resave it. Your done., , If it's 4.5 for dos, that's an complete different story. The Pal code for dos was very different from ObjectPal for windows. There is no real way to convert this automatically. You need to convert the code manually. It really help if you are verse in both languages. This can be done, but takes time., , If you need help with a dos conversion, contact me., , [URL=http://www.AntlerSoftware.com]www.AntlerSoftware.com[/URL] |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|
Thread 1 of 25 |
Thread Starter or a Reply (but not last) | | | Group |
 CliffSuttle | Re: Form timeoutYeah, that's doable., , Look into the timer and setTimer commands. , , Add a command to the open method on the form of, , self.setTimer(300000) ; this will check every five minutes., , On the timer method at the form level, check to see if the current time is equal or greater than the time you want to close and shut down the form, or exit paradox altogether. Should work great. |
 2 Hits |  Corel Paradox / ObjectPAL Coding |
|