cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Command question

Former Member
0 Kudos

Does anyone know if a sql command can contain multiple sql statements? Or do I need to create a separate command for each sql statement?

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The content of an SQL Command is basically identical to the body of a stored procedure: You can have as many statements as required to return the data that you need. The only limitation that I'm aware of is that Crystal only processes the LAST data set returned by the command, so you can't return more than one (and have it be useful to your report). That, and passing multi-valued parameters is not allowed for an SQL Command.

HTH,

Carl

Answers (0)