IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
CliffSuttle
-Collapse +Expand Profile
Public Profile
Member Info
Member Narration
MB Posts (90)◄╣
KB Posts (4)

LISTPAGES
Tech Articles

Search CliffSuttle:

Advanced
   ► MB Lobby     Print This   
   ► MB Lobby     Print This   

CliffSuttle Message Board Activity

  


25 Message Board Posts:


Thread 25 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: limit on export paradox to excel
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.
8 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 24 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: Printing reports from Paradox 9 app in Windows
What happens if you don't open it first? Try going straight to the print command.
Posted to MB Topic: ObjectPAL « Paradox Board
8 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 22 of 25
Thread Starter or a Reply (but not last)  Group

Rick Jasperson
Printing reports from Paradox 9 app in Windows XP
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
8 years ago

CliffSuttle
What happens if you don't open it first? Try going straight to the print command.
8 years ago
Nothing New Since Your Last Visit
2423
Hits

Corel Paradox / ObjectPAL Coding

Thread 20 of 25
Thread Starter or a Reply (but not last)  Group

Paul Castelow
Simple Inventory
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
8 years ago

CliffSuttle
Glad it worked out.
8 years ago
Nothing New Since Your Last Visit
1236
Hits

Corel Paradox / ObjectPAL Coding

Thread 19 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: Simple Inventory
Glad it worked out.
Posted to MB Topic: ObjectPAL « Paradox Board
8 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 16 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: Word Ducument
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
8 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 15 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.
Posted to MB Topic: ObjectPAL « Paradox Board
9 years ago
Nothing New Since Your Last Visit
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
Posted to MB Topic: ObjectPAL « Paradox Board
9 years ago

CliffSuttle
Look into the "Format" command. That should do it.
9 years ago
Nothing New Since Your Last Visit
991
Hits

Corel Paradox / ObjectPAL Coding

Thread 13 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: Top 25 Customers Report
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
9 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 12 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: Aparadox 9.0 Application on network using ORAC
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.
9 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 11 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: PDOXUSRS.NET on Laptops
I'm sorry about that. I just looked it up, it's "-p"
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
9 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 9 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: BIG problem with speed of application. Very UR
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
9 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 4 of 25
Thread Starter or a Reply (but not last)  Group

watekco
Converting Paradox 4.5 Library Script to ObjectPal
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
9 years ago

CliffSuttle
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 do...
9 years ago
Nothing New Since Your Last Visit
2843
Hits

Corel Paradox / ObjectPAL Coding

Thread 3 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: Converting Paradox 4.5 Library Script to Objec
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
9 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 2 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Re: Form timeout
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
9 years ago
Nothing New Since Your Last Visit
2
Hits

Corel Paradox / ObjectPAL Coding

Thread 1 of 25
Thread Starter or a Reply (but not last)  Group

CliffSuttle
Latest BDE
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
9 years ago

stevecaple
That's the version of the BDE Administrator software. Open it, drop down the Object menu, select Version Information, and you'll see you BDE version in excruciating detail
9 years ago
Nothing New Since Your Last Visit
841
Hits

Corel Paradox / ObjectPAL Coding
-
  Load Time=less than 1 second.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


-
 
Connect With Us...
PrestwoodBoards
Join Us!
Facebook
Like our page!!!
Twitter
Follow us!
LinkedIn
Join Group
YouTube
View channel.
Go ahead!   Use Us! Call: 916-726-5675 


©1995-2014 Prestwood IT Solutions.   [Security & Privacy]   Made in the U.S.A..   No H1-B.   No offshoring.