Namit Nathwani wrote:

> 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).
> <http://www.grisoft.com%29.>
> Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004
>
>
> [Non-text portions of this message have been removed]

Namit,

DESCRIBE hasn't to do with Tabledescriptions. Where did you get this one?
There are no Sql-Commands for the Description Column of the Metadata.
If you want to have a Description, you have to update the Metadata yourself.

Uwe