BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

What's going out with date format !!

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (Desktop)
View previous topic :: View next topic  
Author Message
PierreDa
Guest
PostPosted: Sat Jan 20, 2007 3:11 am    Post subject: What's going out with date format !! Reply with quote


Hi,

I have a program working well unsing native driver with sql 2000.

I ha to try it on my new machine with sql2500 ... and BDE Sad
So as there is no more native driver for SQL, I use ODBC.
No problem to configure and test the connection.

the problem is that now I have problem with date format.

I'm pretty sure that it is because I'm french talking and date muste be
"dd/mm/yyyy".
If I try a select using "explore" on the delphi query object, I saw the
correct date (french format)

If I break in the code when I retrieve the date
"qdata.fieldbyname('DateToUse').asDateTime" ... I receive "0" as the date
(surly because he received a wrong date).

I can't turn around.

Any help ?

My regianal settings are "french", and within bde I use (like always)
"Borland FRA Latin-1".

Again everything was working perfectly using BDE and Native driver to sql
server.

Regards

Pierre
Back to top
Bill Todd
Guest
PostPosted: Sat Jan 20, 2007 3:27 am    Post subject: Re: What's going out with date format !! Reply with quote


Your post should be in the bde or database.sqlservers newsgroup. This
group is for desktop databases like Access and Paradox.

Did you set the date format in the BDE Administrator?

--
Bill Todd (TeamB)
Back to top
PierreDa
Guest
PostPosted: Mon Jan 22, 2007 1:10 am    Post subject: Re: What's going out with date format !! Reply with quote


Oups .. sorry !
I haven't see the BDE newsgroup !! (and I have search for !)

YES, I set the date in BDE (and I also try all the format).
One thing ... I must be "honest" and say that I use Windows Vista RTM with
D2600.
I haven't problems with D2600, Vista and dbgo components (so using ADO).

Thanks

Pierre

"Bill Todd" <no (AT) no (DOT) com> wrote in message
news:45b137aa (AT) newsgroups (DOT) borland.com...
Quote:
Your post should be in the bde or database.sqlservers newsgroup. This
group is for desktop databases like Access and Paradox.

Did you set the date format in the BDE Administrator?

--
Bill Todd (TeamB)
Back to top
pedro mg
Guest
PostPosted: Wed Feb 07, 2007 11:36 pm    Post subject: Re: What's going out with date format !! Reply with quote
On Jan 19, 9:27 pm, "Bill Todd" <n...@no.com> wrote:
Quote:
Your post should be in the bde or database.sqlservers newsgroup. This
group is for desktop databases like Access and Paradox.

I have severall Delphi6 desktop apps, with BDE and Paradox tables
working fine from Win95 to Win XP.
Will i be having problems with Vista ?
What abou the Installer ?

Thanks in advance,
pedro t.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (Desktop) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.