PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → OT : no decimals out of Pervasive file with SQLGetCol
OT : no decimals out of Pervasive file with SQLGetCol
Débuté par Teun van Unen, 09 juin 2005 18:28 - 1 réponse
#1
Posté le 09 juin 2005 - 18:28
Hello,
I am converting Magic/Pervasive (reading by Pervasive.SQL V8 OLE DB) to WinDev/HyperFile :
- The browse program shows the decimals with a 'normal' SELECT.
- The conversion program however did not take the decimals. In that program I use the SQLExec followed by a SQLFetch and then SQLGetCol for each field e.g. :
AA93_ProjectInzetBoekingen.Aantal = SQLGetCol("QRYBoeking", 11)
There are no compile nor runtime errors.
I have that problem with all that kind of fields.
Who knows the answer or can give a hint?
TIA, Teun.
#2
Posté le 10 juin 2005 - 11:41
Hi Teun,
Try an intermediate step:
x is string
x=SQLGetCol("QRYBoeking", 11)
AA93_ProjectInzetBoekingen.Aantal = val(Replace(x,",","."))
Regards,
Piet
→ Revenir à WINDEV 2024