Corel Paradox / ObjectPAL Coding Unanswered Threads

{Too Long!}

Posted to MB Topic: Paradox Forms

Hi, Please any kind one tell me how to change the time on the time stamp field.  I forgot how to do it and could not find where in the system to read about it.  I need to change the time stamp field to coincide with the daylight saving time. Thank you kindly.

Posted to MB Topic: Paradox Forms

Is it possible to get a copy of the Installation guide for Paradox 9 Runtime? I have not been able to find it anywhere. Actually, it turns out that I also need to get the Paradox 9 Runtime files. I downloaded what I thought were the runtime files from Corel's FTP site, but what I got appears to be Service Packs, which only work with an installed version of the base files. , I am an old Paradox developer supporting a legacy app for a customer who doesn't want to switch. Except for this customer I haven't used Paradox in decades and no longer have any documentation.,

Posted to MB Topic: Paradox Runtime & Distribution

{Too Long!}

Posted to MB Topic: ObjectPAL

Hi everyone, I´m a network consultant of various small offices in Argentina that actually uses Paradox 8 over Windows XP. Paradox systems are mantained by a small team of local programmers. We just start to upgrade the workstations to Intel I5 / Windows 7 64bits (4gb of ram, maximum 32gb) Systems works Ok under Windows 7 64bits. We have read the article at /ASPSuite/KB/Document_View.asp?QID=101303 that says there is not 64-bit version of Paradox. In this case: - Are the new processor (Intel I5 here) a significative difference over the previous Pentium Dual Core?, - Are RAM upgrades of more of 3GB (eg: 8 / 16GB) fully used by Paradox Runtime?, , The scenario in this instalation is a centralized server (Samba/Linux) with Quadcore Xeon processor, Gigabit connection and 4Gigabytes of RAM. Can we optimize this server for Paradox with more memory? , thanks and regards!

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

{Too Long!}

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

I just started using Paradox 9.  (Had been using Paradox 7.) is there any way to get the right-click context sensitive menu back? For example, I often have mailing labels, and I would right-click and choose "Open With" to open with a new table.  How do I do that now? Also, I'd right-click a text file to import. Is there a way to get this functionality back?

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

I am trying to streamline a work flow for our secretary and it occurred to me that she can sequentially copy multiple texts in another application to clipboard with cntrl-c. She can do this in sequence. Say family name, given name unit number. Can she then click on a button in Paradox to distribute these values to a Paradox table?? No problem for a single item, but what about the multiple values? Thanks, Paul.

Posted to MB Topic: ObjectPAL

Hi, , My first post. I am trying to open a table in MS SQL 2008 that has a column defined as a ROWGUID datatype UniqueIdentifier and it fails. Is there a way to add this datatype mapping to BDE or get around it in ObjectPal? The ROWGUID is necessary to use FileStreaming for data in MS SQL 2008 so I cannot remove the column from the table.

Posted to MB Topic: ObjectPAL

{Too Long!}

Posted to MB Topic: Paradox Forms

{Too Long!}

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

I am running Paradox (forget which version) on Windows 7 64 bit and it has been running fairly well for some years.  Sometimes crashes, but doesn't corrupt data.  Just today, I developed some sort of problem that is preventing Paradox from starting.  When I try to start, I get an error: Could not initialize BDE.:, Cannot load language driver. I suspected there was something wrong in my .../Borland/Common Files/BDE directory, so I copied the BDE directory from my laptop, where Paradox still loads.  I still get the same error.  Any suggestions for a fix? Thanks Desperate Floyd.M NEVERMIND:  I uninstalled Paradox 7 and re-installed it and everything is working well.  Just have one corrupt Paradox table to fix.

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

HI Guys, I am pretty new to programming as such. Recently I undertook a project where I had to change the current forms to show an edit form before records get posted to the server table for good. However, one of the users is complaining that when he tries to enter data, the form seems to jump such that the line he was editing is not the line he should be.  Of all the users he seems to be the only one having this problem.  One other has said that it happens to her sometimes. I have looked at all the code, stripped all the unwanted code and cannot seem to see any reason why the form would be jumping for only one user. Can you help..it'll be well appreciated. Many Thanks, Ansuiya

Posted to MB Topic: Paradox Forms

Dear friends, I hope someone can help me with this intriguing problem: I have been using Paradox 9(Developers Edition) on VISTA for a couple of yeasr now, and generally, the problems have been few. Now I have an old project that isn't working properly, and whn I try to debug the code, the debugger goes completely blank, so I can't identify the problem. The code is very simple - it is linked to a drop-down list, and when the item has been selected, the name is used to look up related information in a table and put that information into a series of undefined fields. The problem is that the table look-up executes correctly, and the correct data is put into the required field; but the data(numeric) then changes and becomes totally unrelated to the real data. when I run the debugger, the screen goes blank and I can not follow the execution of the code. I am going crazy, can anyone help me please? many thanks in advance Alan,

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

{Too Long!}

Posted to MB Topic: Paradox Forms

I have a report that has a table on it.  The table is located in the PRIV file.   Object Pal code copies the table from the PrivMaster to the Priv folder and then Data is inserted into the table.  A report has the table on the data module and the table on the report is defined to the table in the PRIV folder.   The report will not print the first row in the table, but all subsequent rows will print.  I moved the data around in the table to make sure that it wasn't a specific piece of data, but  it appears to be only the first row in the table that is omitted when the report is printed.  Run Time property for the table on the report has the YES radio button selected on the Show All Records.  Any idea's of what I can check when the first row of the table will not print?  ,

Posted to MB Topic: Paradox Reports

{Too Long!}

Posted to MB Topic: Paradox Forms

Hi,I bought the office X5 professional, I have the paradox 9 developer too, my question is.. how  can I do my application (exe) developed whit  paradox 9 runs in paradox 11 Is it posible? I think Need news libraries, to fw , but where I  can find them

Posted to MB Topic: Application Framework

I've been running Paradox for Windows on a desktop in the office since the mid-'90's. I'm considering providing our sales reps with Windows tablets to streamline things. They will need to print customer copies in the field. Anyone have any experience with Paradox on a tablet? , Thanks, Lauston,

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

Database with 14K entries is back up to a corrupted database with loss of data. Repair shows no corruption. Working currently on Vista (Vista issues clear). Trying to open the blob files contents to rebuild the original deletes individual blob field contents permanently (leaving record and revisiting or closing file and reopening shows the records accessed without their stored objects). I keep hoping someone has an idea about this. it is most likely connected to the original issue of file corruption with disappearance of multiple blob entries. (about four hundred at last count). Exporting the file to a different folder and attempting to access the contents in the exported file = same results.,

Posted to MB Topic: Paradox Tables

{Too Long!}

Posted to MB Topic: Paradox Tables

What does this error mean? How do I fix? It happens only to a new node I just put on the network. using win XP pro.  paradox 11.0.0.3, Error comes up right after clicking  the Paradox icon on the desktop. I click OK on the error and paradox still opens and seems to run OK!? any suggestions???  I have search the net and this forum but could not find anything. The full error is: Access violation at address 0055a83c in module 'PXSRV32.DLL'.  Read of address 049800000., thanks scott,

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

{Too Long!}

Posted to MB Topic: ObjectPAL

I am using PDX 11 with Hot Fix 1.  If I try to restructure a table, I receive a "Unexpected general protection violation" error when trying edit the "table lookup" function. Also I am unable to save Desktop Settings once machine is shut down.  They are saved if app is closed and reopened. Can anyone help. Regards, Dick Hill

Posted to MB Topic: Paradox Tables

I'm using a Corel Webserver control to capture data from a web page.  Works great.  After the posting, I want to send an email to a staff member that the data has been posted. I have the following code: m.logon("","" ), , ,     m.addAddress("products@consoftonline.com"), ,     m.setSubject("A Patient from the Portal"),     m.setMessage("Please check Patient: " + theName + " " + theAppointmentDate),     ,     m.send()  The problem is that the Logondlg box appears each time .  It's supposed to send the message automatically.  What am I missing?

Posted to MB Topic: Paradox Forms

I have been working on a query by form for a long time and have it working, sort of. It's too long (but I can't find an alternative for my use, and I don't think that's the issue) It works well enough with a few issues ONCE. running it a second time brings up the error  - An error was triggered in the execute qbe method on an object of query type, which generally  indicates missing or double pipe in the query script, but it has not changed. I am thinking the query is still open? Is there a way to assure it is closed at the beginning of the script. Here is the entire script. I don't want to upload it to take up too much space. http://www.chefsprofessional.com/cpbworks.txt,

Posted to MB Topic: Paradox Forms

Query by form script gives "out of memory " error at a set point . Large query. Have tried resetting shared memory but not memory location in BDE. Any ideas here what could be done? ,

Posted to MB Topic: QBE & SQL

We have the need to use web services and need help finding out how to accomplish this. WinXP - Pdox 10 For starters, can we use Paradox 10 to communicate via HTTP using SOAP and WSDL, or do we need to harness the capabilities of a third party application to handle this for us? We are not sure how to communicate with web servers to authenticate, and then ultimately send an .xml request file and then receive a response as well. Any guidance on how to do this or what applications to use for this would be appreciated. We've just downloaded SOAPui and are playing with that. Thanks, Shawn

Posted to MB Topic: ObjectPAL

Howdy All, My HeadAche is that I CANNOT locate a (Genuine) Copy of Paradox V9.0!! If anyone can Help With a Genuine Copy, I would be happy to Puchase Same (Manuals Incld) for a reasonable Price. Trying to find the above is like trying to find a needle in a haystack.. NOT that I'm overly SURPRISED. ANYWAY if U Can Help, Please email me direct on gbash@optusnet.com.au with Words Paradox v9 included in the Subject!! thks PSS: Since Posting  2 day agao I HAVE NOW acquired Corel Paradox 9.0 - TKS ANYWAY!

Posted to MB Topic: Paradox Third Party Software, DLLs, and Controls

I have a chart in Paradox (using Paradox 8, but have 10 and 11) that is a a 2 D summary and it shows exactly what I want - but there are 8 groups (series) and the markers are too big and it clutters up the chart.  In the design mode I can change the first 4, but for the life of me I can't figure out how to change markers 5 through 8. I tried using self.series.marker.size=MarkerSize6 in the Open for the chart.  That can change the first series, but I have no idea how to move to the other series. The Object Explorer shows only one series. Can anyone help?

Posted to MB Topic: Paradox Graphs & Charts

I have a system I developed using Borland C++ and Paradox as the database. I started this project running on Windows 98 and finally through XP with NO problems. When Vista came out the system would no longer work, BDE problems. I would like to know if anyone out there has a fix for the BDE when running Windows 7. I have it working but I get an error from time to time, "Failed to initalize BDE". Also when using a NetWork drive I have to turn the User account control off. My system runs better and faster on Windows XP but the world is going to Win 7 and I have to keep up. I have 370+ users of my software and I have issues with the way the system works in Windows 7. George Cook Shooting Sports Software  LLC

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

This is just a helpful hint - because I've been fighting this "problem" for a couple of weeks and finally found the resolution. The problem: whenever I would type ctrl-space in Paradox to do a table lookup a computer voice would say "there is no text" and do nothing else. The resolution turned out to be a Yahoo Widget that I use - Month Calendar by Harry Whitfield. Under "Widget Preferences" there is a Speech tab - change the "Speak Memo Hotkey" to something else (or change it to none).

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

{Too Long!}

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

Hi All I'm Using Paradox V7 under XP MCE I'm trying to intercept the "Press Ctl + SpaceBar" Status Message When an Invalid LookUp occurs, That is the User Types in an Invalid value and you can't depart from the field in a Multi-Table (Frames x4) Form, Field Name in 1st Table frame is "Location". The TABLE LookUp works FINE, But When a New "Location's" value need's to be added to the LookUp, I want to respond to it... IF THATS Possible??? If so How??? While I'm at it, the thread on "conditionally coloring rows in a tableframe" looks great but like Jim I'm hoping for a better solution!!! Mike - Thanks for making the code available from Paradox 9 book!!! Hope I can get a few answer's with both the above!!

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

Hi all, I just migrated an application I wrote before Y2K in Pdox 8 to Win7 and Pdox 11.  It went pretty smoothly. The issue is that with the equipment and staff I had at the time, screen resolution set at 800 x 600 seemed reasonable.  It's still fine to have the screen full of my app, but with monitors and other apps running, it is a joke to try and view a web page on the machine. My app is extensive and I'm hoping there is a method to do a universal object resize or a realitive method on all objects to expand the form size as desired and have all objects resize accordingly.  I have an uncomfortable feeling, but I'm hoping someone has an idea, because I'm fresh out of them.  Many thanks for feedback. 

Posted to MB Topic: Paradox Forms

{Too Long!}

Posted to MB Topic: ObjectPAL

Can anybody explain to me the syntax to use ReportPrintInfo - the syntax # 3 version that uses an array? I need to set the PrintToFile option to create a postscript file and it seems to only be available using the array.

Posted to MB Topic: ObjectPAL

{Too Long!}

Posted to MB Topic: Paradox Runtime & Distribution

I have downloaded the StruList Utility, but the Installation documentation is missing.. do you still have that?   The Strulist is experciencing problems and I am sure it is my mistake in installing it via Alias Manager.. I think?

Posted to MB Topic: Paradox Tables

{Too Long!}

Posted to MB Topic: Paradox Runtime & Distribution

{Too Long!}

Posted to MB Topic: Paradox Runtime & Distribution

While working with an OLE Auto object I often receive a "Server Busy" error. , Typically when waiting for a piece of information from the other , application.  Is there a way to extend the timeout to prevent receiving this , message as often?, , The full message is:, "Server Busy: This action cannot be completed because the other program is , busy. Choose 'Switch To' to activate the busy program and correct the , problem." Thanks, Beth,

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

I recently changed one of my computers. It is an HP running XP.  We have been running a particular paradox database for years and started using it on this new computer.  When I go to run a report as soon as I open it paradox changes some of the fields to a date field or sometimes another field.  I go back change the form, save it, it may work one or two times then I might change a filter and presto fields change on their own.  If I run the program on another computer it does not happen.  I have uninstalled paradox twice as well as wordperfect.  even reinstalled word perfect x3 and then upgraded to x4 to see if that had an affect to no avail. I am stumped.  Anyone have any suggestions?

Posted to MB Topic: Paradox Reports

Does anybody remember a version of Paradox that was shipped with a synchronisation utility?  The utily was a third party app that would sync a local and remote database so changes in data on one would updated to the other.  I am developing an application that would be deployed on laptops and these would sync with a central database as and when convienient - maybe someone knows a better way to to do this?  We have abandoned terminal services, i haven't even attempted a paraodx web app...

Posted to MB Topic: Paradox Third Party Software, DLLs, and Controls

Hi guys I've got tons of questions regarding paradox with so little time to figure things out. I hope you can help me as soon as possible.  I wrote SQL in paradox to show the results in an Answer table. Let's say I run my query and get a total of 100 records. Now I only want to show 1/4 of it so I need to show 25 records only in the Answer table. Does anyone knows how to do this? *Reminder: the total number of records is dynamic and sometimes I need to divide the total into 5, 4, 3, 2 and the like.. Thanks in advance!

Posted to MB Topic: QBE & SQL

I'm a noob with paradox and I want to know if it is possible to set a primary key to an existing table using the SQL in paradox? I want to set 2 fields as primary keys. I tried doing it via table resturcture but it keeps giving me the error "Record size is too big for table". Help please thanks!

Posted to MB Topic: QBE & SQL

I'm running XP-pro and using Pdox 7 - 32 bit. When I am debugging my programs, using breakpoints, I found that the Debug button bar disappeared. Anybody know how to force the button bar back into existance and to prevent it from going bye bye?

Posted to MB Topic: Paradox Forms

{Too Long!}

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

... the datamodel won't recognize the primary key index. I am using an alias to point oracle., I open a form and it fails with index not valid. go to design mode, open datamodel, click a table, click link, error no key for this field. go to tools, utilities, restructure table, change to the oracle alias, click the table, it opens showing an index. close, go back to datamodel, now the table can be accessed via link. Any idea why the forms datamodel doesn't pick up the index, when paradox via the alias obviously can see the index? If going to info structure before restructure no index to be found, but after going to restructure it can also be found in info structure. Closing paradox, reopen, index gone again. If I go through restructure of all the tables in the datamodel, then the form is runnable. What gives? is it the BDE that obstructs, the form, anyone ever seen this? I would love some suggestions to what to look for, I am gettin rather desperate ... cheers, Lars,

Posted to MB Topic: Paradox Forms