Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting a field.
Message
From
31/07/2001 14:30:06
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00536043
Message ID:
00537922
Views:
14
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform