|
| OLEDB & HYPERFILE DB Column Date problem |
| Iniciado por PROGRAMMER / TheProg, 01,jun. 2018 19:45 - 4 respuestas |
| |
| | | |
|
| |
Miembro registrado
9 mensajes |
|
| Publicado el 01,junio 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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,junio 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 |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
9 mensajes |
|
| Publicado el 05,junio 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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,junio 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 |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
9 mensajes |
|
| Publicado el 05,junio 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, |
| |
| |
| | | |
|
| | | | |
| | |
|