Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wrong numeric field size from SQLEXEC() call
Message
De
12/12/2005 13:40:49
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Wrong numeric field size from SQLEXEC() call
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Divers
Thread ID:
01077250
Message ID:
01077250
Vues:
83
To reproduce:
cConnString ="DRIVER={PostgreSQL Unicode};DATABASE=postgres;"+ ;
   "SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=x;B9=0"
nconnh=SQLSTRINGCONNECT(cconnstring)
TEXT TO csql
CREATE table test ( test char(1));
insert into test values ('');
select CAST( 0 AS numeric(1)) from test
ENDTEXT

IF SQLEXEC(nconnh, csql)<0
  RETURN
  ENDIF

SELECT sqlresult
DISPLAY STRUCTURE TO FILE t
MODIFY FILE t
Observed: result table contains numeric(20,6) field
Expected: result table should contain numeric(1) type field

How to get expected result ?
Andrus
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform