Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP-FB Write Description for Table and Field using SPT
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Divers
Thread ID:
00964236
Message ID:
00964511
Vues:
7
What's ODBC error message?

>
>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.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform