Sql - insert doesn't work for numeric value? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Sql - insert doesn't work for numeric value?

Message

De

04/04/2005 11:06:46

Bong Mendoza
Habitat Furniture
Jeddah, Arabie Saoudite

À

04/04/2005 07:06:49

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: Sql - insert doesn't work for numeric value?

Versions des environnements

Visual FoxPro:

VFP 9

OS:

Windows XP SP1

Network:

Windows 2003 Server

Database:

MS SQL Server

Divers

Thread ID:

01001142

Message ID:

01001217

Vues:

16

Problem solved.

=SQLExec(gnConnectionHandle, "INSERT INTO [TRANSFILE].[DBO].[ADJFILE] (DESCRIPTION) VALUES ('&cDescription') " ) <--- this command works and saves the record

=SQLExec(gnConnectionHandle, "INSERT INTO [TRANSFILE].[DBO].[ADJFILE] (TNUMBER) VALUES (?nTNumber) " ) <---- this works now

I just remove the ' ' and replace & with ? for numberic value and it is working now.

Thanks Borislav, Tore and Sergey!

Click here to load this message in the networking platform