Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting a field.
Message
 
 
À
31/07/2001 14:30:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00536043
Message ID:
00537928
Vues:
14
Do you get an error if you run this query from command window?

>I put the code that you give on my remote view but when I save it the system return to me a sintax error message.
>
>This is the code of my query, where is the error.???
>
>
>SELECT Hmilogdf.MODULO, Hmilogdf.PROGLO,;
>  {fn substring(usualo,1,9)} AS cliente,;
>  {fn substring(usualo,10,12)} AS usuario, Hmilogdf.FECHLO,;
>  eval("{^" +transform(Hmilogdf.FECHLO, "@R 9999/99/99")+ "}") as fecha_conexion,;
>  Hmilogdf.HORALO, Hmilogdf.TILOLO, Hmilogdf.NRSELO, Hmilogdf.VRENT1,;
>  Hmilogdf.VRENT2, Hmilogdf.VRENT3, Hmilogdf.VRENT4, Hmilogdf.VRENT5,;
>  Hmilogdf.VRENT6, Hmilogdf.VRENT7, Hmilogdf.VRENT8, Hmilogdf.VRENT9,;
>  Hmilogdf.VRENTA, Hmilogdf.VRENTB, Hmilogdf.VRENTC, Hmilogdf.VRENTD,;
>  Hmilogdf.VRENTE, Hmilogdf.FECHAD;
> FROM CGIPYT.HMILOGDF Hmilogdf;
> WHERE Hmilogdf.TILOLO = 'CNT';
>   AND Hmilogdf.FECHLO BETWEEN ?desde AND ?hasta
>
>
>TIA
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform