Hi all
I would like to put in description for the table and fields using SQL Pass Through from VFP. I have successfully created this table from VFP but I am not able to send DESCRIBE TABLE and DESCRIBE FIELD commands. The following is the code I have used in VFP (I have tried the below code with and without Semi-Colon)
lcTemp = [DESCRIBE TABLE ] + UPPER(lcTableName) + [ '] + lcTableComment + [']
wait window str(SQLEXEC(lnFBHandle, lcTemp))
SCAN
IF NOT EMPTY(FldCaption)
lcTemp = [DESCRIBE FIELD ] + UPPER(ALLTRIM(FldName)) + [ TABLE ] + UPPER(lcTableName) + CHR(13) + CHR(10) + [ ';c;] + FldCaption + [']
wait window str(SQLEXEC(lnFBHandle, lcTemp))
ENDIF
ENDSCAN
I always get a -1 from SQLEXEC() where just before this code I have successfully execute the table creation code.