Under certain circumstances, using SQL to update a column which has a secondary index, all records are not updated.

Under certain circumstances, there appears to be a problem with the 'Group by' statement in the BDE.

A table with an AutoIncrement field as primary key. The field has a Minimum valcheck defined. You add a case-sensitive secondary index. The minimun valcheck is lost. When you try to add it, you get an error message: [Invalid array of validity check descriptors] , when the Save button is pressed.

A lookup table defined for a A1 field. If the field contains both upper and lower case letters, only lower case are accepted in the master table.

Table language: PDOX ANSI Swedfin.

If a table contains an alpha primary key, and the values contains both upper-case and lower-case letters, the table may get out of order when linked as a detail table in a 1-M link in a form. The problem is related to a couple of international language drivers, e g PDOX ANSI Intl850.

You cannot remove more than one valcheck at a time. If you do, you'll get a GPV and eventually you have to use Alt+Ctrl+Del to get out of Paradox.

Running SQL on a dBase table, you cannot cast(value as Integer) even though the answer table is a Paradox table.

Currently, the native BDE Access driver only uses the security database that is specified in the registry

a) Performing a Select with two Where criteria between multiple Paradox and dBASE tables produces a corrupt Paradox answer set (there are '*' in the Numeric field but apparently no displayable data). However, if another Where criteria is added the query will work correctly.

b) If a select query is run on a table with a secondary index on a single field and the where clause specifies that same field in a like clause, the resultant query returns data case-insensitive. If the secondary index is removed, the data comes back case-sensitive.

c) Performing a Select which includes a subquery on the ON clause with an OUTER JOIN should produce all records specified by the outer join table, but only those records which match the subquery are returned.

d) Executing an Update statement on a Paradox table where '1' is being subtracted in a datetime field does not subtract '1', but rather adds '1'.

e) Executing an ALTER TABLE statement on a Paradox table with a password, adds or deletes the field but also removes all auxilary and master passwords from the table.

f) Select statement missing table's file extension fails with "Invalid Field Name" error.

g) Attempting to open more than 512 dBASE tables results in error: "BDE error $000E".

h) Currently, you cannot place a string into a Paradox memo BLOb. If a paradox table has the following structure
Field1 Longint
Field2 Memo

and you do a SQL Insert statment like:
INSERT INTO TABLE.DB VALUES(100, "HELLO")

"HELLO" will not be in the memo field. No error is returned from the BDE.

The Legend Box in the chart does not translate national characters from Ascii to Ansi.

During fixed length text files import, in some cases the last record is lost.

The wildcards used in a SQL statement are % and _. They correspond to the Paradox .. and @.

The behaviour of Like '%' depends on whether the column is indexed or not, eg CustomerName like 'A%E' retrieves names starting with A and ending with E when CustomerName has no index, but all names starting with A when the column is indexed.

Show SQL generates incorrect SQL code when alias is based on Microsoft Paradox ODBC driver

Adding lots of records to table with a memo field fails on record #674.

Exporting a table to Lotus - wk1 format produces a GPV when BDE 5.0 is used.

Bde 5.10
Getting error "Unexpected: General Protection Violation. Press 'OK', then save your documents and exit Paradox. If the problem persists: press 'Abort' to terminate Paradox." when trying to create a query based on a wide remote table or open a tableview of a wide remote table.
MS SQLServer 7 and 2000 - ODBC connection

Bde 5.11
This updated BDE IDSQL32.DLL fixes the following problems:

- Attempting to null out a group picture (Paradox graphic field) gives the error "Capability Not Supported".

- SQL UPDATE against field in secondary index on table with autoinc field causes autoinc field to get new value.

- Attempting to update a memo field with a WHERE clause on a non-key field, results in "Capability not supported" error message and the record is not updated.

Autoincrement fields starts to increment itself when a Local SQL query is run. This error is new for the 5.10 BDE, it did not exist in 5.01. BDE 5.01 is the one delivered with Paradox 9.

Paradox and sometimes even Win95 will hang up completely when you change printer to Generic.

You get a GPV when you press the OK or the Cancel button in the Developer Preferences dialog.

In the ObjectTree, you can rename objects by selecting and clicking the same way as in Explorer. This technique cannot be used with listobjects belonging to a dropdown field.

When you try to select an object in the ObjectTree, you often end up on a different object than the one you clicked. This happens if the current object is not visible in the ObjectTree window, that is you have scrolled with the scroll bars to find the object to select.

Your application contains a non modal dialogbox, e g a custom toolbar (not the one introduced with Paradox 7, but the one you did write in Paradox 5). This dialog is opened. From another form, you call a modal dialog with a wait(). The non modal dialog will freeze when the modal dialog is closed. You cannot close the non modal dialog in any other way than Window | Close All.

A msgInfo()-dialog called from one of the NWC-objects' events, locks the keyboard and the mouse. You can't move from the NWC-object to another object using the Tab key or using the mouse.

I cannot get the ReportPrint Info to print more than one copy when parameter MakeCopies=true.

If you want to return more than one file, you cannot change directory in the fileBrowser dialog. You will only get the filenames in the array. The selected directory is not returned. fbi.path and fbi.alias does not contain the selected directory.

Fixed in fileBrowserEx() in Paradox 8.

FileBrowserInfo variable Title does not work, when an array is sent as a parameter to retrieve multiple files.

fail() bubbles differently in 16 bit vs 32 bit.

You have saved a form with a NoteBook object. Change the "Tabs Across" property, and close the form. You are not prompted to save the form.

The following toolbar bitmap constants have no menu id constant associated with them: BitmapAddToCat , BitmapChkSyntax , BitmapCompile , BitmapDoJoin , BitmapEditAnswer , BitmapLineSpace1 , BitmapLineSpace15 , BitmapLineSpace2 , BitmapLineSpace25 , BitmapLineSpace3 , BitmapLineSpace35 , BitmapLinkDm , BitmapLoadDm , BitmapNextWarn , BitmapOk , BitmapOpenTutor , BitmapPageBreak , BitmapQuickForm , BitmapQuickGraph , BitmapQuickReport , BitmapQuickXTab , BitmapRemoveFromCat , BitmapSaveDm , BitmapSetBreak , BitmapSetOrgin , BitmapSetWatch , BitmapShowSQL , BitmapSortAnswer , BitmapSpeedExit , BitmapStepInto , BitmapStepOver , BitmapStop , BitmapTButton , BitmapTComboBox , BitmapTListBox , BitmapTProgressBar , BitmapTSpinEdit , BitmapTTrackBar , BitmapViewBreak , BitmapViewCallStack , BitmapViewDebugger , BitmapViewMethods , BitmapViewSource , BitmapViewTracer , BitmapViewTypes , BitmapViewWatch.

So even though, the bitmap constants exists you cannot create the functionality on your customized toolbar.

When you have a tableview open, there is a statusbar message Record x of y. This message is not cleared when the tablewindow is closed.

When you are in another application, e g Notepad, and you try to activate Paradox by clicking on the Toolbar, Paradox does not get activated.

Selecting Delimited Text Import when the text file does not contain field names as first row will open the import dialog with Fixed text selected.

A custom Toolbar generates menuActions. A hidden main form with property DesktopForm=True, will not get the menuactions generated by a custom Toolbar.

Some of the properties for a MRO are number of records: Across and Down and another is FillOrder: TopDown then LeftRight or LeftRight then TopDown. In forms, FillOrder is reversed. If you select TopDown, you'll get LeftRight.

enumTableLinks always gives an errorcode(), -30364 = peCreateWarningRange.

This problem cannot be recreated in P7 with BDE 5.2 on Win 2000 SP4.

When you create a new table with ObjectPAL, you should be able to use password information from an existing table and apply it through the secStruct keyword in the create statement. When you do, the create statement fails with an error Invalid Password Given.

In Paradox 7.0. there is a loss of system resources when printing reports with ObjectPal. If I print a tableview or form using action(DataPrint) there is no resource loss.

There are reports on Table Repair locking up when a table, with a 11 character name, (extension included) is selected using the Browse button.

I am having problems getting the points in a xy scatter plot to show without the lines when I have a large amount of data points, say >1000. In the XY chart there are always lines between the markers. I tried to define no line and Paradox accepts the property but doesn't retain this value the next time you load the report. Then it comes back with lines between the markers.

You get an errormessage [Internal error] when using a setGenFilter after a setRange. This only happens when the table isn't included in the datamodel

1): You have an undefined field with a Picture property defined in the form. If you change the font property, the font may be restored to the StyleSheet default(?) when you depart from the field. As an example, the Picture is specified as ##-##-## and the font MS-Sans Serif Regular 8. On depart, the font size may change to 10.

2): A field forgets its alignment if it has a picture assigned to it.

When you select the list object of a drop-down edit field, then right-click and choose Properties, the Form Properties dialog box displays instead of the List Properties dialog box.

When running a form where a NWC ProgressBar is used in Paradox Runtime, you can get the message "OCX Support is not available".

Under certain circumstances, the syntax table.attach (const tableName String, const tableType String) will create garbage in the destination table.

You can't use Pipe, |, as a separator when exporting to Delimited Ascii. You'll get a message "A Separator must be a single character." There is no way to get rid of the message, but Alt+Ctrl+Delete.

In Paradox 5, fail(usererror,"xxxxx") produced an error dialog. In Paradox 7 for Win95, it will only give an ErrorWarning, that is the message is shown on the statusbar.

Irregular GPVs closing the Quick Lookup dialog with OK or Cancel button when the Constants tab is activated.

QBE contains specifications to change the field order on the answer table. It looks like the report writer is not taking this into account and is still expecting the fields in the order that they are selected from the files. This can cause Paradox to create a GPV error.

query.createAuxTables(False) can cause a GPV in combination with nrecords(:priv:answer).

Sometimes calculated fields placed in the reportband, pageband, or groupband are not printed, even though they show up on screen. I had an example where the report contained an unlinked table (and three or four linked tables of which one was the master table for the report). Fields from the unlinked table were used in the page footer as calculated fields with the summary operator First. To get them printed, I had to place a copy of the fields in the record band (and make the font.color white to prevent them from being printed).

Consistently getting a GPV when using ReadEnvironmentString() in a report when environment variable hasn't been initialized. It happens with any report I make. I don't have any problem with using a form to read an environment string.

Aftering bringing up the msgStop() dialog in a dataunlockrecord action on a dialog form, the filter dialog appears.

You cannot use wildcards in a Filter set on a remote database, and not when using an ODBC connection to another local database. The trailing .. is accepted, but they have no effect. CA.. and CA selects the same rows. C.. only gives the records containing a single C.

Query.setCriteria and Query.checkField select the wrong field if the table has been restructured and field order changed.

In the datamodel for a form or a report, the Help button takes you to the Rename help.

In sortto(), you specify two arrays as parameters. One contains the sort column and the other the sort direction, ascending/descending. The sort order is set as 0 or 1. A third parameter specifies the number of elements in the arrays. When the first sort order is set to be ascending, you can't get a descending sort on the second column.

You cannot change the NCOLS and NROWS property for a MRO object using the Property tab in the right panel on the ObjectExplorer. Any value entered will be changed to 30 when you leave the field.

Paradox 7 cannot handle any text beside MS Serif and Sans Serif. Our system has been built exclusively with the use of very standard Times New Roman. The problem that occurs is a progressively expanding line height display in lists and memo field objects, such that over time a drop-down list grows taller and taller to display the same number of items, and memo fields show fewer and fewer lines, with great gaps between them. It is an unacceptable problem for our clients who run under stressful conditions and keep the program up for days at a time without shutting it down. Only leaving Paradox altogether resets the line height to normal, and the problem progresses very quickly.

Specifying \\ after an alias is handled differently when opening a library than when opening a tcursor.

tCursor won't open when ":MILAGO7:\\DATA\\Dodsintyg.DB" is specified. The alias is resolved to drive letter only.

Under ParadoxWin7 for NT the following code , dlgExport ("Line.db", "Line.wb2"), yields an error box that says: "Don't know how to export to that file type."

The help files also says the method to return a logical value, but it does not.

If I select a text file on floppy drive A, but want to create the table on c: drive, the expert does not provide much help on how to do this.

If I want to import a Tab separated text file, there is no easy way to define Tab as Separator.

A field placed in the Page Footer of a report used for showing the last record presented on a page, will show the next record if the record is completely written on the page. Only if the record is breakable and written on both pages you will get the correct information.

Getting GPVs when using keyboard shortcuts for Copy, Cut, and Paste.

setFileAccessRights() only works for files in the working directory.

You cannot open a table or create a query based on a table in a Excel 5 workbook. You can create a form using the data, though. In the form's datamodel, you'll get User Tables and All tables in the Type control when you select the alias pointing to the Excel database. In the Table Open dialog, there are no such choices.

Whenever the combined length of a multi-field primary key hits 255 or more, and the Paradox table size gets above a relatively small number (around 2,000 records), then the '.px' file gets automatically corrupted (as detected by tutility as well as the Paradox table viewer that refuses to work after a few page-downs).

Related errors:
Corrupt file - other than header.
BTree record number mismatch from block <> record <> to block<>.

Using the Mailing Label Expert in Paradox 7.32 - patch level 3, you can get an errormessage: "An error occurred when setting the property named 'Value' of the object named 'fldDisplay' of type 'Field'" and "Invalid character(s) in this field." when the Define New Label button is pressed on the first page of the expert.

When an alias is given in the filename, Path element in the dynarray created by SplitFullFileName() is incorrect.

There is a problem with passwords when they contain national characters like ä,ö, After a rebuild the password is changed to something different. As the password is set during rebuild, you can open the table directly afterwards, but if you remove the password or exit Paradox, you really get confused when you try to open the table next time.

Paradox generated temporary tables in the private directory are not deleted upon exit from Paradox. Files begining with double underscores are deleted.

With setDesktopPreference() I want to change the background bitmap. The change is visible in the settings dialog box called from the Paradox menu. But the bitmap is not displaying. First I have to click OK in the settings dialog box.

Tools | Object Explorer does nothing in reports.

-m on command line is ignored if a file is included on the command line

Whenever removing the ':priv:' part from the answer tablename in the Query - Properties dialog box, and pressing OK, then rechecking it,the 'priv' alias is back in.

"Number of records" calculated field respects filters if the report does not contain a group band. When a group band exists, it counts records as if the table were unfiltered.

[Open Project Viewer on Startup] checkbox on the General page of Preferences menu does not stay checked, and therefore doesn't reflect the underlying setting in the registry.

Choosing an event handler for a Native Windows Control (NWC) fails to remove the Object Explorer from the screen, even though the Object Explorer's View | Pin Explorer option is unchecked.

Under certain circumstances uiObject.insertAfterRecord() will lock up Paradox if the table is empty.

Scrolling a table in a directory named m:\ber\region\regrak\NyaBeräkningar9396\fiske caused a GPV. When the directory name was changed to ...NyaBerakningar9396... the GPV disappeared.

Sending text to from Paradox to MS Word using oleAuto.TypeText() extra characters (carriage return and linefeed?) are included in the text.

If you create your menus without the use of menuconstants and the code in your menuaction() does not handle all of the menuchoices, you can find some funny things happen when there is more than 50 menuchoices. You can get open file dialogs. The menuchoices not taken care of, have to be the last ones, 50 and above.

Paradox 8 Patch 1:
This patch addresses issues with:
1.Corel Paradox Plug and Play Message.
2.File Browser settings.
3.Using Tab as a separator when using Text Import Expert.
4.Default printer on a Novell network.
5.Printing tables or reports on Novell network.
6.tcursor.deleteRecord() returning true against referential integrity master.
7.Concatenating fields using Calc fields giving null result if linked record has no records.
8.printing to landscape orientation.
9.Custom menu bringing up Form/Report/Data Model designers when no code yet attached.
10.Access Violation when removing a picture from a table in the Restructure dialog box has been addressed in BDE 4.01.
11. PopMenu.addText().
12.Disconnecting a network drive.
13.(intl) pasting in font with a different Script.
14.Hidden forms displaying in the application.
15.Print File and the Page Range radio buttons.
16.Developer Preferences resetting to defaults.

enumFonts() method will cause a loss of resources. System resources, User resources, and GDI resources all drop down to zero.

Using DownArrow in a undefined field in a tableframe when AutoAppend is checked, you may get stuck on the new blank record unless you delete it. It won't delete itself when leaving it.

Running queries to tcursors, you can eventually end up with an error: Too many open tables, even though, you write the table to disk afterwards using tc.instantiateView() and explicitly close the tCursor.

Running on Win2000 SP4, I get a silent exit of Paradox.

You run two queries to tcursors with wantInMemorytCursor(Yes) set for the query-variable. When you subtract the tcursors, tcursor1.subtract(tcursor2), the result is not correct.

With enumDesktopWindowNames() you can select certain type of windows to get information on. If you try to select only query windows, it does not work. The resulting array is empty.

Object Explorer moves upward on the desktop each time you close and reopen it. This behaviour occurs when you have Windows Taskbar at the top of the screen and when AutoHide is unchecked.

On a notebook object, place a textobject on one of the tabs to the right of the labeltext Label1. Make it invisible by unchecking the Visible property. When the Notepage is active, the textobject is invisible, but when the page is inactive, the text is visible.

If national characters are used when naming custom methods, the name of the method will be cut at first national character when View | Document Source i s used. This happens in the column Method Name in the :PRIV:PAL$SRC table. In the column Source, the full name is included.

In this case, national characters are the Swedish å, ä, and ö.

Treat blank as zero setting is ignored for alpha columns when Count operator is used in a calculated field.

If the name of the table you want to verify/rebuild with Table Repair has a short name with only 2 characters, like vc, and you don't enter the extension, you'll get an error dialog saying: [StartIndex is not legal. The value is too large. ]

There are reported problems regarding some calculations. They occur on some machines, but not on others. Symptom of the problem can best be described as: As calculation that should result in 107 will produce 1061. The last two digits added together gives the correct result.

A group defined on a Logical field does not work properly. In a tabular report with a group on a Logical field, records will be sorted but all records belongs to the same group. The Group footer will not be written for each logical value.

The Execute/ExeShowNormal command in Paradox 7.0 does not work correctly - the first time it is called in any given Paradox session the executed application opens correctly but the window is not properly activated and any following SendKeys commands is sent to Paradox instead. Technical Support says that it is a known bug and they "are working on it" but don't know when it will be fixed.

1) Scrolling through a form with a graph causes a loss in GDI resources.

2) When designing Charts, you change from Design to Run mode lots of times. There seems to be a resource leakage when changing mode. After a number of Design changes, the free system resources has dropped to 65 %. This could be the same problem as a), but I'm not sure.

3) Reports in charts will also cause a resource leakage.

4) There's a rather nasty leak in the chart object in P8 that causes a leak if you move your mouse over the chart.

If you start Notepad from Paradox with the code execute("notepad.exe",True,ExeShowNormal), Paradox won't get focus when Notepad is closed.

Importing delimited text files, there are some automatic datatype conversions that can be considered bugs. LongInt fields can import as Number fields. Logical fields can import as Alpha strings.

WinDefaultCoordinate constant does not work as windowstyle coordinate for opening a form.

"Display As Icons" option for an OLE field works initially when the record is being editied, however if the user post the record, the icon disappears.

The use of ' in formatStringToTime was broken in Bde 4.01.

Changing the ColumnWidth property of an unbound tableframe will cause a GPV after a couple of changes.

ui.moveto() moves the focus from one object to another. But if the ui is a tableFrame and one of the fields in the tableFrame already has focus, the visual representation of focus is lost.

There is something funny with the blankrecord property when applied to a fieldobject in a form. Assigning the property to a logical variable can result in a incorrect assignment.

getDesktopPreference(prefProjectSection, prefRefreshRate) does not work properly.

The Edit button on the toolbar does not reflect the real edit mode status. The button is up, when you are in edit mode. And vice versa. Open a table and press F9 to see this.

Custom methods with same name as an event is not shown in ObjectExplorer.

There are some changes in the toolbar ClusterIds that is not documented in the help files. When trying code like removeButton(ToolbarProjectCluster,0) and removeButton(ToolbarExpertCluster,0) the dataModel button is removed.

a) If you have opened the SQL editor on a SQL statement based on a remote database, pressing the Show Visual Query Builder Toolbar button, will prompt for the password even though the database is opened through alias manager.

b) If you select Cancel in the password dialog, Paradox will create a GPV.

A lot of the buttons to select shows a screen Select Field for Popup memo. No Fields are shown in the box to select from. The screen can not be bypassed. Report Preview button and Report Print are two of those that cannot be used. Run a Query is another one.

1): if the table to be restructured is in :priv:, and you attach to the table using :priv:tablename, you'll get an error saying the table cannot be found. Furthermore if the same table exists in :work:, that table will be restructured.

You cannot use an alias when you attach() to the table to be restructured. The alias has to be resolved into a ordinary path by using getAliasPath().

2): If the table to be restructured using the new table.restructure() method has any valchecks, restructure will fail with an error Invalid array of validitycheck descriptors.Eg use Customer table as in the help file example but add a Required valcheck on Customer No.

Fixed in 8.0 patch 1

Using the dataTransfer type to export a Paradox table into ASCII, I get a General Protection Violation on the "setDestCharSet( dtAnsi)"- line.

1): When hideToolbar() is used, there is a thin area left under the menu. This area will affect the maximum size of a page in a not -maximized window. On a 640*480 resolution screen, the height can be increased from 10.22 cm to 10.43 cm without making the desktop scrollbars show up.

2): A hidden floating toolbar in the background produces errors in focusing different forms on the desktop.

I sometimes get a green font color when entering values in a number or currency column. This happened after I had tested hyperlinks.

When applying a range >blank, <0 for a smallInt column, all values are included, even the positive one. I also have problems when defining negative ranges >blank,<-2000 and >-2000, <-1000 is OK, but when I try to add another one >-1000,<-500, I get a message saying low value must be smaller than high value.

The format command would result in all upper case letters when using the "CC" option. For example, format("CC","dog") results in DOG not Dog.

If you specify a minimum or maximum valcheck with more decimals than the Windows configuration, the valcheck will change when the table is restructured. E g define minimum 0.0001 and maximum 0.0019 when you have two decimals specified in Windows Configuartion. Enter some values within the range. Then restructure the table, and the valchecks are shown as 0.00 and 0.00 and during the restructure all records will be placed in the KeyViol table.

In a form with tables linked as 1-M, if setGenFilter() on the detail table results in an empty table , you won't be able to move to it using the mouse.

1) A text file with no file extension, like Px0248, can be imported through the Import Expert, but the script created by expert won't accept the file. The errormessage is Unable to open database table. When the file is renamed and given an txt extension, the import is succesful.

2) Importing a text file without an extension creates an error of "Could not find requested file."

According to the help files:
printerSetOptions returns True if successful; otherwise, it returns False. If you specify a value that doesn't apply to your printer, this method returns False.

This is not true. PrinterSetOptions() does not return False. It produces a warning though, but still it sets options unless you have errorTrapOnWarnings(Yes), which causes the method to fail.

Setting a form's title to an empty string using the setTitle() method in the form's close event, causes Paradox to GPV when switching between Run and Design mode.

Once Paradox 8 is installed on a system that either has Paradox 7 already installed or fresh on the system it replaces the CHARSET.BLL file with USA2.BLL. Thus language drivers using specific character sets are not available to users.

A notebook object with a couple of pages. If you press Ctrl+R when running the form, pages are rotated and the design mode handles show up.

A call to TUFreeCallbackRebuild() located in TuWwr32.dll from Paradox 7/8 will give a GPV when Bde 4.x is used. In Paradox 7 it did not happen with Bde 3.x.

When the value of spin control gets over 1000, the value cannot be retrieved correctly.

the keyEvent eventInfo.vChar() return for pressing the spacebar is NOT "VK_SPACE", but instead is "Space".

exit() combined with a close() behaves differently when the form is started from inside Paradox or from the Windows Desktop with a command line reference. exit() does not exit paradox when the form is launched from Windows Desktop.

Another case where errormessage: "Warning: Record already locked in this session " is produced. A possible cause in this case: when nextRecord is triggered from an undefined field, there is no unlockRecord.

In a table with no primary key, you can drag a record in a tableview to move it to a new place in the table. If the table has a Memo field, it will be lost for the record that was moved.

using newValue() event in a MRO. When the code in newValue() in a field in a MRO references an object in the MRO, the value returned from a reference to the field is not the value from the record having focus, but from the last record in the MRO.

When you use Local SQL to change the part of a compound key AND you have a memo-field, the content of this memo-field is dropped. If you use a QBE file the content of the memo-field is intact.

When using a