>>Hi,
>>
>>I am writing a code to create a table and DELETE trigger in the SQL Server. I get the error message
>>
>>"Create Trigger" must be the first statement in a query batch
>>
>>
>>My code (passed to SQL) server does the following (which I basically copied from query window of SSMS):
>>1. Create table
>>2. Create index
>>3. Create Trigger
>>
>>The code works when executed in SSMS but fails when executed from VFP. What do I need to change in the code? TIA
>
>You will need to send each block of code as a separate sqlexec statement. E.g. in your code there may be GO separators. Each of this block should be send as a separate command to SQL Server from the application but using the same connection handle.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham