FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV 2024
→
OLEDB & HYPERFILE DB Column Date problem
OLEDB & HYPERFILE DB Column Date problem
Débuté par PROGRAMMER / TheProg, 01 juin 2018 19:45 - 4 réponses
Connectez-vous…
PROGRAMMER / TheProg
#1
Membre enregistré
9 messages
Posté le 01 juin 2018 - 19:45
Hello,
I have a file with "date" (yyyymmdd) column in Hyperfile.
I am not able to via VB6 update the date column, always gives me errors...
I've tried several formats.
Is there any non-standard specific formatting of OLEDB for this type of column?
All other fields I update without any problem.
Thanks
Signaler
0
0
Fabrice Harari
#2
Posté le 03 juin 2018 - 23:40
Hi
first it depends of the SUBTYPE of the field...
If it's date/date, then you should send a simple string with YYYYMMDD
But of course, without seing the code and without having the text of the
error, there is no way to help you more than that
best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Free Video Courses, free WXShowroom.com, open source WXReplication, open
source WXEDM.
More information on
http://www.fabriceharari.com
On 6/1/2018 11:45 AM, PROGRAMMER / TheProg wrote:
Hello,
I have a file with "date" (yyyymmdd) column in Hyperfile.
I am not able to via VB6 update the date column, always gives me errors...
I've tried several formats. Is there any non-standard specific
formatting of OLEDB for this type of column?
All other fields I update without any problem.
Thanks
Signaler
0
0
PROGRAMMER / TheProg
#3
Membre enregistré
9 messages
Posté le 05 juin 2018 - 12:26
hello,
DataType = adDBDate = 133
(
https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/datatypeenum…
)
The problem happens with all numeric fields.
"Row cannot be located for updating. Some values may have been changed since it was last read."
Same problem using Powercobol or VB6.
This problem is widely spoken on the Net. I've tried various settings, but always without success.
Thanks
Signaler
0
0
Fabrice Harari
#4
Posté le 05 juin 2018 - 15:12
Hi,
I was talking about the type on the Hyperfile side and that ...DataType
= adDBDate = 133... is not it
And now you are talking about a numeric... if on the hyperfile side it's
a date/date then it is a STRING, not a numeric
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
Free Video Courses, free WXShowroom.com, open source WXReplication, open
source WXEDM.
More information on
http://www.fabriceharari.com
On 6/5/2018 4:26 AM, PROGRAMMER / TheProg wrote:
hello,
DataType = adDBDate = 133
(
https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/datatypeenum…
)
The problem happens with all numeric fields.
"Row cannot be located for updating. Some values may have been changed
since it was last read."
Same problem using Powercobol or VB6.
This problem is widely spoken on the Net. I've tried various settings,
but always without success.
Thanks
Signaler
0
0
PROGRAMMER / TheProg
#5
Membre enregistré
9 messages
Posté le 05 juin 2018 - 17:31
LOL
If you knew this definition (adDBDate = 133), you easily knew how it was in Hyperfile!
look at this:
https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/datatypeenum…
My teste:
in hyperfile
lDate ---> type "Date" (yyyymmdd)
lPrice ---> Decimal, Integer part: 10 Decimal: 3
Try to make an example with these two fields and update via OLEDB / ADO !!!
But I know you can't solve the problem.
Regards,
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte