IT SOLUTIONS
Your TECHNOLOGY partner! 
-Collapse +Expand
kwmillican
-Collapse +Expand Profile◄╣
       Print This   
Personal Account . . .
kwmillican
?
Rank: Cadet 4th Year
Email A E Unk
Send New Private Message Send Message   Add ContactAdd To Friend List Block Member Block Member
Real Name:  Kevin Millican
Joined: May 2009 (49 months ago)
Visits: 38
Member Points50
Primary Role:  Coder
Primary Group:  Paradox
Secondary Group:  Coder
Location:  UNK

Message Boards Activity

5 posts.
More...

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

kwmillican
Paradox 9 Maximum String Length
I always thought that Paradox could handle large strings but I don't seem to be able to manipulate strings in ObjectPAL larger than about 32K, The help says :-, "A String variable's length is limited to the virtual memory on your computer." I'm sure this wasn't a problem before. I'm using Paradox 9 with SP3 on Windows 7 Home Premium. e.g. This script reaches 32760 before it fails:-method run(var eventInfo Event), var, s string, endvar, , s="", while s.size()<100000, s=s+"1234567890", message(format("",s.size())), endwhile, endMethod,
Posted to MB Topic: ObjectPAL « Paradox Board
36 months ago

mprestwood
32,767 characters is pretty big so I'm not surprise you didn't run into it before.
36 months ago
Nothing New Since Your Last Visit
1677
Hits

Corel Paradox / ObjectPAL Coding

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

kwmillican
RE: Paradox 9 Maximum String Lengt...
Many thanks - that sorted it, and means I don't need to make the coding overly complex !I guess I never ran into this limitation before.,
Posted to MB Topic: ObjectPAL « Paradox Board
36 months ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

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

kwmillican
RE: Paradox 9 / 10 and Windows 7
I've edited my previous post to show that I have tested Paradox 9 successfully on Windows 7 Home Premium. Actually, it's more than a test; no problems whatsoever after 5 days intensive use. I would guess that as Mike's tested Ultimate, and I'm using Home Premium, it's unlikely the Pro version would be any different.,
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
44 months ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

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

kwmillican
RE: paradox 9 tables to mysql
{Too Long}
Posted to MB Topic: MS SQL « DBA Board
45 months ago
Nothing New Since Your Last Visit
DBA, Databases, & Data
More...

KB Comments


kwmillican
Read +Add Comment
Depends quite a bit on what you want to do. If you're just looking to control a mail-merge, then DDE is probably the best way to go. However, if you're looking to create a more sophisticated report using Word as a template, you might also consider using OpenOffice ODT format as an interim step. These are actually just zip files, so if you unzip them using ObjectPAL via a commandline utility, you can get at the text portion pretty easily. This allows you to create a complex template in OpenOffice with characteristic field markers that you can can process and rewrite with the markers replaced with any fields or data you want. Finally you rezip up the template as a new file which can be opened in Word or OpenOffice. It sounds complicated, but it really isn't, and it does free you from the limitations of the Paradox reporting tool.
Posted 13 months ago
Regarding...
Merge a Word Document with a Paradox table
DDE is one of several techniques for merging a word document with a Paradox table.
-
  Load Time=1 seconds.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


765 People Online Now!!  
Online Now: Sign In to see who's online now!  Not a member? Join now. It's free!
Show More...


©1995-2013 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech