| View previous topic :: View next topic |
| Author |
Message |
cdgidev
Novice
Joined: 25 Feb 2009
Posts: 4
|
 Posted: Wed Feb 25, 2009 6:33 pm Post subject: Problem with SQLDateTimeFormat not being respected |
 |
|
I have problems with the SQL Date time format property. I specify the format as "YYYY-MM-DD hh:mm:ss" in the following code and it is not taken into account, instead it uses the regionnal settings and this messes up my software in different regionnal setting environment not using hypehsn as the seperator.
| Code: |
FilterEditor.LoadTitlesFromFile App.Path & "\filtereditor-" & IIf(LanguageProvider.Language = Francais, "fr", "en") & ".ttl"
FilterEditor.FullTableNameFormat = "TABLE" 'Make sure only table names are generated in the query, exclude DB and Schema
FilterEditor.OptSelectDistinct = False
FilterEditor.OptShowCheckBoxes = False
FilterEditor.OptShowGroupName = True
FilterEditor.OptSortByNames = True
FilterEditor.OptStoreDBInfo = False
FilterEditor.QuoteDate = True
FilterEditor.QuoteBool = True
FilterEditor.QuoteSymbol1 = "["
FilterEditor.QuoteSymbol2 = "]"
FilterEditor.SaveTitles = False
FilterEditor.SQLDateTimeFormat = "YYYY-MM-DD hh:mm:ss"
FilterEditor.SQLDateFormat = "YYYY-MM-DD"
FilterEditor.SQLTimeFormat = "hh:mm:ss"
|
Please help me find a workaround... |
|
| Back to top |
|
 |
cdgidev
Novice
Joined: 25 Feb 2009
Posts: 4
|
| Posted: Wed Feb 25, 2009 7:27 pm Post subject: |
|
|
I think i have found my problem and it has nothing to do with the control in itself...
The problem is within the second form and had a different dattime format. It fixed it at work, sending a copy to my client to see if it fixes it's problems... |
|
| Back to top |
|
|
|
: Community forums
FAQ
Search |
Register
Profile
Log in to check your private messages
Log in
