Corel Paradox / ObjectPAL Coding New Activity

How I can connect to a MS SQL database 2008 with ODBC? is possible through a ObjectPAL?

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 installed Paradox 11 on my PC after many years of using Paradox 9. Everything working fine exept when I try to print anything at all. I get a "General protection" error message and the program crashes. Has any one had any experience and know of any fix to this problem?

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

Please could anyone tell me if there is a way to change the splash screen at the startup of Paradox 11. I did it V9 by editing the pxres09.dll file but cant find a similar file to edit in V11. I have seen one post on the buliten board about splash screen on Runtime V9 but this didn't work on Full Paradox V11... Any help or pointers greatly apreciated

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

Does anyone have paradox 11 runtime running on a Windows 2012 Terminal Server? I have a 2008 R2 TS server running paradox 11 RT fine, but I haven't seen a 2012 TS server as of yet. Thanks

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

I have a terminal server installation that has been running paradox 11 runtime.  All users on this installation access paradox through the terminal server. After running fine for the initial four months, I recently ran into a curuption problem that looked a lot like the old Oplocks of NT days or Terminal User settings of Win TS server 2003. I could watch two users viewing the same table, the edits of user A would not appear for user B after user A committed the edits and the table would get immediately currupted.  It looked to me that both users were holding the tables in memory and not committing changes to disk until the user left the table.  A single user could function normally in the application without curruption.  I tried a lot of things on that server to try to fix it including oplocks and terminal user reg edits, but I couldn't correct the problem. I recovered the entire server from a month old backup, prior to the start of the problem, install...

Posted to MB Topic: Paradox Runtime & Distribution

{Too Long}

Posted to MB Topic: ObjectPAL

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!

Posted to MB Topic: ObjectPAL

Hello I recently started working for a company that has accquired Computers and servers from another company. they hired me to be the tech guy and setup all the computers and servers for the company. they have Paradox 11 and runing on xp mechines, i have my laptop with windows 7 and i want to be able to have it up and runing on mine first and test it out. i have the data file from the server for the paradox.it has tables forms and stuff already. as i installed paradox on my laptop i get an error "Cannot open:PRIV:FORM8130.DB.,TABKE DOES NOT EXIT. it point to the location and Asks If i want to Replace Data Model. PLease Help me Get this up and Running As im new to this paradox thing. Thanks

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

I'd like to be able to control Chart Series line properties in code.  Specifically, I am trying to control LineStyle. Chartobject.Series.Line.LineStyle = NoLine works, but it only controls the property of the first series.  I have tried Series1 and a variety of other names, but I haven't been able to find a syntax that works.  I know there is one, I have used it in the distant past, but I don't remember the syntax and I don't find it in the help. SS

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.

Hi, New to this thread....just happy to see that I'm not the only one still using Paradox! I can't seem to get the sendkeys function in objectpal (pdx 11) to work with Vista.  Does anyone have a solution? Thanks. Todd

Posted to MB Topic: ObjectPAL

I moved a paradox 7 app from one working TS Win2003 server to another TS Win2003.  On the new server, it acted as if Oplocks was enabled, regardless of registry oplock settings.  The settings I am using are below along with a more complete descripion of the new server setup. Does anyone know of other Oplock related registry or TS settings I could try? When I have multiple users accessing the same table, users do not see each other's edits.  With User A and B in the table, User A edits and closes the table, B doesn't see A's edits, makes new conflicting edits closes the table and wipes out A's Edits.  I get the same result if install and run PDOXRT11. I got this installation working by moving the data from the TS D:\ partition to another fileserver on the same network.  My assumption is the TS server is not handling oplocks related function as intended, but the file server is. The new server: IBM XSeries_335, Win 2003 SP2 setup for a TS role, only three ...

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

I dual boot WinXP Pro X32 and Windows 7 X64 Pro on separate drives and run Paradox 11 from WP Office X3 on both.  I mostly use XP and  there are no problems with Pdox after those updates but when I went to use it under Windows 7 today the Project Viewer showed no files in the working directory. Until now there was no problem with the Windows 7 installation.  I uninstalled and reinstalled Pdox and then tried to set Project Viewer to the proper working directory and it crashes.  I've tried this several times.  If I open a table with Explorer Pdox will start and open it but if I try Project Viewer it crashes.  I went to check the BDE settings but I can't seem to find BDE in the control panel or anywhere else in Windows 7.

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

I am encountering an error when I try to post table data using a tcursor in ObjectPAL (Paradox 8.0).  System error reads: "An error was triggered in the 'postrecord' method on an object of tcursor type" --> "This record is not locked so the operation is invalid."  I'm not sure how the record would be unlocked. The main code is attached to a pushbutton event. At the top, I open a tcursor to a specific table (e.g., tc1.open(ATableName)).  I use some qlocates to search for and test certain dates and values.  Then I tc.close(). No problem. A little further down, I call a method that's also attached to the pushbutton object.  Inside the method, I open a differently-named tcursor to that same table (e.g., tc2.open(ATableName)).  I do some qlocates and later post some data to several different records in the table.    The data posts without a problem.  At the end of the method, I make sure to endedit() and close(). A...

Posted to MB Topic: ObjectPAL

#Formdata1  Var FD1_uiO    uiObject FD1_tC      tCursor #Formdata1  Arrive var a_logl       logical s_str         string n_lInt       longInt endVar   if (eventInfo.isPreFilter())  then      ;;//for each object (i.e. box, container, field)      if (active.class  = "Field")  then        n_lInt  =  FD1_tC.RecNo()        n_lInt.view ("Viewing RecNo...")      ;;  ALWAYS DISPLAYS the number one "1"                                              &nbs...

Posted to MB Topic: ObjectPAL

hello, im using Microsoft XML Core Services (MSXML) to parse and create XML-documents. when i call certain methods of the oleAuto-objects, Paradox crashes when reaching the endMethod statement, (the code is in the pushButton event of a button). That brought me to the conclusion, that the problem could be the "releasing" of oleAuto-variables. so i´ve put the variable-declarations to the form. if i debug the code, the, GPF doesn´t appear at the endMethod of the Button anymore, but still occurs when exiting the program. So i might be right that the problem is where it comes to release variables.  Explicit close() orders of the OLE-objects do not solve the problem. Anyone got an idea? I really need that MSXML to work :-( Other MSXML-Methods work very well, like searching XML-files via XPath for specific elements etc. . here comes the code and the xml-files., the code validates the xml-file against the xml-schemafile, (code and xml-files are from the microsoft ...

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

I have used posts to this board in the past to resolve this issue, but recently installed WPOX5 on Windows7 machine and tricks that worked in the past on Windows XP do not appear to work in Windows7. I have cleared all of the registry entries of PdxRegCl and have disabled the Registry Cleaner in the start up of msConfig, but next time I start Paradox, Windows recongifures it and all of the registry entires reappear and the RegistryCleaner is back in the startUp. I cannot retain the working directory that was set in the last session and all of the established ALIASES are lost. Any assistance would be appreciated.  

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

I have for quite some time been unable to access the "Import, Export and Table Repair" utilities on the paradox menus.  Endless uninstall, reinstall routines; checks for existence of files such as Tutility.exe, have failed to resolve the irritation of not being able to use these functions. Recently, I installed paradox on a laptop.  It is the same operating system  as the desktop, (XP)  Lo and behold the program worked fully, and well. ( But still not on the desktop) I notice that even when I have done uninstalls, cleans and apparently everything I can find  on my drives that relate to Paradox, when I reinstall, it still knows all the aliases that I had set up previously. Obviously, there are some files deeply embeded in my hard drives somewhere, that retain information about paradox. My question is, "where are they?" "what are they?" and "Might they contain corrupted files that could cause the problems?"  Interestingly, when I choose 'Import' from the...

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

Hi, I have recently installed Pdx 9 and 10 on a Win7 networked machine at work. Mostly no problems once I installed the win32hlp except with the project viewer which does not give me the right click edit option for forms, reports etc... Perhaps I am missing something simple? Best, Paul.

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

I'm trying to select records based on date; if I do the following it works Aux = "Citas"

dbTable =  ":Citas:" + Aux TempFile = ":Citas:##Temp" + Aux SQLVar = SQL SELECT * FROM ~dbTable WHERE

(FechaCita < '01/18/2013') endSQL

SQLVar.ExecuteSQL (PacData, TempFile) but if I try to use a variable for the date comparison it gives me an error (Type mismatch in expression):    FechaMaxS = "18/01/2013" SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < ~FechaMaxS ) endSQL I also tried the following but it gives the same error: SQLVar = SQL SELECT * FROM ~dbTable WHERE (FechaCita < CAST(~FechaMaxS AS DATE) ) endSQL Could anyone tell me the correct syntax?  Thanks

Posted to MB Topic: Paradox Forms

I am currently using pdox8 and woulld like to know the best way to ompact a table after deletes. I tried tblvar.compact(), this retruned an error. What is the best way to do it?

Posted to MB Topic: ObjectPAL

#Formdata1  Var   FD1_uiO    uiObject   FD1_tC      tCursor #Formdata1  Arrive var   a_logl       logical   s_str         string   n_lInt       longInt endVar   if (eventInfo.isPreFilter())  then      ;;//for each object (i.e. box, mro, container, field)      if (active.class  = "Field")  then          s_str  = self.TableName          a_logl = FD1_tC.open(FD1_uiO)          arriveFieldObject()      endIf  else      ;;//for Form only      s_str  = self.name      a_logl = FD1_uiO.attach(s_str)      s_st...

Posted to MB Topic: ObjectPAL

Can someone help me understand the mechanics of using OLE Auto. I am trying to understand how I find the methods for each application that I wish to communicate with. Ther are several enumeration methods I can use in Paradox that give me information about the available servers. I would like to be able to understand how i can manipulate Excel. Where do I find how to initiate the communication. After initiating where do I find documentation to open a file, go to a cell, etc. I have used OLE Auto only in a very simple way and would like to unsderstand it better.

Posted to MB Topic: ObjectPAL

I borrowed/modified coding from one of Mike's samples. When I run the query the answer file is created without returning the joined field and without returning any data. The query works fine if I am only using one table. Is there a way to joint the two tables? Coding is as follows: method pushButton(var eventInfo Event),  var,   r Report,   q Query,   s String,  endVar s = WORK_ORDER_NUMBER.value q = Query ANSWER: :PRIV:ANSWER.DB FLEET SERVICE.DB     | WORK ORDER NUMBER |  MODEL  |  UNIT  | LTD HOURS | SERVICEMAN |,                               | _JOIN1,Check  ~s        |   CHECK |  CHECK | CHECK       | CHECK       &nbs...

Posted to MB Topic: Paradox Forms