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 2337.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 P37.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 P49.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 P21.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 3027.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

682 XAxisName property
Buglist Id: Last tested in version: First seen in version:
11 Build 4107.0 W95

To index

683 YAxisName property
Buglist Id: Last tested in version: First seen in version:
11 Build 4107.0 W95

To index

85 Marker size
Buglist Id: Last tested in version: First seen in version:
PX002911 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:
PX028911 Build 2337.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 2337.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.09.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 2339.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 2331.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 P210.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

107 Property Font.Size
Buglist Id: Last tested in version: First seen in version:
11 Build 233

To index

273 LineSpacing property
Buglist Id: Last tested in version: First seen in version:
11 Build 2335.04

To index

274 Alignment property
Buglist Id: Last tested in version: First seen in version:
11 Build 2335.04

To index

217 Fit Width property
Buglist Id: Last tested in version: First seen in version:
PX033010.0 P35.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 23310.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:
PX031410.0 P29.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:
PX050411 Build 2335.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:
PX062511 Build 23310.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 30011 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 41010.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 P210.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:
PX041610.07.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

234 Spreadsheet ranges
Buglist Id: Last tested in version: First seen in version:
10.0 P39.0 P4

To index

239 Importing dates from Excel
Buglist Id: Last tested in version: First seen in version:
PX063911 Build 233

To index

Interactive---Installation

242 AliasManager and .cfg files
Buglist Id: Last tested in version: First seen in version:
PX068410.0 P310.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:
PX068110.0 P310.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:
PX061010.0 P210.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 2339.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 2337.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 P27.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 P27.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:
PX005310.05.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

267 Advanced pattern match
Buglist Id: Last tested in version: First seen in version:
11 Build 2334.5

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 2338.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:
PX002310.01.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:
PX066611 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

192 Setting: Table Update Handling
Buglist Id: Last tested in version: First seen in version:
10.0 P2

To index

71 Translating a Qbe to Sql
Buglist Id: Last tested in version: First seen in version:
11 Build 2337.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:
PX020011 Build 2337.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:
PX036211 Build 2337.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:
PX046011 Build 2335.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 2335.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 3025.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 |