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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CRDvlpr

    How to send Or clause to SQL

    The datatype of the field tcl_srvc.end_dt is date.
  2. CRDvlpr

    How to send Or clause to SQL

    I tried what you had asked me to do. This is what i found. Isnull part is not going in SQL. Anything after Isnull or before Isnull goes in the SQL. Isnull won't go irrespective of using OR or AND. Thanks again for trying to help. Thanks
  3. CRDvlpr

    How to send Or clause to SQL

    Hi, I have already tried that, it doesn't work. Yeah I'm using the CR supplied Oracle Driver. Thanks.
  4. CRDvlpr

    How to send Or clause to SQL

    Hi, I was reading your post and i saw only version number. I didn't see the database information that you asked for. Sorry for that. Version - Crystal 7 Database - Oracle 8 Connectivity - Oracle driver. Problem: Part of Record selection formula missing in the Where clause of SQL. The part...
  5. CRDvlpr

    How to send Or clause to SQL

    My client has Crystal Version 7. I think this will work in 8 and higher. I was wondering if there is a work around. Thanks
  6. CRDvlpr

    How to send Or clause to SQL

    I have a record selection formula which has a Or clause which is pasted below. Everything except the Line with the OR clause is not send in the SQL. Is there a way to fix this. (isnull({TCL_SRVC.END_DT}) or {TCL_SRVC.END_DT} >= {?Start Date} ) and {TCL_SRVC.BGN_DT} <= {?End Date} and...

Part and Inventory Search

Back
Top