Corel Paradox / ObjectPAL Coding Most Active Threads

I found a press release today on the Corel site from about a month ago with this interesting sentence:[quote]In addition, Corel has also released a special update for Paradox X4 that optimizes the database application to work with Windows Vista.[/quote] and later on[quote]In addition to downloading and installing SP1, customers who wish to run WordPerfect Office X4 Professional including Paradox X4 on Windows Vista should contact Corel to request a specific Paradox update that optimizes the sof...

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

Hi, has anyone had a chance to try Paradox  9 or 10 with beta versions of Windows 7?

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

Again with me and the XP box The application we are creating in Pdox9sp3 did work on the XP workstation running from the server. The settup uses a shared IDAPI.CFG on server harddrive thats mapped as G on all the workstations. The IDAPI points to the .NET file thats on G also. Suddenly the app won't run on the XP workstation any more with this error:, , Could not initialize BDE.:, You have attemted to open a database that is in use by someone else, but the database cannot be shared. you must set the location for the .NET control file., , The workstation can access the app and edit the files but the program won't run., , I'm thinking XP's is living on that workstation on borrowed time. Next error i'm whiping it. Harrrrr, , I'll be very appreciative of any help though :)

Posted to MB Topic: Paradox Forms

hello all,, i am just about to start a project using Paradox version 4.5... As this is my first time using Paradox i was wondering if one of the newer versions would be better and why???

Posted to MB Topic: Paradox Forms

Hey, I'm trying to update the old table from one that the changes live on. The idea is to find in the input table all the records that doesn't occur in the old table and add them. I've done some code with two nested loops. Outside loop is a while and the inside one is a scan. For some reason the inside loop scan is only called once, because the msgInfo after "proven inocent" only apears once. I think this means the while only run's once but I can't figure out why. This is the code I've come up with:, , isNew = true ;//guilty untill proven inocent, , if tcInput.open(inTable) and tcOutput.open(toTable) and tcOutput.edit() then, while tcInput.eot() = false, scan tcOutput, for upper(tcOutput."ProductName") = upper(tcInput."ProductName"), and upper(tcOutput."PresentationCode") = upper(tcInput."PresentationCode"), and upper(tcOutput."Volume") = upper(tcInput."Volume"), , : isNew = false ;//proven inocent, msgInfo(string(isNew),tcOutput."ProductName"), endScan, , if isNew then ;//dealing with...

Posted to MB Topic: ObjectPAL

Any info to support this or deny this would be great.thanks!!!!!

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

I have 2 forms. On form 1, the user makes a selection from a table, then pushes a button which opens form 2. This is my attempt to get around not being able to filter detail tables on a form. In other words, form 1 acts as a filter. This all works fine, if form 2 isn't already open., , My question is how to check whether form 2 is open and close it if it is. Or manipulate the tables in form 2 with it open., , Harry

Posted to MB Topic: ObjectPAL

I cut and paste images into an image field on a Paradox form and I've been doing this with no problems for years; yesterday I got a message saying 'Unknown internal operating system error' with a reference to the .MB file, when I tried to paste an image in. Paradox hung. After restarting, I verified and rebuilt the table and it imported the image ok but when I tried to do it with a new record the same thing happened.I'm using Paradox 10.0.0.663 running on a Lenovo laptop with Vista Home Premium and Service Pack 2. The database has 121,900 records in it but not all of them have images.Does anyone know what might be causing this? Any help would be appreciated, thanks.,

Posted to MB Topic: Paradox Forms

Is there a maximum library size that one should stay under. The reason I ask is that I am experiencing quite a few General Protection Faults and I am uncertain as to why. I know in the past that we encountered this problem with calling a windows dll from the uses block. Someone told me that Paradox had a problem with Windows libraries over 64K. Does this 64K size apply to all libraries?

Posted to MB Topic: ObjectPAL

Has anyone had any experience with running a Paradox 10 Application (via Runtime) on a Citrix Server or any multi-user environment., , We are currently running our apps on a variety of Windows op sys / desktop pc's. We are interested in possibly moving to a Citrix Server but have no experience. What are the differences between the two? And any stags we may face...., , Thanks for the help!

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

Hi, I joined the board because I thought I was one of the only folks who still uses Paradox.  I use Paradox 5 (stop laughing) on a Win XP Professional platform.  I built a stamp collection application for maintaining a catalog and inventory of my stamp collection, which is based on the Petroleum Industry theme.  I maintain my files on my Dell Dimension desktop and have been able to work on the tables with forms I created from my laptop via wireless home network.  I mapped some network drives on the laptop, set the working directory to the appropriate drive (via alias) and have been happily working this way for years.  Now my laptop is kaput, so I bought a new one and basically reproduced everything so I could continue using Paradox to access my tables over the wireless connection.  But when I try to open any form that shows the table data, I get an error: "Cannot open STAMP.DB", "Not initialized for accessing network files.", "Table: Z:\STAMP.DB". N...

Posted to MB Topic: Paradox Tables

How do you construct nested SELECT statements in Paradox?, , For example, this query would work in sql server but would error out on the second SELECT keyword:, , SELECT Product."PRODUCT_ID", Product."CO_ID", Product."PRODUCT_CATEGORY_ID", Product."PRODUCT_CODE", Product."DESCRIPTION", Matchcode_Products."MATCHCODE_PRODUCT_ID", Matchcode_Products."PRODUCT_ID", Matchcode_Products."MATCHCODE", Matchcode_Products."PRODUCT_EXISTS", Matchcode_Products."PRODUCT_COUNT", Matchcode_Products."OTHER_DESCRIPTION", FROM "Product.DB" Product, FULL OUTER JOIN , (SELECT * FROM "Matchcode_Products.DB" Matchcode_Products, WHERE Matchcode_Products."MATCHCODE" = '00646IMPRE231') mp, ON (Product."PRODUCT_ID" = mp."PRODUCT_ID"), WHERE Product."CO_ID" = 'D'

Posted to MB Topic: QBE & SQL

I'm looking into using sendkeys for a weekly function I want to accomplish. So I looked around and found this link: , http://www.prestwoodboards.com/ASPSuite/KB/Document_View.asp?QID=100211 On the bottom, it says , , ;Button :: pushButton, method pushButton(var eventInfo Event), ;% = ALT key., sendKeys("%FOTCustomer{ENTER}"), endMethod, , This should open up File, Open, Table, type Customer, and press enter. , , I put this code in a button, but nothing happens. Someone must know the problem. , , Thanks

Posted to MB Topic: ObjectPAL

Hi,, Is there going to be a Paradox 10? I noticed in the write-up Corel put out for their new office package it was not mentioned., Any word rumours?, Thanks

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

I am attempting to use the restructure method to add one index and 5 new fields to about 100 tables--something I WILL NOT do by hand. , , I have used the enum... methods an built example tables for the restructure() to use, but it does not want to add any new fields. When I look in the ObjectPal Reference guide, it tells me to use RestructureAdd to add fields by using the ID field in the tables to specify the operation type--the ID field is a numeric type, and will not allow text to be entered--what am I missing here?

Posted to MB Topic: ObjectPAL

After installing it, opening & closing it a few times, It won't open anymore. I get an error saying, Paradox for windows desktop has encountered a problem and needs to close. We are sorry for the inconvenience., If I uninstall and reinstall the same thing happens., Has anyone encountered this problem.

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

Is "Extended Uses" available in PDOX 7 ?

Posted to MB Topic: ObjectPAL

Can I open a Word Doc with a Pushbutton?, Thanks,, Paul

Posted to MB Topic: ObjectPAL

How could I get the results of a calculated field to go into the 'results' of a query and then into a report?, Pinot

Posted to MB Topic: Paradox Forms

Is it at all possible to open two Tcursors on the same table? I have a situation where I have to set a range on a table to find specific records. Then I have to scan through those records one by one and I have to compare them with all the other, to output the groups that go together. I’m thinking I’ll try a second Tcursor to open inside the range and make that scan through the records as well. Then I can compare the Tcursors with each other. Does any one know if this is possible, is there a better way to do this and what would the code look like, especially to open a Tcursor inside a range that’s set up on a first Tcursor? Any help will be greatly appreciated.

Posted to MB Topic: ObjectPAL

How can I publish an open report to static HTML with objectPal-commands (just like publishing to RTF or DOC-format)?, , In the reference-books it seemes that it must be done interactive.

Posted to MB Topic: ObjectPAL

Can anyone tell me how I can post multiple undefined check boxes to a field?, Example, there are 3 check boxes, named Boat, House and Cottage. If I check off any one of these fields, how can I post it to a field called "Description" in a table.Is it even possible without having to name each check box as a field in a table.

Posted to MB Topic: ObjectPAL

I am unable to find the Application Events option from the Tools menu in P9DE. It is mentioned in the User Manual, the Online help, and in Mike's Power Programming book., , There is a pop-up hint that mentions this option, but it is associated with the newly installed "Workbench". Uninstalling "Workbench" makes the hint that supposedly belongs to application events to move next to Application Menu (still in the wrong place)., , Does anyone else have trouble finding Application Events?, , Thanks,, , DB

Posted to MB Topic: Paradox Forms

I am trying to change the font/text attributes in a ListBox Object., , I could use some help if anyone has done this.

Posted to MB Topic: ObjectPAL

I have a very urgent issue here. Whe have written an application in paradox 9. We have installed our application at various clients for testing purposes. Most of the clients have less than 3 pc's and the speed of the application there is fine, but we also have 2 clients that run a network of about 10+ pc's connected to a windows xp server. At these two clients the speed of the application is extremely slow. Q: How do you find the speed of your applications(written in paradox) over a network? Q: Can anyone give my some ideas where to start looking? Q: Can it be paradox, code, network or the specs of the pc's? Also, these two clients both have Norton Anitivirus installed, could this have an effect? Any opinions would be greatly appreciated.

Posted to MB Topic: ObjectPAL