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 IamaSherpa 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. theodorez

    Null parameters and optimising SQL extraction

    Thank you, for the reply. I ended up using, and ({SMDR.Country} = uppercase({?Country}) or trim({?Country}) = "" ) That generated the result I was after. Cheers, T
  2. theodorez

    Null parameters and optimising SQL extraction

    Thanks for the reply, however, my "convert null values" is greyed out because I have clicked "Perform grouping on the server". I am trying to make the extraction more efficient. Ideally, if the user enters a Country parameter, the SQL should show blah blah WHERE SMDR."Date" >= {d...
  3. theodorez

    Null parameters and optimising SQL extraction

    Hi, I'm using Crystal 8.5 and having all sorts of grief with null parameters. I have a rather large database > 1 Million records and want to optimise the SQL extraction so that it only extracts records matching some filters. I want crystal to create an SQL something like this SELECT...

Part and Inventory Search

Back
Top