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.




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004


[Non-text portions of this message have been removed]