PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 23 → 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
Membre enregistré
4 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
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
Membre enregistré
4 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
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
Membre enregistré
4 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,