var
  MyArray Array[4] String ;Fixed size array.
  i LongInt
endVar
MyArray[1] = "Mike"
MyArray[2] = "Lisa"
MyArray[3] = "Felicia"
MyArray[4] = "Nathan"
if MyArray.size() > 0 then
  for i from 1 to MyArray.size()
    msgInfo("", MyArray[i])
  endFor
endIf

No 64-bit version of Paradox for Windows. Just the current 32-bit version and the older 16-bit version. However, 64-bit versions of Windows can run 32-bit programs very well. If you're running Vista 64-bit, you may wish to stick with Paradox 9 but Vista isn't a good OS for older programs. Interestingly enough, Paradox 9, 10, and 11 run fairly well on Windows 7 which means you can keep using your Paradox applications long into the future (just skip Vista).

No, Paradox X4 (version 14) is Paradox 11 with SP2 applied (build 11.0.0.411). There is no version 12, 13, or 14. In fact, no new features since version 10. Version 11 does have some significant bug fixes though and SP2 has even more fixes. Also, there are lots of rumors that Corel will release a patch for Paradox 11 soon that will address the Vista problems many users are struggling with.

Answer from Corel...

Paradox was not updated from Paradox 10. It was given a new look, but the functionality remains mainly the same. Paradox 11 is available in the WordPerfect Office Professional version and can be purchased through Corel's online store or by calling us [Corel].  Paradox is also available as a standalone if you already own WordPerfect Office, and is [available] through our licensing program.  Within North America, please call 1-800-772-6735, Corel's Customer Support Services, to purchase the Paradox upgrade. We are open from Monday - Friday, 9:00 am - 7:00 pm E.S.T. and would be happy to serve you. For customers outside of North America, please visit www.corel.com/contact to locate a Corel Customer Support Services Center nearest you.

[answered by Mike Prestwood] Paradox version 11 shipped with WPO X2 and Paradox 11 with SP2 ships with WPO X3 and WPO X4. Paradox 11 is essentially the same as Paradox 10 with NO NEW features (minor defects and compatibility issues were resolved). There is no Paradox 12, 13, or 14. Currently Corel states that Paradox is in maintenance mode (meaning no new features are planned).

As for your Paradox 9 forms, you can simply resave them and/or redeliver them in the new version. If you used the Application Framework in 9, it's not in 10 nor 11 so you have some work to do.

Paradox 9, 10, and 11 run well on Windows 7, so skip Vista. Paradox 9 does run on Vista (not well, but you can do it) and Paradox 10 and above do run but there are some issues to keep an eye out here for detailed notes. If you have an earlier version, it will run on Vista but we do recommend you upgrade to Paradox 9 or Paradox Runtime. Refer to the links on this FAQ for complete and detailed instructions.

All the latest versions of Paradox run very well on Windows 7 including Paradox 9, 10, and 11. We are currently recommended to our clients that they skip Vista.

Using Paradox 9 on XP with CorelDraw or any other programs is fine. No problem there. Not sure what the issue is though. You might want to try starting Paradox with a clear desktop using the -c command line option. You can search the help file for command line options for usage. If that isn't the problem, then you must have a bad installation of Paradox (try reinstalling) or some other program is causing it to crash (doubtfull with XP memory management).

Solution was to apply the latest BDE patch, all works as it should.

Paradox 11 installs a registry cleaner and that is the culprit. The quick fix is to delete the PdxRegCl.exe file in the Paradox folder. For a more complete "cleanup", delete the PdxRegCl.ini file and any PdxRegCl registry entries you find.

What I recommend for our clients is to make sure no one is using the tables and then copy the entire folder. To make sure no-one is using the tables, check for .LCK lock files. If they exist, try deleting them. If you can delete them, then they were left over from an abandoned BDE session. Next, rename the folder to lock out users for the duration of the copy. Copy the folder, then rename the folder back.

To copy live tables, I suggest you write an application in Paradox, Delphi, etc. that uses the BDE copy table code. It's safe, effective, and you can build in error checking.

No. Actually Paradox 7 "table structure" is the latest very flexible table structure. The only table structures are 1...3.x, 4.x, 5, and 7. No such thing as a Paradox 9 or 10 or 13 table structure.

var
 FullName String
   Age SmallInt
endVar

FullName = "Randy Spitz"
Age = 42

All of the following are equivalent:

msgInfo "", "Hello"

MsgInfo "", "Hello"

msginfo "", "Hello"

MSGINFO "", "Hello"

Variables are not case sensitive.

Var
 FullName String
endVar

fullname="Mike Prestwood"
msgInfo("", fullNAME)

method

endMethod

var

endVar

if

endIf

switch

endSwitch

try

endTry

;Single line comment.
 
{

Multiple line

comment.

}

'Does ObjectPAL evaluate the math correctly? No!

If .1 + .1 + .1 = .3 Then
  msgInfo("", "correct")
Else
  msgInfo("", "not correct")
endIf

const
  kFeetToMeter = Number(3.2808)
  kMeterToFeet = Number(.3048)
  kName = String("Mike")

  kCA = "California"     ;String inferred.
endConst

The following code snippet adds a record to a given TCursor with FullName and Created fields:

tc.edit()

tc.InsertRecord()

tc.FullName = "Barack Obama"

tc.Created  = today()

tc.postRecord

var
 s String
endVar

;s = ""  ;Uncomment to test 2nd case.

if isBlank(s) or not isAssigned(s) Then
 msgInfo("", "empty string")
endIf

msgInfo("", "Hello1")
msgInfo("", "Hello2")
msgInfo("", "Hello3")
 
;The following single line of code also works.
msgInfo("", "Hello4")   msgInfo("", "Hello5")
 
;Two or more works too:
msgInfo
  ("", "Hello6")

'Does ObjectPAL evaluate the math correctly? No!

If (.1 + .1 + .1) = .3 Then
  msgInfo("", "Correct")
Else
  msgInfo("", "Not correct")
EndIf

'Switch statement example.
switch
  case x = "Nate": MsgInfo("", "Hi Nate")
  case x = "Felicia": MsgInfo("", "Hi Felly") 

  otherwise: MsgInfo("", "Who are you?")

endSwitch

msgInfo("", "Hello")

msgInfo("", "Hello \"Mike\".")

;Does ObjectPAL evaluate this simple

;floating point math correctly? No!

If (.1 + .1 + .1) = .3 Then
 msgInfo("", "Correct")
Else
 msgInfo("", "Not correct")
EndIf

;Given expressions a, b, c, and d:

if Not (a and b) and (c or d) then

  ;Do something.

endIf

var
  FirstName  String
  LastName  String
endVar

FirstName  = "Mike"
LastName  = "Prestwood"

msgInfo("", "Full name: " + FirstName + " " + LastName)

var
    FullName String
    Age SmallInt
    Weight Number

endVar

FullName = "Mike Prestwood"
Age = 32
Weight =154.4

msgInfo("", FullName + ", age=" + String(Age) 

             + ", weight=" + String(Weight))

;Button :: pushButton
method pushButton(var eventInfo Event)
var
	myDynArray   DynArray[] String
endVar

myDynArray["Last_Name"] = "Spitz"
myDynArray["First_Name"] = "Randy"

myDynArray.view()
endMethod

var
  myDynArray   DynArray[] String
endVar

myDynArray["Last_Name"] = "Spitz"
myDynArray["First_Name"] = "Randy"

myDynArray.view()

var
  i SmallInt
endVar

try
  i = 0
  i = 1/i
onFail
  msgInfo("", "You cannot divide by zero.")
endTry

The following example loads, filters, and runs a report.

var
 r Report
 dyn DynArray[] String
endVar

dyn["Name"] = "SCUBA Heaven"
Customer.setGenFilter(dyn)

r.load(":Sample:customer")
r.Customer.setGenFilter(dyn)

r.run()

You can also drop a flter with:

r.Customer.dropGenFilter()

var
  tc TCursor
endVar

tc.open("Customer.db") 
  

if tc.locate("Name", "Proffessional Divers, Ltd.") then 
  tc.edit()
  tc.Name = "Professional Divers, Ltd." 
  msgInfo("Success", "Corrected spelling error.") 
endIf 
  

tc.endEdit()

method cmCode(s String) ;...s is by value.
endMethod
  

method pushButton(var eventInfo Event)

  ;...eventInfo is by reference.
endMethod

method cmCode(Const s String)

  ;...s is a constant read-only parameter.
endMethod
   
proc cpNever() String
  return "Never duplicate a line of code!"
endProc

The following snippet uses the active keyword to move to the second to last record of the table attached to the UIObject that currently has focus:

active.end()

active.priorRecord()

You can also use the self keyword to refer to the UIObject your code is attached to.

method pushButton(var eventInfo Event)
  msgInfo("", self.Name)
endMethod

var
 �LeftString String;

  NameVar String;
endVar

NameVar = "Prestwood"

LeftString = NameVar.subStr(1, 3)

msgInfo("", LeftString)

method openWorkBook(var Excel OleAuto, fileName string) logical
var
 StarDesktop,StarOffice  OLEAuto
 oooDoc,scr,lists,list,zak OleAuto
 massiv AnyType
 fs filesystem
 put,s string
 dlin,k,i smallInt
endVar

ShName.BLANK()
ShiNDEX.BLANK()

try
  scr.open("MSScriptControl.ScriptControl")
 scr.language = "javascript";
 scr.eval("aaa=new Array()")
 massiv = scr.eval("aaa")
 scr.AddCode("function SetItem(ind,val){massiv[ind]=val}")

 StarOffice.Open("com.sun.star.ServiceManager")
 StarDesktop=StarOffice.createInstance("com.sun.star.frame.Desktop")

 dlin=fileName.size()
 
 put=""
 k=1
 i=1

 while i<>dlin
  s=fileName.subStr(i,1)

  if ansiCode(s)=92 then 

   put=put+"/"+fileName.subStr(k,i-k)
   k=i+1
  endIf 

  i=i+1
 endWhile

 put=put+"/"+fileName.subStr(k,i-k+1)

 if put.subStr(put.size()-3,4)=".xls" then
 else
  put=put+".xls"
 endif

 Excel=StarDesktop.LoadComponentFromURL("file://"+put,"_blank", 0,massiv)

 return True
onFail errorClear() return False
endTry
endMethod

QBE Expression...

mIkE.., @@@@

Corel Paradox 9, 10, and 11+ can import Excel spreadsheets up through Excel 97 so you need to save the spreadsheet as an Excel 97 spreadsheet. Then you can import it in Paradox using either the interactive File | Import option or with ObjectPAL's importSpreadsheet procedure.

If you have trouble with then Excel 97 file format (and you may depending on the version of Excel you are using), try saving the file as an Excel 4 file format. The worst case scenario, is that you may have to save the file as a dBASE table file format (.DBF) which you can directly use in Paradox and even copy it to a Paradox table (.DB).

Yes, Paradox 10 and 11 support .PNG graphics. For example, you can insert a .PNG using Edit | Paste From. However, Paradox 9 and earlier do not.

Note: All images stored in a Graphic field in Paradox tables are stored as uncompressed BMP images. This FAQ is about Paradox for Windows' ability to paste or import .PNG images into the .BMP formatted Graphic field type. For earlier versions of Paradox, you have to first convert the image.

var

	app Application

endVar

app.setTitle("My Custom Application")

method sayHello(var pName String)
 msgInfo("", "Hello " + pName)
endMethod
 

method add(p1 Number, p2 Number) Number
 Return p1 + p2
endMethod

Uses Tapi32

  tapiRequestMakeCall(sNumber CPTR, sAppName CPTR, 

    sLogName CPTR, sComment CPTR) CLONG

endUses

sqlQuery =
SQL
;execute proc here
ENDSQL

if not dbSQL.executeSQL(sqlQuery, tcAnswer) then
  errorShow()
endIf

var
 oleOutlook oleAuto
 oleAppointment oleAuto
endVar

;The open will fail if your AntiVirus program is blocking access.
oleOutlook.open("Outlook.Application")

oleAppointment=oleOutlook.CreateItem(1)

oleAppointment.Subject = "Test From ObjectPAL"
oleAppointment.Body="You can add appointments from ObjectPAL."

oleAppointment.Start=dateTime() ;Adds an appointment now.

oleAppointment.Duration=60
oleAppointment.ReminderSet=True
oleAppointment.Location="My Office"
oleAppointment.BusyStatus = 2

oleAppointment.save()

Yes, interactive support was added with Paradox 9 SP1 and ObjectPAL support was added with Paradox 10. Here's a good article for Paradox and TWAIN:

http://www.techtricks.com/paradox/twain/part1.php

With DLLs you are limited to the DLL Uses types of CWORD, CLONG, CDOUBLE, CLONGDOUBLE, CPTR, and CHANDLE. All other parameter types must be mapped to one of these fundamental data types. Because logicals are really just null, 0, or 1, you can use a CWORD which maps to ObjectPAL's SmallInt data type (an integer).

We like Paradox's feature set too but it's not the right tool for every situation. For very large transactions and storage, we prefer a true SQL server over ALL file-based databases including over Paradox. Although we judge and discuss the viability of toolsets for each project, we do have standards we steer our clients toward. For example, we steer our Paradox-oriented large transaction/large storage needs clients toward SQL Server 2005 with either VS.Net as a front-end or Delphi (for a true native code solution).

No. To deploy your Paradox application, you can use either the full version of Paradox or the runtime version. The runtime version is almost as big as the full version but it's been free since version 9. If you deploy using the full version of Paradox, you need a license for each user. You can order a multi-user license from Corel at a deep discount.

If you really need a true Windows executable, you'll have to rewrite the application in another development tool like Delphi or Visual Studio.Net. If you need help with this you can contact a company like Prestwood Software who has experts in Paradox and in the target development tool.

Ok, that's a bit of a silly question, but yes it does. It may not appear to run but if you tell Windows not to close on exit, it works just fine.

1. Right click on CPUTEST.EXE, select Properties.
2. From the Program tab, uncheck Close on exit.

By the way, my dual core 2 GHz CPU passed.

Yes, but you must use the compatibility mode.

No. 16-bit programs are not supported on 64-bit versions of Windows Vista. Although Vista 64bit comes with the Command Prompt for executing DOS commands and creating scripts, it does not run DOS programs.

In Windows 7, DOS is gone completely in both the 32bit and 64bit editions. You still have the command prompt.

Recommendation: Download a DOS emulator such as DOSBox.