>>>Hi,
>>>
>>>I think I can sent two command to SQL Server from VFP app (using SQLEXEC()) but I am not sure what separator to use. Should it be semi colon? For example if I want to alter a column and then set a value into this column, can I do the following:
>>>
>>>
>>>cSqlCmd = "alter table MyTable alter column MyFld1 char(30); update MyTable set MyFld1 = repl('0',30) where len(MyFld1) = 0"
>>>nRetunr = SQLEXEC(nConn, cSqlCmd)
>>>
>>>
>>>Will the above work? TIA
>>>
>>>UPDATE. I ran it and it works.
>>
>>Yes, you can and should use semicolon. You can also use text endtext to put commands in multiple lines to improve readability.
>
>What would be an exmaple of my string above using 'text / endtext'?
text to lcSQL noshow
alter table MyTable alter column MyFld1 char(30);
update MyTable set MyFld1 = replicate('0',30) where len(MyFld1) = 0;
endtext
If it's not broken, fix it until it is.
My Blog