2008-10-19 Paradox 11 - Build 410 - Internal 10.0
This document contains descriptions of some errors in the Paradox help files. It covers both cases where the help files are incorrect, and cases where the behaviour
maybe should have been mentioned in the help files.
This document contains information about some undocumented methods and procedures. Be careful when using these methods. They are undocumented and
unsupported.
This file is a complement to my buglist.
My basic source of information for this document is the Corel Paradox newsgroups.
The list has been compiled by:
Bertil Isberg, Statistics Sweden
office e-mail: bertil.isberg AT scb DOT se
home e-mail: bertil.isberg AT bredband DOT net
My current configuration:
Paradox: Help | About dialog: 11.00.410
BDE Administrator: Object | Version Information - Idapi32.dll: 5.2.0.2.
My Computer - Properties: Win XP Media Center Edition Version 2002 SP 2
Note: the items are not sorted by the id.
Table of contents |
Interactive |
| 105 | ActiveX objects | sendToBack() / bringToFront() |
| 223 | BDE | MS SQL Server |
| 653 | BDE Administrator | Auto ODBC |
| 132 | BDE Administrator | MinBufsize and MaxBufsize |
| 78 | BDE Administrator | SharedMemLocation - Win2000 |
| 682 | Chart | XAxisName property |
| 85 | Chart | Marker size |
| 92 | Chart | Logarithmic Scale |
| 683 | Chart | YAxisName property |
| 21 | Chart | LeftWall Pattern on a 3D chart |
| 256 | Command line | Specifying a startfile |
| 119 | DataModel | SQL files |
| 154 | Experts | Objects created by the object experts |
| 260 | Export | QuattroPro 9, .QPW format |
| 89 | Field - Combo | When the list does not fit in the form |
| 107 | Field object | Property Font.Size |
| 100 | Field object | Property NextTabStop |
| 561 | Field object | Format property |
| 273 | Field object | LineSpacing property |
| 274 | Field object | Alignment property |
| 217 | Field object | Fit Width property |
| 159 | Field object | Formatting a timestamp field |
| 108 | Form | Publish to Html |
| 24 | Form / Report | Version Compatibilty |
| 45 | Form / Report | Changing Style Sheet in a form |
| 216 | Form / Report | Version Compatibilty |
| 292 | Form design | Tab order and multirecord objects |
| 140 | Graphic | Aquire Image |
| 692 | Graphic | Magnification property |
| 80 | Import | Fixed length import |
| 239 | Import | Importing dates from Excel |
| 234 | Import | Spreadsheet ranges |
| 244 | Installation | PageSetup. Paper size in inches. |
| 243 | Installation | SpellChecker |
| 242 | Installation | AliasManager and .cfg files |
| 251 | Keyboard shortcuts | CTRL+SPACEBAR |
| 86 | List object | DataSource property |
| 133 | Local SQL | Update table containing memo field |
| 165 | Local SQL | Updating formatted memo |
| 185 | Local SQL | Live Query View |
| 267 | Locate dialog | Advanced pattern match |
| 75 | Locate dialog | Using Wildcards |
| 103 | Nationalized Windows | ProjectViewer |
| 153 | Nationalized Windows | Installation |
| 97 | Nationalized Windows | Format - Date |
| 98 | Open Table dialog | Remote databases |
| 245 | ProjectViewer | Refresh of object lists |
| 36 | Query | Table with 255 columns |
| 161 | Query | Live Query View |
| 649 | Query | Timestamp and time columns |
| 642 | Query | Specifying a selection |
| 192 | Query | Setting: Table Update Handling |
| 28 | Query | Selecting two tables |
| 71 | Query | Translating a Qbe to Sql |
| 72 | Query | Translating a Qbe to Sql |
| 138 | Remote SQL | Sybase: CT Library - temporary tables |
| 33 | Report | PublishAs Html |
| 91 | Report | Table Frame - Detach Header |
| 258 | Report | Summary scope on single-table reports |
| 186 | Report | Defining Group bands |
| 663 | Report | Margins.Right |
| 285 | Restructure | Memo and formatted memo fields |
| 293 | Statusbar | Customizing statusbar |
| 420 | Table | Column names |
| 694 | Table | Language drivers for Paradox tables |
| 180 | Table | Hyperlink |
| 270 | Table | Referential integrity |
| 276 | Table | Editing a table |
| 687 | Table | add |
| 417 | Table | Copy to remote database |
| 669 | Table | Password |
| 49 | Table Structure dialog | Changing a Secondary index. |
| 93 | Table Structure dialog | Picture Validity check |
| 35 | Table Structure dialog | dBase table |
| 95 | TableRepair | Referential integrity |
| 10 | TableRepair | Password |
| 645 | Text object | Property HotKeyTarget |
| 106 | Text object | Property Font.Size |
| 236 | Toolbar | Text formatting toolbar |
| 176 | Toolbar | Text formatting toolbar |
| 275 | Toolbar | Customizing toolbars |
| 146 | Visual Database Designer | General |
ObjectPAL |
| 212 | actionEvent type | ActionSelectCommand constants |
| 474 | actionEvent type | ActionEditCommands constants |
| 673 | actionEvent type | ActionEditCommands constants |
| 423 | actionEvent type | actionClass() example |
| 32 | ActiveX - VCR | Programming the buttons |
| 667 | ActiveX - WebServer | nCookies property |
| 131 | ActiveX - WebServer | Active property |
| 162 | ActiveX objects | VCR and WebServer |
| 623 | addinForm type | isMaximized() |
| 424 | anyType type | view() example |
| 189 | anyType type | blank() |
| 188 | anyType type | isBlank() |
| 300 | anyType type | trace() proc |
| 304 | Application type | setIcon() method |
| 652 | Array type | Maximum size of an array |
| 627 | Basic syntax | Referencing content of fieldobjects |
| 177 | Basic syntax | Assigning strings to field & textobjects |
| 87 | Basic syntax | Values returned from a custom method |
| 254 | Basic syntax | Data types of properties |
| 169 | Basic syntax | Object self |
| 20 | Basic syntax | Naming objects in a form |
| 122 | Basic syntax | PXDLITE.INI |
| 305 | Binary type | clipboardEnum() method |
| 428 | Binary type | size() example |
| 429 | Binary type | writeToFile() example |
| 426 | Binary type | writeToClipBoard() example |
| 691 | built-in event methods | newValue() event |
| 681 | Chart object | YAxisName property |
| 680 | Chart object | XAxisName property |
| 412 | Constants | PrintPreview constants |
| 184 | Constants | PrinterSizes constants |
| 515 | Currency type | currency() |
| 430 | Currency type | currency() example |
| 232 | Database type | open() |
| 432 | Database type | getMaxRows() example |
| 306 | Database type | enumCapabilities() method |
| 431 | Database type | beginTransaction() example |
| 433 | Database type | setMaxRows() |
| 677 | Database type | isTable() |
| 60 | Database type | isTable() |
| 439 | dataTransfer type | getSourceRange() |
| 316 | dataTransfer type | setUI() method |
| 315 | dataTransfer type | setSourceFixedFieldInfo() method |
| 314 | dataTransfer type | setSourceFieldInfo() method |
| 308 | dataTransfer type | enumQAInfo() method |
| 233 | dataTransfer type | setSourceRange() |
| 313 | dataTransfer type | loadFromParadox() method |
| 238 | dataTransfer type | Importing dates from Excel |
| 312 | dataTransfer type | isParadoxImport() method |
| 311 | dataTransfer type | guessSourceType() method |
| 700 | dataTransfer type | getDestCharset() |
| 701 | dataTransfer type | getDestType() example |
| 441 | dataTransfer type | transferData() example |
| 261 | dataTransfer type | QuattroPro 9, .QPW format |
| 436 | dataTransfer type | setSource() |
| 309 | dataTransfer type | enumSourceFieldInfo() method |
| 434 | dataTransfer type | appendAsciiVar() |
| 81 | dataTransfer type | Fixed length import |
| 435 | dataTransfer type | dlgImport() example |
| 689 | dataTransfer type | setProblems() |
| 170 | dataTransfer type | setSourceStartRow() |
| 149 | dataTransfer type | setSource() |
| 310 | dataTransfer type | getSourceFieldInfo() method |
| 438 | dataTransfer type | setSource() |
| 437 | dataTransfer type | getDestDelimitedFields() example |
| 511 | Date type | date() |
| 443 | Date type | dateVal() example |
| 442 | Date type | date() example |
| 317 | Date type | date() proc |
| 512 | Datetime type | datetime() |
| 658 | Datetime type | dow() |
| 659 | Datetime type | doword() |
| 449 | Datetime type | hour() example |
| 135 | Debugger | Tracer |
| 123 | dynArray type | Overview |
| 452 | errorEvent type | setReason() example |
| 451 | errorEvent type | reason() example |
| 453 | Event type | setErrorCode() example |
| 112 | Event type | eventInfo.setErrorCode() |
| 592 | Examples | General issues |
| 96 | Field - ListBox | Number of items in a listbox |
| 6 | Field object | Property Scroll |
| 289 | Field object | BlankRecord property |
| 118 | fileSystem type | deleteDir() |
| 693 | fileSystem type | enumFileList() |
| 55 | fileSystem type | totalDiskSpaceEx() example |
| 461 | fileSystem type | isValidFile() example |
| 196 | fileSystem type | totalDiskSpaceEx() |
| 43 | fileSystem type | getFileAccessRights() |
| 414 | fileSystem type | General information |
| 129 | fileSystem type | totalDiskSpaceEx() |
| 455 | fileSystem type | findFirst() example |
| 456 | fileSystem type | findNext() example |
| 128 | fileSystem type | freeDiskSpaceEx() |
| 457 | fileSystem type | getDir() example |
| 458 | fileSystem type | getDir() |
| 459 | fileSystem type | setDir() |
| 283 | fileSystem type | totalDiskSpace() |
| 460 | fileSystem type | isDir() example |
| 462 | fileSystem type | isValidDir() example |
| 464 | fileSystem type | setPrivDir() |
| 465 | fileSystem type | windowsDir() example |
| 466 | fileSystem type | windowsSystemDir() example |
| 467 | fileSystem type | setPrivDir() examples |
| 469 | fileSystem type | setWorkingDir() examples |
| 282 | fileSystem type | freeDiskSpace() |
| 99 | Form type | isMaximized() |
| 679 | Form type | dmAddTable() |
| 291 | Form type | bringToTop() |
| 470 | Form type | attach() example |
| 116 | Form type | Property DesktopForm |
| 318 | Form type | isDelivered() method |
| 319 | Form type | setIcon() method |
| 478 | Form type | writeText() |
| 477 | Form type | isMaximized() example |
| 476 | Form type | getSelectedObjects() example |
| 475 | Form type | stringListRefresh() example |
| 472 | Form type | dmGetProperty() example |
| 471 | Form type | dmGet() example |
| 183 | Form type | formCaller() |
| 650 | Form type | formCaller() |
| 644 | Form type | getProtoProperty() |
| 422 | Form type | show() |
| 160 | Graphic type | writeToFile() |
| 661 | Graphic type | readFromClipboard() |
| 158 | Graphic type | writeToFile() creating jpg |
| 668 | Graphic type | readFromFile() |
| 141 | Graphic type | readFromFile() |
| 207 | keyEvent type | isAltKeyDown() |
| 206 | keyEvent type | isControlKeyDown() |
| 481 | keyEvent type | setShiftKeyDown() example |
| 479 | keyEvent type | setControlKeyDown() example |
| 480 | keyEvent type | isFromUi() example |
| 482 | keyEvent type | setAltKeyDown() example |
| 109 | Keywords | scan keyword |
| 284 | Keywords | Uses |
| 621 | Keywords | switch example |
| 79 | Keywords | try - onFail |
| 622 | Keywords | quitloop example |
| 82 | Keywords | for - loop |
| 641 | Keywords | Uses |
| 44 | Keywords | Const |
| 483 | Library type | close() example |
| 320 | Library type | isDelivered() method |
| 297 | List object | DataSource property |
| 502 | longint type | isBitSet() example |
| 144 | longInt type | Assigning a hex constant |
| 322 | longInt type | loWord() method |
| 321 | longInt type | hiWord() method |
| 610 | Mail type | getAttachment() example |
| 323 | Mail type | addDataDlg() method |
| 611 | Mail type | getAttachmentCount() example |
| 612 | Mail type | getMessage() example |
| 613 | Mail type | getMessageType() example |
| 614 | Mail type | getSender() example |
| 615 | Mail type | getSubject() example |
| 676 | Memo type | Memo type |
| 487 | Memo type | writeToClipboard() example |
| 485 | Memo type | memo() example |
| 286 | Memo type | Using sizeEx() on a memo variable |
| 155 | Menu type | setMenuChoiceAttribute() example |
| 489 | Menu type | setMenuChoiceAttributeById() example |
| 488 | Menu type | All examples |
| 156 | Menu type | setMenuChoiceAttributeById() |
| 248 | Menu type | Example on building menus |
| 102 | Menu type | setMenuChoiceAttribute() |
| 101 | Menu type | setMenuChoiceAttributeById() |
| 247 | Menu type | menuChecked |
| 130 | menuEvent type | Builtin menuconstants |
| 490 | menuEvent type | id() example |
| 491 | menuEvent type | isFromUi() example |
| 674 | menuEvent type | menuCommand constants |
| 330 | mouseEvent type | setAltKeyDown() method |
| 329 | mouseEvent type | isAltKeyDown() method |
| 492 | mouseEvent type | isLeftDown() example |
| 493 | mouseEvent type | isMiddleDown() example |
| 494 | mouseEvent type | isRightDown() example |
| 495 | mouseEvent type | setMousePosition() example |
| 262 | mouseEvent type | setInside() example |
| 350 | MSWindow type | maximize() method |
| 351 | MSWindow type | minimize() method |
| 349 | MSWindow type | isVisible() method |
| 348 | MSWindow type | isMinimized() method |
| 347 | MSWindow type | isMaximized() method |
| 352 | MSWindow type | setPosition() method |
| 353 | MSWindow type | setText() method |
| 355 | MSWindow type | show() method |
| 356 | MSWindow type | windowHandle() method |
| 354 | MSWindow type | setTitle() method |
| 339 | MSWindow type | enumProperties() method |
| 336 | MSWindow type | bnInfo() method |
| 346 | MSWindow type | isIconic() method |
| 337 | MSWindow type | bringToTop() method |
| 338 | MSWindow type | cbInfo() method |
| 331 | MSWindow type | attach() method |
| 341 | MSWindow type | enumWindowNames() method |
| 342 | MSWindow type | getPosition() method |
| 343 | MSWindow type | getText() method |
| 344 | MSWindow type | getTitle() method |
| 345 | MSWindow type | hide() method |
| 288 | MultiRecord object | BlankRecord property |
| 104 | Nationalized Windows | Menu Window |
| 413 | Notebook object | CurrentPage property |
| 357 | Number type | number() proc |
| 514 | Number type | number() |
| 139 | Number type | number type |
| 214 | ObjectPAL Editor | Object Listbox |
| 137 | ObjectPAL Editor | Global Search |
| 94 | ObjectPAL QuickLookup | BrowserOption constants |
| 620 | oleAuto type | unregisterControl() example |
| 619 | oleAuto type | openObjectTypeinfo() example |
| 117 | oleAuto type | invoke() |
| 618 | oleAuto type | openTypeInfo() example |
| 703 | Page object | size property |
| 240 | popupMenu type | addText() |
| 208 | popupMenu type | show() |
| 88 | Query type | CheckPlus - CheckDescending |
| 190 | Query type | setQueryRestartOptions() |
| 47 | Query type | setAnswerFieldOrder() |
| 46 | Query type | Tilde variable |
| 197 | Query type | getAnswerName() |
| 290 | Query type | Keywords in a query variable |
| 23 | Query type | setLanguageDriver() |
| 65 | Query type | removeTable() example |
| 551 | Query type | removeCriteria() |
| 698 | Query type | checkField() |
| 358 | Query type | dump() method |
| 699 | Query type | insertTable() |
| 359 | Query type | enumFieldStruct() method |
| 552 | Query type | removeCriteria() example |
| 672 | Query type | executeQbe() |
| 547 | Query type | getTableId() example |
| 548 | Query type | insertTable() example |
| 550 | Query type | readFromString() example |
| 361 | Report type | isDelivered() method |
| 179 | Report type | moveToPage() |
| 498 | Report type | load() example |
| 496 | Report type | enumUiObjectNames() example |
| 362 | Report type | isPrintPreview() method |
| 690 | Report type | print() example |
| 363 | Report type | printPreview() method |
| 664 | Report type | Property Margins.Right |
| 249 | Report type | reportPrintInfo variables |
| 365 | Script type | isDelivered() method |
| 500 | Script type | create() example |
| 418 | Session type | enumAliasLoginInfo() |
| 14 | Session type | addAlias() |
| 501 | Session type | saveProjectAliases() example |
| 419 | Session type | getAliasProperty() |
| 299 | Session type | removePassword() |
| 366 | Session type | convertFieldInfo() method |
| 503 | Sql type | setQueryRestartOptions() example |
| 215 | Sql type | writeSql() |
| 120 | Sql type | executeSql() |
| 163 | Sql type | createAuxTables() |
| 505 | Sql type | readFromString() example |
| 634 | Sql type | executeSql() |
| 191 | Sql type | setQueryRestartOptions() |
| 506 | statusEvent type | statusValue() example |
| 626 | String type | upper() |
| 508 | String type | Virtual key codes |
| 507 | String type | chr() example |
| 702 | String type | advMatch() |
| 643 | String type | chr() |
| 509 | String type | chrToKeyName() |
| 704 | String type | search() |
| 510 | String type | format() example |
| 705 | String type | searchEx() |
| 368 | String type | flipCase() method |
| 58 | String type | isEmpty() |
| 374 | String type | writeToFile() method |
| 373 | String type | soundEx() method |
| 372 | String type | reverse() method |
| 371 | String type | readFromFile() method |
| 370 | String type | isURL() method |
| 369 | String type | isEmailAddress() method |
| 266 | String type | advMatch() |
| 367 | String type | breakApart() method |
| 296 | String type | readFromClipboard() |
| 171 | String type | string() procedure |
| 90 | String type | advMatch() |
| 115 | String type | match() |
| 375 | Stringlist type | isAssigned() method |
| 376 | Stringlist type | isEmpty() method |
| 377 | Stringlist type | view() method |
| 516 | Stringlist type | attach() example |
| 151 | System type | tracerWrite() |
| 157 | System type | runExpert() |
| 148 | System type | readEnvironmentString() |
| 241 | System type | sound() |
| 121 | System type | setRegistryValue() |
| 697 | System type | execute() |
| 670 | System type | printerSetOptions() |
| 41 | System type | fileBrowserEx() |
| 175 | System type | sendKeys() |
| 655 | System type | fileBrowserEx() |
| 527 | System type | printerGetInfo() example |
| 127 | System type | fileBrowser() |
| 662 | System type | errorshow() |
| 535 | System type | sound() example |
| 534 | System type | setRegistryValue() example |
| 533 | System type | sendKeysActionId() example |
| 532 | System type | sendKeys() example |
| 531 | System type | searchRegistry() example |
| 530 | System type | searchRegistry() |
| 529 | System type | readProfileString() |
| 528 | System type | readEnvironmentString() example |
| 237 | System type | sysInfo() |
| 526 | System type | getRegistryValue() example |
| 525 | System type | formatSetDateDefault() example |
| 524 | System type | formatGetSpec() example |
| 523 | System type | errorLog() example |
| 522 | System type | errorCode() example |
| 521 | System type | enumRegistryValueNames() example |
| 520 | System type | enumRegistryKeys() example |
| 519 | System type | enumPrinterForms() |
| 517 | System type | enumFonts() example |
| 147 | System type | isTableCorrupt() |
| 656 | System type | fail() |
| 126 | System type | fileBrowserEx() |
| 400 | System type | resetCompileInformation() proc |
| 392 | System type | projectViewerRefresh() proc |
| 393 | System type | projectViewerRestrict() proc |
| 394 | System type | projectViewerUnRestrict() proc |
| 395 | System type | recorderContinue() proc |
| 396 | System type | recorderFlush() proc |
| 397 | System type | recorderPause() proc |
| 398 | System type | recorderStart() proc |
| 399 | System type | recorderStop() proc |
| 391 | System type | projectViewerIsRestricted() proc |
| 401 | System type | sendKeysFromFile() proc |
| 402 | System type | sendKeysSpeed() proc |
| 403 | System type | setNewShell() proc |
| 404 | System type | setRegistryValue() proc |
| 405 | System type | SQLupdates() proc |
| 406 | System type | startUpTime() proc |
| 187 | System type | enumPapersources() |
| 684 | System type | enumDesktopWindowNames() |
| 625 | System type | setGlobal() and global() |
| 382 | System type | errorIsTrapOnWarnings() proc |
| 281 | System type | errorMessage() |
| 181 | System type | fileBrowserEx() |
| 34 | System type | enumPrinters() |
| 378 | System type | addKeys() proc |
| 379 | System type | compilerTimeInfo() proc |
| 380 | System type | enumFontSizes() proc |
| 381 | System type | enumFontStyles() proc |
| 390 | System type | printerGetType() proc |
| 383 | System type | getRegistryValue() proc |
| 384 | System type | isAltKeyDown() proc |
| 385 | System type | isControlKeyDown() proc |
| 386 | System type | isShiftKeyDown() proc |
| 387 | System type | openSQLEditor() proc |
| 388 | System type | printerGetLayout() proc |
| 389 | System type | printerGetPaperSizes() proc |
| 675 | Table type | Language drivers for Paradox tables |
| 671 | Table type | create keyword |
| 219 | Table type | cCount() |
| 225 | Table type | enumSecStruct() |
| 647 | Table type | isEmpty() |
| 167 | Table type | restructure() |
| 168 | Table type | protect() |
| 624 | Table type | create keyword |
| 182 | Table type | create keyword |
| 202 | Table type | nRecords() |
| 209 | Table type | restructure() |
| 210 | Table type | restructure() |
| 211 | Table type | restructure() |
| 537 | Table type | create keyword example |
| 277 | Table type | restructure() |
| 57 | Table type | rename() example |
| 280 | Table type | empty() |
| 59 | Table type | isTable() |
| 15 | Table type | compact() |
| 415 | Table type | copy() to remote database |
| 252 | Table type | restructure() |
| 407 | Table type | addRefInt() method |
| 69 | Table type | setRange() |
| 536 | Table type | copy() example |
| 37 | Table type | add() |
| 538 | Table type | createIndex() example |
| 539 | Table type | enumSecStruct() example |
| 540 | Table type | isShared() |
| 541 | Table type | setReadOnly() example |
| 542 | Table type | sort keyword example |
| 543 | Table type | subtract() example |
| 685 | Table type | add() |
| 409 | Table type | addValCheck() method |
| 136 | TableFrame object | Property CurrentColumn |
| 287 | TableFrame object | BlankRecord property |
| 194 | tableView type | TVHeading object |
| 193 | tableView type | TVData object |
| 497 | tableView type | wait() |
| 201 | tCursor type | nRecords() |
| 3 | tCursor type | isEmpty() |
| 74 | tCursor type | attach(tcursor) |
| 67 | tCursor type | cMax() |
| 172 | tCursor type | locate() |
| 54 | tCursor type | add() |
| 164 | tCursor type | locateNext() |
| 646 | tCursor type | isEmpty() |
| 63 | tCursor type | qLocate() |
| 68 | tCursor type | setRange() |
| 657 | tCursor type | update() |
| 686 | tCursor type | add() |
| 665 | tCursor type | locate() |
| 73 | tCursor type | add() |
| 84 | tCursor type | forceRefresh() |
| 77 | tCursor type | locatePattern() |
| 416 | tCursor type | copy() to remote database |
| 560 | tCursor type | getIndexName() example |
| 564 | tCursor type | insertRecord() example |
| 553 | tCursor type | atFirst() example |
| 554 | tCursor type | atLast() example |
| 555 | tCursor type | copyToArray() example |
| 556 | tCursor type | createIndex() example |
| 557 | tCursor type | enumRefintStruct() example |
| 558 | tCursor type | fieldUnits2() example |
| 559 | tCursor type | getGenFilter() example |
| 226 | tCursor type | enumSecStruct() |
| 218 | tCursor type | cCount() |
| 562 | tCursor type | insertBeforeRecord() example |
| 571 | tCursor type | type() example |
| 563 | tCursor type | insertAfterRecord() example |
| 570 | tCursor type | setRange() |
| 569 | tCursor type | locatePrior() example |
| 568 | tCursor type | isValid() example |
| 567 | tCursor type | isShared() |
| 566 | tCursor type | isInMemoryTcursor() example |
| 565 | tCursor type | home() example |
| 279 | tCursor type | empty() |
| 268 | tCursor type | locatePattern() |
| 228 | tCursor type | cancelEdit() |
| 111 | textStream type | writeString() |
| 688 | textStream type | readLine() |
| 450 | Time type | time() example |
| 513 | Time type | time() |
| 695 | Toolbar type | disabling toolbar buttons |
| 265 | Toolbar type | Bitmap constants |
| 546 | Toolbar type | getPosition() |
| 545 | Toolbar type | setPosition() |
| 544 | Toolbar type | setPosition() example |
| 198 | Tutorial | Wrong directory mentioned |
| 142 | Twain type | aquire() |
| 271 | uiObject type | LineSpacing property |
| 221 | uiObject type | attach() |
| 411 | uiObject type | setOCXWantKeys() method |
| 76 | uiObject type | locatePattern() |
| 499 | uiObject type | create() |
| 272 | uiObject type | Alignment property |
| 56 | uiObject type | cancelEdit() |
| 114 | uiObject type | enumFieldNames() |
| 269 | uiObject type | locatePattern() |
| 696 | uiObject type | bringToFront() |
| 666 | uiObject type | locate() |
| 124 | uiObject type | switchIndex() |
| 83 | uiObject type | setGenFilter() |
| 220 | uiObject type | setPosition() |
| 227 | uiObject type | getRgb() |
| 70 | uiObject type | setRange() |
| 591 | uiObject type | lockRecord() example |
| 604 | uiObject type | setPosition() example |
| 587 | uiObject type | enumSource() example |
| 588 | uiObject type | getHtmlTemplate() example |
| 589 | uiObject type | locateNextPattern() example |
| 590 | uiObject type | locatePriorPattern() example |
| 609 | uiObject type | view() example |
| 608 | uiObject type | recordStatus() example |
| 607 | uiObject type | priorRecord() example |
| 606 | uiObject type | postRecord() example |
| 605 | uiObject type | setTimer() example |
| 200 | uiObject type | nRecords() |
| 603 | uiObject type | postAction() example |
| 602 | uiObject type | sendToBack() example |
| 601 | uiObject type | nRecords() example |
| 600 | uiObject type | nextRecord() example |
| 599 | uiObject type | lockStatus() example |
| 598 | uiObject type | moveToRecord() example |
| 597 | uiObject type | moveToRecNo() example |
| 596 | uiObject type | mouseRightUp() example |
| 595 | uiObject type | mouseRightDown() example |
| 594 | uiObject type | mouseRightDouble() example |
| 593 | uiObject type | menuAction() example |
| 579 | uiObject type | edit() example |
| 648 | uiObject type | isEmpty() |
| 572 | uiObject type | atFirst() example |
| 573 | uiObject type | atLast() example |
| 574 | uiObject type | bringToFront() example |
| 576 | uiObject type | cancelEdit() example |
| 577 | uiObject type | copyToArray() example |
| 578 | uiObject type | deleteRecord() example |
| 173 | uiObject type | locate() |
| 195 | uiObject type | insertAfterRecord() |
| 178 | uiObject type | attach() |
| 580 | uiObject type | end() example |
| 581 | uiObject type | getRange() example |
| 582 | uiObject type | insertBeforeRecord() example |
| 583 | uiObject type | insertRecord() example |
| 584 | uiObject type | isEmpty() example |
| 585 | uiObject type | getPosition() example |
| 586 | uiObject type | killTimer() example |
Runtime |
| 264 | Files required | Objects created by experts |
| 660 | Installation | Silent installation |
| 152 | Nationalized Windows | Installation |
| 295 | ProjectViewer | ProjectViewer |
| 125 | TableRepair | Files required |
| 263 | Unavailable features | PublishAs |
Interactive
Interactive---ActiveX objects
105 sendToBack() / bringToFront()
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 7.0 W95 |
If you place a progressbar (or any other Paradox ActiveX object) directly below a native Paradox Combo field, the Combo field drop down list gets covered by the ActiveX.
ActiveX objects are always in front.
WorkAround:
Use the Visible property to hide/show the object.
To index
Interactive---BDE
223 MS SQL Server
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P3 | 7.0 W95 P4 |
MS SQL Server can be configured to use Windows authentication or SQL authentication. The native MSSQL driver uses SQL Authentication by default unless the settings described below is applied as shown:
We need to blank out the default user name that is set in the BDE Administrator application for the native driver "MSSQL". It was set to "MYNAME" which would be sent to the database which would mess up the Windows Authentication process. By blanking this out, and not sending any user name or password at all when connecting, this seems to tell SQL Server to use Windows Authentication - and everything works!
As we discovered on another machine, it would not work unless the SQL client was set to use "Named Pipes" instead of "TCP/IP" in the SQL Server Client Network Utility. Then it used Windows authentication when supplied with a blank user name and password. If TCP/IP was used, it would still try to connect using a blank user name and password and would not use Windows Authentication.
Reported by: "David Petrie"
Date: 26 april 2006
My comment:
It's on the Alias tab in the Client Network utility, you have to change the Network library setting to Named Pipes.
My preferred solution is to use the SQL Server Odbc driver to connect to a MS SQL Server configured for Windows authentication.
To index
Interactive---BDE Administrator
78 SharedMemLocation - Win2000
| Buglist Id: | Last tested in version: | First seen in version: |
| 9.0 P4 | 9.0 P4 |
On Win2000, set SharedMemLocation in Bde Admin to 5BDE to make it possible to run two instances of Paradox 9.
Otherwise you'll get an error:
Could not initialize BDE: Shared memory conflict.
From: Liz
Date: Sun, 01 Sep 2002
On WinXP, according to Bill Todd on the BDE group, try setting SharedMemSize to 4096 and SharedMemLocation to 6BDE.
From: Lance Leonard
Date: 19 November 2002
Extract from http://bdesupport.com/errors.htm
Other values that may also help solve this issue on NT or Windows 2000 are: 1000, 7000, and 7F00. If none of these values resolve the issue, you may try 2000, 3000, 4000, etc. or any values in between the specified ranges below for each operating system:
Windows 95/98: SHAREDMEMLOCATION = 9000 to FFFF
Windows NT/2000: SHAREDMEMLOCATION = 1000 to 7F00
From: Bill Todd
Date: 22 March 2005
Try reducing the SharedMemSize to 2048 and then try different SHAREDMEMLOCATION.
To index
132 MinBufsize and MaxBufsize
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P2 | 1.0 |
The default values for MinBufsize and MaxBufsize have been too low ever since Paradox 1 for Windows. Increase them to at least 2048 and 16384, to prevent GPV errors when working in Paradox.
To index
653 Auto ODBC
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 302 | 7.0 W95 P4 |
BDE Administrator's help files says:
< Quote >
Setting AUTO ODBC to TRUE is no longer recommended because of the Virtual configuration mode setting. For more information, see Options dialog box.
< /Quote >
When Auto ODBC is False, the virtual aliases created by the BDE are not seen by Alias Manager in Paradox, even though those aliases are shown in BDE Administrator. With Auto ODBC=TRUE, BDE will create aliases seen by Paradox with the same name as the ODBC datasource.
To index
Interactive---Chart
To index
To index
85 Marker size
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0029 | 11 Build 233 | |
In a XY chart, the series (lines) has a property Marker.Size. Even though you specify a size, the markers in the chart are sized in relation to the resulting number of x-value observations in the chart. To see the marker at all, you have to increase the Weight when the number of observation increases.
To index
92 Logarithmic Scale
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | |
If you set Y-Axis properties: Scale: Autoscale and Logarithmic the grid lines disappear. Uncheck Autoscale and select proper values for Y-axis - Scale: Low Value and High Value to get the grid lines.
To index
21 LeftWall Pattern on a 3D chart
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0289 | 11 Build 233 | 7.0 W95 |
The pattern you set for the left wall of a 3D graph is ignored (in design, preview, and print)
To index
Interactive---Command line
256 Specifying a startfile
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 7.0 W95 P4 |
If you specify a startfile on the command line used to launch Paradox, ProjectViewer won't open, and neither will objects left open on the Paradox desktop when Paradox was closed down, be reopened.
Example:
C:\Program Files\WPO11\Programs\PDXWIN32.EXE -p c:\data\pdoxpriv\P7 -o c:\data\bde32cfg\idapiascii.cfg -w c:\data\pdoxapps\dodsorsaker applkonstant.fsl
To index
Interactive---DataModel
119 SQL files
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 | 9.0 P4 |
Not all SQL files will be accepted for use in a DataModel. Especially, if you try to select the SQL file from another directory than the working directory.
Reported by: Carolyn Wendover
I also tried building the report fresh with my SQL file in the other directory. I can see the file when I am in the data model builder, but it will not let me select it. The only way I got it to work was to have the SQL file in my work directory. I do not want that in my production version since it can get overwritten by another user.
Explanation:
The SQL file has to be created based on an alias. If you don't actively specify an alias, you get :work:, and then you cannot use it from a different working directory.
Open the SQL file in the SQL editor. The title of the window should say: :Sample:Px0306. If it says :WORK:Px0306, it has be used from the directory where it was created.
Reported by: LARRY DIGIOVANNI
Date: 11 April 2005
SQL files based on non standard databases cannot be selected for use in the data model at all.
Tested in all 32 bit versions of Paradox with BDE 5.2.
To index
Interactive---Experts
154 Objects created by the object experts
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P2 | |
PARADOX RUNTIME ISSUE
Objects created by the object experts may contain code referencing files in Experts directories, eg Memo field with popup edit window.
When using these experts to create objects to be used in Paradox Runtime, you have to change the code so it doesn't contain a reference to expertsDir() and maybe you have to copy the referenced form to your application.
To index
Interactive---Export
260 QuattroPro 9, .QPW format
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 9.0 |
Exporting to QP9 was never implemented in Paradox 9, something about too many problems parsing the data so it was pulled to allow releasing the product.
Reported by: Steve - Corel
Date: 10 October 2000
Neither Paradox 10 or 11 allows export to QuattroPro 9 - QPW format. Only the the QuattroPro 7-9 - WB3 format is supported in export.
To index
Interactive---Field - Combo
89 When the list does not fit in the form
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 1.0 |
A drop down list have the bad habit of showing the drop down list as a part of the form , so that if the form is too small to contain all the list, the list is clipped to the border of the form.
To index
Interactive---Field object
100 Property NextTabStop
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 | |
When you, in Design mode, using ObjectExplorer, specify the property NexTabStop for a field in a tableframe to a field outside the frame, it is only applied to the first record in the table frame. To make it work for all records in the frame, you'll need ObjectPAL code.
To index
159 Formatting a timestamp field
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P2 | 10.0 P2 |
SUMMARY
If a timestamp field has a format with a different dateorder than the BDE setting for date, entering an incomplete timestamp value, the date will be formatted according to the BDE setting for date, and not according to the format specified for the field.
SETUP:
Table with a timestamp.
BDE setting for timestamp : YYYY-MM-DD hh:mm:ss
BDE Setting for date: YYYY-MM-DD
Format for field:
Dateorder: %D-%M-%Y
%D, %H:%M:%S
In the field, enter a value 01-02-03, which should be Feb 1 2003, and leave the field. You'll get Feb 3, 2001.
Enter a value 01-02-2003, and you can't leave the field.
Enter a value 2003-02-01, and you'll get Feb 1, 2003.
To index
To index
To index
To index
217 Fit Width property
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0330 | 10.0 P3 | 5.0 |
According to help files
< Quote >
You can instruct Paradox to expand objects in a report horizontally to show all of their contents when you run the report. Right-click an object in a Report Design window and choose Properties. Enable the Fit Width check box on the Run Time property page.
The result depends on the type of object.
< /Quote >
In the text that follows, nothing is said on OLE objects. It looks like OLE objects ignore FitWidth, and only relies on Magnification.
To index
561 Format property
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 300 | |
When using formats DBDate, DBNumeric, DBTimestamp, and DBTime as formats in your forms and reports, the format defined is the one you as developer have in your Bde Administrator. This format will be saved with the form/report and applied when form/report is opened by the user.
If the users BDE settings are different than yours, Paradox will create new formats named DBDate1,DBNumeric1, and so on for representing the formats you defined.
When using the Windows formats Windows Short Date, Windows #, Windows $, Windows Time, and Win.DateStamp, your settings are not saved. The format is retrieved from the user's Windows configuration.
Help Topics - index - Formats
To index
Interactive---Form
108 Publish to Html
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 10.0 |
Running a form, File | Publish To Html is no longer available, but the Help files still contains references to the feature.
< Quote >
1 With a form open, click File Publish to HTML.
2 Type a filename in the File name box.
3 Choose .HTM from the Save as type list box.
4 Click Save.
Paradox saves an HTML version of your form that can be viewed by a Web browser. The Corel Web Servers are case-sensitive, so make sure you note the exact filename used when saving documents for future reference.
Notes
· Paradox automatically adds FORM METHOD and ACTION tags to any form published to HTML. By default, the FORM METHOD tag is set to POST and the ACTION is set to the Paradox form object's noise name (for example, #Form1). To set these properties yourself, change the HTMLMethod property or the HTMLAction property of the form using the Object Explorer.
· Paradox also adds a Submit button to static forms published to HTML. For the Submit button to work with the Corel Web Server Control, you must add code to trap the POST action in the OnPostRequest event.
< /Quote >
Since Paradox 10, only tables and reports can be published to Html.
To index
Interactive---Form / Report
24 Version Compatibilty
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0314 | 10.0 P2 | 9.0 |
-You can open forms created in Paradox 10 with a P10 style sheet in P9 without getting an error, but OTOH you cannot open them at all in previous versions.
-When converting forms with even the simplest code from Paradox 9 to an earlier version (8 or 7), you can get a message "Can not interpret file. It could be corrupt" in an error box that will not go away when you press OK. This happens when you use Paradox menus after an object has been selected in the form.
WorkAround:
Open form in Design mode. First thing you do, is to change the style sheet to one from P7 or P8.
-When designing for use in multiple versions, always use stylesheet from oldest version.
-Paradox 10 SP2:
Forms, Reports and Datamodels created in earlier versions can be opened and saved in Paradox 10, then re-opened in earlier versions (unless features from Paradox 10 are used).
To index
45 Changing Style Sheet in a form
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0504 | 11 Build 233 | 5.04 |
Changing a form's style sheet doesn't dirty the form, e.g. DesignModified doesn't get set to TRUE.
Reported by: Lance Leonard
Subject: Paradox misbehaving...
Date: 24 March 2000
To index
216 Version Compatibilty
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0625 | 11 Build 233 | 10.0 P2 |
SUMMARY:
Opening and then closing a form with Notebook object designed in a Paradox 9 or a previous version will give a message that the form is changed when being closed in P10 or later versions.
SETUP:
1. Start Paradox 8.
1.1 Open/New/Blank Form.
1.2 Put Notebook object on it.
1.3 Close and save the form as "nbForm.fsl".
1.4 Close Paradox 8
2. Copy "nbForm.fsl" to Paradox 10 :WORK:.
3. Open Paradox 10.
3.1 Open "nbForm.fsl".
3.2 Close the form.
Result:
Question "You have made changes... Do you want to save it?" appears.
Notes:
1. I haven't noticed problem while using other design objects.
2. Same problem I can recreate using P9 originated nbForm too.
Reported by:
From: Ivica Kolar
MY COMMENT:
DesignModified property is set to True when form is opened in design mode.
To index
Interactive---Form design
292 Tab order and multirecord objects
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 300 | 11 Build 300 |
In a form with more than one table, the Design layout screen will allow you to select how the tables are to be shown. If master table is shown as multirecord object, the setting Nested is made available.
With nested objects, the detail table is placed inside the record object of the master mro, and the tab button will move between master and detail table.
With unnested obejcts, the detail table is placed outside of the master mro. Tab button will move inside the mro.
When creating the objects manually, you can choose to place the detail table in the mro itself as opposed to the record object. In this case the tab button will not leave the master table.
To index
Interactive---Graphic
692 Magnification property
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 410 | 10.0 |
If you have two graphic images with the same size but with different resolutions, (dpi value) when inserted into a Paradox graphic object, the image with the higher resolution will be smaller than the other image.
I used Corel PhotoHouse to create two jpg files, one with 150 dpi and one with 68 dpi. Viewed at 100 % they have the same size, but viewed with zoom factor 1:1, the 150 dpi jpg is much smaller than the 68 dpi jpg. Paradox takes the size of the jpg with zoom factor 1:1.
According to the PhotoHouse help files:
"Zoom (100%) Displays the most accurate representation of the active image. Zoom 100% matches pixels in the image with screen pixels in the display.
Zoom 1:1 Displays the active image at its actual physical size"
Opening the two jpgs in Kodak Imaging, and selecting the Zoom "Natural Size" (translated from Swedish), I see the same effects as in Paradox. The 150 dpi jpg is smaller than the 68 dpi. Natural size represents a zoom factor 64% for 150 dpi and 141.5% for 68 dpi.
Help files explain it this way (translated from Swedish)
Natural size will adjust the picture so it is shown with its actual size, 1 cm in the picture is 1 cm on the screen.
Reported by: Bertil Isberg
Date: 20 September 2005
To index
140 Aquire Image
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P2 | 10.0 |
Paradox does not support 32 bit images, regardless if they are scanned in, or imported from files. With other topics such as graphics handling, 24bit scanned images can be saved to disk as .gif, .jpg to keep the filesize down.
...
Paradox is not capable of acquire 32bit graphic images to graphic objects or graphic field objects. If a 32bit image is acquired to one of these objects, the image will appear slanted or distorted. 32bit images can be acquired to a file successfully. In general, applications should not acquire images greater than 24bits to adhere to the limitations of Paradox.
REPORTED BY:
Paul Cronk
To index
Interactive---Import
80 Fixed length import
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0416 | 10.0 | 7.0 W95 |
If you do a fixed length import from a file with NULL characters in it (ASCII 00), you get an error of "Corrupt file - other than header" and the resulting table is blank.
To index
To index
To index
Interactive---Installation
242 AliasManager and .cfg files
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0684 | 10.0 P3 | 10.0 P3 |
Paradox 10 in WPO2002 SP3
Win2000, Win95B
PROBLEM:
.cfg file has to be a registered extension
DESCRIPTION:
When saving the changes made in AliasManager, the cfg file will get an .ini extension. Idapi32.cfg will be saved as Idapi32.cfg.ini, and it won't be the file loaded next time Paradox is launched.
Problem is caused by .cfg not being registered in HKEY_CLASSES_ROOT. When registering it, the problem disappears.
[HKEY_CLASSES_ROOT\.cfg]
@="cfg file"
is enough
Paradox code to do it:
setRegistryValue( ".CFG", "", "cfg file", RegKeyClassesRoot )
This has been verified in Paradox 10 with WPO2002 SP3 installed running on Win2000 and Win95B.
P9 SP4 works without .cfg being registered.
To index
243 SpellChecker
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0681 | 10.0 P3 | 10.0 P3 |
Paradox 10 WPO2002 SP3
PROBLEM:
SpellChecker looks for an incorrect Registry key after installation of SP3.
[HKEY_LOCAL_MACHINE\SOFTWARE\AppMan\10\IAYG\Components\WTEnglish_Folder2\WordPerfect Office 2002 Professional::10]
"InstallDest"="C:\\Program Files\\Corel"
DESCRIPTION:
Open any table with an Alpha column. Move to that column. Enter edit mode. Select Tools | SpellChecker.
Reported by: Jack E. Wasserstein, DDS
Date: 21 September 2002
Verified by: Martin Ferwerda
Yep, broken for me also after sp3 on WinME.
WORKAROUND:
Add InstallDest to the registry key below
[HKEY_LOCAL_MACHINE\SOFTWARE\AppMan\10\IAYG\Components\WTEnglish_Folder2\WordPerfect Office 2002 Professional::10]
"InstallDest"="C:\\Program Files\\Corel"
Here's code to do it from inside Paradox
var
st string
endvar
st=getRegistryValue( "Software\\Corel\\Appman\\10\\IAYG\\Components\\WTEnglish_Folder2\\WordPerfect Office 2002 Professional::10",
"InstallDest", RegKeyLocalMachine )
setRegistryValue( "Software\\Appman\\10\\IAYG\\Components\\WTEnglish_Folder2\\WordPerfect Office 2002 Professional::10",
"InstallDest", st, RegKeyLocalMachine )
For an OEM version of WP office the key is:
[HKEY_LOCAL_MACHINE\SOFTWARE\AppMan\10\IAYG\Components\WTEnglish_Folder2\WordPerfect Office 2002 OEM::10]
To index
244 PageSetup. Paper size in inches.
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0610 | 10.0 P2 | 10.0 |
Paradox 10, 11
Win2000
PaperSize is reported in inch even though ControlPanel - Measurement System is set to Metric.
Win2000 US version and Swedish version with Regional options set to Swedish.
Not in Win95B Swedish version.
Problem disappears when Registry setting PreferredLanguage is changed to SV
[HKEY_LOCAL_MACHINE\SOFTWARE\COREL\WordPerfect Suite\11]
"PreferredLanguage"="EN"
Change for appropriate version of the office suite.
To index
Interactive---Keyboard shortcuts
251 CTRL+SPACEBAR
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 9.0 |
When Ctrl+Spacebar doesn't invoke the Table Lookup dialog.
If you have installed Internet Explorer 4 with desktop enhancements on Win NT, the key combination Ctrl-Spacebar is no longer valid. Choose the command from the menu. If it works, this was the problem.
Reported by: Daniel Betschart
Subject: V9 Table Lookup Fails
Date: 21 February 2000
The "INTERNAT.EXE" International keyboard switcher took over the CTRL-SPACE key combo...
Reported by: Kasey Chang
Subject: NT Bug
Date: 4 April 2000
To index
Interactive---List object
86 DataSource property
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 7.0 W95 |
Specifying the DataSource property for a list object in ObjectExplorer, by setting Table.ColumnName, the value does not stick. This is as designed. The value is used for a one time loading of the list, but it will not read the table every time the form is opened.
To index
Interactive---Local SQL
133 Update table containing memo field
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P2 | 7.0 W95 P4 |
Updating a table containing memo field using local SQL Update statement does not work as expected.
a) SQL Property setting "Generate auxiliary tables" interferes with the number of records updated
b) update tablename
set memo="value"
does not work.
WorkAround:
add where clause
where 1=1
c) update tablename
set memo="value"
where id < value
will run forever.
The upper boundary has to be closed like <=value.
This applies also when a range like
where id>value1 and id < value2
is used.
d) See also bug Px0386
e)
See also WadId 165 on Formatted memo
SETUP:
Create a table Px0386c
id - I *
m1 - M 1
m2 - M 1
f1 - f 1
Add 20 records with id=1-20. Leave the memo fields blank. They will be updated in the examples.
Run a local sql. Generate auxiliary tables should be checked in the SQL properties dialog.
You have to reassign values to M1 and M2 now and then to be able to see the result.
1)
update px0386c
set m1="abc"
Only 16 records are updated.
2)
update px0386c
set m2="def"
where id>0
Only 16 records are updated
3)
update px0386c
set m1="bcd"
where 1=1
only 16 records is updated
Change the SQL properties to Fast query. Use this setting from now on.
1) still only 16 records
2) all records are updated.
3) all records are updated.
4)
update px0386c
set m1=m2
where id>0 and id<21
will run forever
5)
update px0386c
set m1=m2
where id<21
will run forever
6)
update px0386c
set m1=m2
where id<=20
is Ok
7)
update px0386c
set m1=m2
where id>=1 and id<=20
is Ok
8)
update px0386c
set m1=m2
where id between 1 and 20
is Ok
9)
update px0386c
set m1="zzz"
where id in(1,2,3,4,5,6,7,8,
9,10,11,12,13,14,15,16,17,18,19,20)
is Ok.
10)
This one is logged (Px0386)
update px0386c
set id=id
will wipe out data from memo columns for some records. Record 9 and later.
When running this from ObjectPAL, there is no sqlHandle.createAuxtables(No) for sql type. You can achieve this by adding a comment to the Sql statement like this
sqlHandle=Sql
/*
AuxTables: False
*/
Here goes you ordinary SQL statement
endSql
Problems have been verified by: Ivica Kolar
To index
165 Updating formatted memo
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P2 | 7.0 W95 P4 |
Updating a table containing formatted memo field using local SQL Update statement does not work. The table will be corrupted so you can't enter values in the formatted memo field using a table view.
SETUP:
Create a table Px0386c
id - I *
m1 - M 1
m2 - M 1
f1 - f 1
Add 20 records with id=1-20. Leave the memo fields blank. They will be updated in the examples.
Run a local sql. Check Fast Queries in the SQL properties dialog.
update px0386c
set f1="abc"
where 1=1
does not work.
You cannot update a formatted memo at all using Local SQL.
Result is corrupted table.
Entering Memo view on f1 field in table view gives:
"Error writing file. Record not tagged."
Problem has been verified by: Ivica Kolar
To index
185 Live Query View
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | |
According to the Paradox 10 Help files, Live Queries (SQL) , you should be able to create a Live Query View when the SQL statement contains an ORDER BY clause:
Single-table queries or views can be updated provided that
· there are no UNION, INTERSECT, or MINUS operations
· there is no DISTINCT keyword in the SELECT statement
· everything in the SELECT clause is a simple column reference or a calculated field, and no aggregation is allowed
· there is no GROUP BY or HAVING clause
· there are no sub queries that reference the table in the FROM clause and no correlated sub queries
· any ORDER BY clause can be satisfied with an index
I have not been able to create an live query view when there is an ORDER BY clause. My guess is that the last condition should have been: any ORDER BY clause is replaced by using an index for changing the sort order.
Reported by: Father Robert Bower
Date: July 22 2002
To index
Interactive---Locate dialog
75 Using Wildcards
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0053 | 10.0 | 5.04 |
There are problems when using the Locate dialog to find values that contains space or special characters like +, that can be used in Advanced Pattern Match.
Say you have a field that contains the value (inside the quotes) "aa + bb" and you want to do a locate pattern to find the value.
Try aa.. , aa .. , aa +.. , aa + b..
Add a \ before the + char and check the Advanced pattern match in the Locate dialog.
To index
To index
Interactive---Nationalized Windows
97 Format - Date
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 | |
This applies only to nationalized versions of Windows.
When selecting the date format Windows Long, there is a setting Case for the name of the Month. It has three choices: Mixed Case, Upper, Lower . The specification MixedCase is related to the Windows Standard, which in USA is Mixed Case, but in Sweden is lower case. You won't get Jan but jan.
To index
103 ProjectViewer
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 8.0 |
The Property menu for Paradox objects in ProjectViewer contains a menuitem SendTo (in Swedish = SkickaTill) with no functionality at all. The menuitem shouldn't be there. In a US version of Windows, it does not occur.
To index
153 Installation
| Buglist Id: | Last tested in version: | First seen in version: |
| 10.0 P2 | |
Install: P10 does not follow Win98 localization.
Installing P10 to Win98 with CentralEuropean setup, DefaultFont/Script value is Western by default.
Steps:
1. Prepare clean Win98 setup for CentralEuropean area, Croatia for example.
2. Install and run Paradox 10.
3. Use Tools/Settings/Preferences and check Script value of Default font option.
Script is, by default, Western i.e. not CentralEuropean.
Workaround: User have to manualy correct Script value.
REPORTED BY: Ivica Kolar
Date: 10 March 2002
To index
Interactive---Open Table dialog
98 Remote databases
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0023 | 10.0 | 1.0 |
You can select multiple local tables in the Table | Open dialog. You can only select one from a remote database.
To index
Interactive---ProjectViewer
245 Refresh of object lists
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0666 | 11 Build 233 | |
With Working directory on a network drive, saving a new form, it won't show up in ProjectViewer until Current directory is changed.
Changing the RefreshRate under Tools | Settings | Preferences from default value = 60 to 3, will cause ProjectViewer to refresh the object list almost instantly.
This happens when running Paradox on Win2000, and the file server is a Win2000 server.
Originally reported by: Wayne Sheppard
Subject: Paradox 10 project viewer
Date: 26 July 2001
To index
Interactive---Query
To index
71 Translating a Qbe to Sql
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 7.0 W95 |
If you translate a QBE file to a SQL statement with the SHOW SQL button, the columnlist after SELECT seems to have a max limit of size. With 8-10 characters in each column name, I manage to get 92-93 columnames in the list. An estimated max length seems to 1026 characters give or take a few.
To index
72 Translating a Qbe to Sql
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0200 | 11 Build 233 | 7.0 W95 |
When a QBE with a "NOT value" criteria is translated to SQL, you get Column<>value. The QBE condition will select blank values, but the SQL condition won't. To get the same result in SQL as in QBE, you have to change the code to NOT(Column=value).
To index
28 Selecting two tables
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0362 | 11 Build 233 | 7.0 W95 |
When you create a new Query and select two tables from an alias to be included in the query, the alias will be resolved into a directory name. When selecting one table, the alias will be saved into the QBE file.
To index
36 Table with 255 columns
| Buglist Id: | Last tested in version: | First seen in version: |
| PX0460 | 11 Build 233 | 5.04 |
A Paradox table with 255 columns can be created and viewed, but you cannot create a query based on the table.
To index
161 Live Query View
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 233 | 5.04 |
The help files says on Live query view - QBE
< Quote >
The selection conditions you specify in the query must be capable of being expressed as a filter. This means the following query structures are not allowed:
....
Use of the ".." wildcard operator before selection conditions. Use of the .. wildcard operator after a selection condition is allowed, as in the example Canada.., and produces a case-insensitive answer set.
< /Quote >
But, with a trailing wildcard like in Canada.. , you won't get a live query view, only a query view with read-only fields.
The corresponding query translated to SQL will create a Live query view.
To index
649 Timestamp and time columns
| Buglist Id: | Last tested in version: | First seen in version: |
| 11 Build 302 | 5.04 |
The following is from a Paradox TechInfo (slightly edited by Bertil Isberg)
Q: How do I query a time or timestamp field from the query editor?
A: To query a time or timestamp field, you must enter the time in military time (24 hours) and include seconds. In a timestamp field, the date must be entered before the time with a space in between the date and the time. This is true regardless of your settings in the BDE Administrator. Date should be formatted as DBDate format. Below are a number of examples where DBDate format is yyyy-mm-dd.
1. Query all records where the time field value is exactly 1:30 in the afternoon.
Query
Table | TimeField |