Exec command in SQL

1

How do I get the result back from this MSSQL “query”:
Exec master.dbo.xp_fixeddrives()

FileName{Prop:SQL} = ‘Exec master.dbo.xp_fixeddrives()’
Loop
Next(FileName)
…
…

Doesn’t give a result!!!

2

Hi Alex,
don’t use Prop:SQL. Instead use Prop:SQLRowSet. If you want to use Prop:SQL you must change your syntax to ‘call master.dbo.xp_fixeddrives()’

3

I assume master.dbo.xp_fixeddrives() is a stored procedure that returns a dataset? In which case

'CALL master.dbo.xp_fixeddrives()’

is what you want, and your “filename” clarion table needs to have columns that match the data set that the procedure returns (i.e. if the first column from the procedure is a string, don’t try to put it in a clarion short or long.

5

Found the solution:

SQLDiskFree{PROP:SQLRowSet} = ‘master.dbo.xp_fixeddrives’
Loop
Next(SQLDiskFree)
If ErrorCode() Then Break.
…
…

1 Like