Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ODBC acces to Pervasive selection on Dates with no value

Status
Not open for further replies.
PHvW

PHvW

Programmer
Aug 14, 2001
1
AN
Hi,

Having troubles with selection formula's where I want to test on dates which are not filled with any data.

Crystal 8.5.3.861 does not pull up any data.
Crystal 9.2.3.666 give also no result.
MsQuery does not have any problems.

In 9.0 the sql query is
WHERE "database"."field_name"={d '1899-12-30'}

In 8.5
WHERE database."field_name" = {d '1900-01-01'}

Anyone experienced the same ?

Peter
 
Status
Not open for further replies.

Similar threads

Kennymc
  • Locked
  • Question
Crystal connection to Microsoft business central 365
Replies
0
Views
957
Kennymc
Kennymc
s_reddibathuni
  • Locked
  • Question
export multiline address field from crystal to excel
Replies
3
Views
760
hilfy
hilfy
Ivan Kok
  • Locked
  • Question
Crystal Reports Runtime causing AS/400 DB2 Database ID to be disabled intermittently
Replies
0
Views
639
Ivan Kok
Ivan Kok
dgillz
  • Locked
  • Question
Cannot connect to any ODBC datasource with MS SQL Server data in crystal
Replies
8
Views
1K
LyleU
LyleU
CrystalUser90
  • Locked
  • Question
Same field on two tables, merge into one field on report 1
Replies
2
Views
648
CrystalUser90
CrystalUser90

Part and Inventory Search

Sponsor

Back
Top