CliffSuttle Message Board Activity

I 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.

Posted to MB Topic: Paradox to/from Other Data Sources « Paradox Board

I 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

Posted to MB Topic: ObjectPAL « Paradox Board

What happens if you don't open it first? Try going straight to the print command.

Posted to MB Topic: ObjectPAL « Paradox Board

I 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

Posted to MB Topic: ObjectPAL « Paradox Board

Glad it worked out.

Posted to MB Topic: ObjectPAL « Paradox Board

Yes, 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

Posted to MB Topic: ObjectPAL « Paradox Board

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

Posted to MB Topic: ObjectPAL « Paradox Board

Look into the "Format" command. That should do it.

Posted to MB Topic: ObjectPAL « Paradox Board

This 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

Posted to MB Topic: Paradox Reports « Paradox Board

Delete 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.

Posted to MB Topic: Paradox to/from Other Data Sources « Paradox Board

I'm sorry about that. I just looked it up, it's "-p"

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

SetGenFilter 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.

Posted to MB Topic: ObjectPAL « Paradox Board

Does 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.

Posted to MB Topic: Paradox for DOS « Paradox Board

Hi,, , 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]

Posted to MB Topic: Paradox for DOS « Paradox Board

Yeah, 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.

Posted to MB Topic: ObjectPAL « Paradox Board

Downloaded the BDE update from Borland, version 5.11. Ran it and everything went fine. However, my BDE Administator still reports that I'm using 5.01. Tried a bunch of stuff and still having this situation., , Anyone run into that problem before?, , Thanks

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board