Clarion {PROP:SQL} Call Microsoft SQL Server System Procedure String

questions
1

Hi Folks!

Have SQL Server Management Studio working request (Create folder)

master.dbo.xp_cmdshell ‘mkDir “D:\Databases\Application\Microsoft SQL Server Databases”’

Clarion Variable

FolderCreatePath CSTRING(255)

FolderCreatePath=’“D:\Databases\Application\Microsoft SQL Server Databases”’

Help me, pls, create Clarion TurboSQLTableMaster {PROP:SQL} String

TurboSQLTableMaster {PROP:SQL} = ?

2

Solution:

TurboSQLTableMaster {PROP:SQL} = ‘master.dbo.xp_cmdshell’ & ’ ’ &’<39>’ & ‘mkDir’ & ’ ’ & FolderCreatePath &’’’’

Problem solved <’> in Clarion <39>