ObjectPAL Topic

{Too Long!}

{Too Long!}

{Too Long!}

I have an OCX file that I wrote that does simple file transfers and fills in an Excel spreadsheet.  The OCX is on 3 forms.  I had to recently make an update to it so I re-registered it and put it back on the forms.  The first form calls the file transfer method and this works fine for everybody.  One of the other forms calls the exact same method (this method was NOT updated btw) and all computers with the exception of mine return the message "OCX Unavailable for access".  I dont know why that method would work on one form and not the other and I dont know why it would work for me on my computer but not on any other computer.  Any ideas?

Hi Does anyone know if it's possible to change the icon of the mouse cursor? I want to change it to an arrow when hovering over a table, instead of the 'line' cursor. Thanks for any help!

Does anyone know how to write this Paradox 4.5 code into a Paradox 11 script? This works in my old Paradox. It goes through a list of account names finds the account in another table and scans to produce a balance due. Code: view "dish-ar", view "ulist" moveto "ulist" , for i from 1 to nrecords("ulist"), mykey = [ulist->iname], moveto record i counter = 0 moveto [dish-ar->iname] scan for [iname] = mykey and not EOT(), counter = counter + [charge] + [credit], editkey, [account balance] = counter, endscan DO_IT!, ;message strval(mykey) sleep 1000, moveto "ulist", endfor, clearall

I have a client with a lot of computer hooked up via Netware to a Paradox 9 application. A couple of days ago one computer started getting an odd error message anytime a table was accessed. The error message is:, , "No More Files.", , I was out there todays and everything looks right. The net directory is up. All the alias' are right, etc. etc. etc. Check everything I could thing off and it all looks good. Reinstalled Paradox, nothing worked. , , Has anyone run into this error message before?

The biggest hurdle for users of data based programes is finding the time to do the inputting.  Has there been any advances in voice activation for Paradox. Is this feature built into a program such as PDX or is it an add on ?

{Too Long!}

Are there any examples of how to trap an event for a scroll wheel of a mouse?, , I am having an issue with users unitentionally adding a record by scrolling the mouse wheel.   The form proprty AutoAppend is set to false,  and I trap Pg up and Pg down keys to prevent this issue.   Unfortunately I have not been able to trap the mouse wheel.

{Too Long!}

In ObjectPAL, a developer can use the... ui.create() method to add uiObjects to a form with PageTool, BoxTool, ButtonTool, ChartTool, ElipseTool, GraphicTool, LineTool, OLETool, FieldTool, etc. Is there a similar feature available in C# .NET? 

{Too Long!}

Hi all, I know how to find files using FileSystem  but I can't work out if it is possible to use Windows search from within ObjectPal to locate Word files containing specific words (without first converting to text).  Maybe DDE or OLE? Thankyou. Paul.

{Too Long!}

Does anyone know the reason for the following predicament:, , Using Paradox 10, , Code executes to print a report to the default printer. We call , rpi.orient = PrintLandscape, , I have two different computers that execute same code and both use same printer., , One computer sends print job to printer and in turn printer prints the report in Landscape orientation as it should., , HOWEVER, the other computer send the print job and in turn the printer prints the report in PORTRAIT orientation - which is wrong., , Any ideas?, , Thanks,, Beth

{Too Long!}

I have used graphic readfromfile for years successfully in WinXP, Win7 and, until recently, Win10.  All of a sudden, I get "Cannot read file".  It had worked perfectly until a Win10 update.  Corel support is unresponsive.  Desperate at this point.  Does anyone have a work-around suggestion? Thanks. Bob

Is there a pop up calendar available for 10/3x?

We have almost completed our port from Windows 7 and Paradox 8 to Windows 10 and Paradox 11.  I am down to the last few bugs.  One is that all my date queries suddenly produce no results.  It turns out this is because I had been using 4-digit years, and now only 2-digit years seem to work in queries althought years are displayed as 4-digit in the queried table.  Weird. Anyhow, I suppose I could reprogram all date queries as 2-digit years, but this seem like bad practice.  And hard. So, I wondered if there is anywhere that I can easily reset the date format back to 4-digit years?  I already tried the Windows 10 short format, but it was already set to 4-digit years.  Any other ideas? Thanks! Steve

I have Paradox 11.0.0.676 and thought some of my woes might be fixed with the lates service pack.  I contacted Corel tech support and they said... to contact you!  You are probably either flattered or annoyed, or prehaps both.  Anyhow, is this service pack available anywhere?  Corel had Service Pack 3 for WordPerfect x7 Pro, which I bought, but it does not include the Paradox service pack with it. Thanks!

We are migrating an application from Paradox 8 to Paradox 11 to run on Windows 10. Some things broke, and still need to be fixed.  Since I haven't written any ObjectPAL code in 20 years this isn't as easy as I had hoped.  We are about 90% functional in Paradox 11, but as we chip away at the other 10% I wonder if it is possible to safely run 8 and 11 simultaneously, meaning to pointing at the same tables at the same time? It appears that anything compiled is version-specific, so we can simply use the uncompiled files until migration is complete, except for a couple of parallel libraries that will need to exist.  If this works we will be able to continue to support the mission-critical pieces on Paradox 8 that are still not working on 11.  My big fear is corrupting the data somehow. I appreciate your thoughts! Steve

I need to use the contents of a parameter to pull a field's contents. Visual FoxPro uses the & character for that sort of thing. Is there a Paradox equivalent? Edit: Fount it - it's called dereferencing, eg  sField = "Name"   ;Assign a field name to the variable., view(tcCustomer.(sField));Dereference the variable using parentheses. from:  https://www.prestwoodboards.com/ASPSuite/KB/Document_View.asp?QID=101169

{Too Long!}

Hi All, I‘m trying to change the first field in a table which has copied data from another table. I have tried using the following code but it does not change the last record. I have tried this code as a stand alone bit of code on another button on the form and it works. The variable as can be viewed and are correct Paradox  11 is the version. if not tc2.open(":caliachData:CopyWindingData.DB") then errorshow(), else while tc2.eot() = false, tc2.edit() if tc2.fldTrfWdgPartNum = oldpno then tc2.fldTrfWdgPartNum = cpno tc2.nextrecord() Endif, , endwhile, , Endif Thanking yo in advance Cheers Bill