search

x-ware-ltd / access-scc-addin

Microsoft Access SCC Addin
Apache License 2.0
2 stars 4 forks source link

insert/MSysSVNStatus broken #7

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
downloaded newst version
tested it with access 2002

problem:

export results in error 3346, beacause of:

INSERT INTO MSysSVNStatus (objType, objName, objImportVersion, objSVNChecksum, 
objImportDate, objStatusUnknown) VALUES (-32768, 'Formular1', '0', '0', 
41232,5960045718, True)

which has 7 data fields, but only 6 columns

Original issue reported on code.google.com by florian....@gmail.com on 19 Nov 2012 at 1:25

GoogleCodeExporter commented 9 years ago 
Florian, it looks like this is caused by your regional settings? The  import 
date is being represented as 41232,5960045718 using a comma. Whereas, I would 
expect it to be represented as 41232.5960045718 using a dot, this is messing up 
the SQL.

I have never tested it using other regions, but I am sure that it can be 
resolved. Leave it with me a while.

Original comment by steve.fa...@talkjcs.com on 29 Nov 2012 at 3:57

GoogleCodeExporter commented 9 years ago 
Updated in revision 35

The date formatting was messing things up. The SQL nows uses raw values rather 
than formatted values for dates internally. All issues to do with timestamps 
have been updated. Hoping that there are no more.

Original comment by steve.fa...@talkjcs.com on 29 Nov 2012 at 9:13