Information générale
Titre:
Inserting numeric data via SQL pass-through
Newbie lost in the syntax jungle again...
The following INSERT statement works fine if all of the columns/fields are character. However, if the LIC_NUMBR field were a Smallint or TinyInt field type, what is the syntax to make this work? Note '&mLIC_NUMBR' is a VFP memory variable.
lnResult = SQLEXEC(hConn, ;
"INSERT INTO EXPORT " + ;
"(APPL_TYPE, LK_NUMBER, LIC_NUMBR, COMPANY, " + ;
" CONG_REV ) " + ;
"VALUES ('&mAPPL_TYPE', '&mLK_NUMBER', '&mLIC_NUMBR', '&mCOMPANY', " + ;
" '&mCONG_REV')" )
Similar question -- what if it were either a "bit" field and a "datetime" field type.
Thanks in advance again...
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement