|
Yeah, that did it, thank you.
|
|
|
|
|
Hi All,
When I try to enter a command in any of the modules in a MS Access database, the command turns RED. It also constantly moves the cursorn to the left leaving NO spaces.
Trying to enter a command such as DoCmd. will open the popup window and then immediately close, and the DoCmd. turns RED.
Please tell me what is causing this. The database functions properly, but entering new code is a real pain.
Thanks
Gene
|
|
|
|
|
i have installed oracle9i..i want to know the host string to acces it through sqlplus..please provide me information about where can i found the host name in my computer...i caanot find it in tnsnames.ora file..could anyone give me guidance to find it
modified on Friday, May 23, 2008 4:25 AM
|
|
|
|
|
Hi everyone, Does sql server 2005 different with sql server 2008 or no?
Thanks
|
|
|
|
|
|
Yes.
^
Bob
Ashfield Consultants Ltd
|
|
|
|
|
how to insert username and password in table(sql server 2005)
with case sensitive.
so I can check small(abc...) and capital(ABC...) letters also while logged in.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Hi,
Just use UPPER & LOWER method during insert command in sql...
|
|
|
|
|
that is fine but it will be static in either small or block letters.
I want in, whatever user enter in small or block letter.
should not be changed internally.
thanks to give me response.
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Just insert teh values as suppplied, then when you are looking for them use
select *<br />
from table<br />
where convert(varbinary,username) = convert(varbinary,@inputvalue)
Using varbinary effectively makes the select case sensitive
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thanks a lot for your kind help.
it's also working fine.......
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Change collation to something case sensitive if you want to have case sensitivity.
|
|
|
|
|
Can I ask if this is correct.
Wince 5.0 has SQL3.0 (or SQL3.1 with the sp1) ?
What do you do for Wince 6.0? while using VS2005?
I had SQL3.0 working after the same old problem that everyone else has had with the P/invoke error. (VS2005 didn't copy the cabs into the correct directory - Deploy error) also sqlceme30.dll wasn't in the windows directory.
Fixed....
No problemss...
Yeah right, I got a new machine with wince6.0 on it.
Back to square one!
Now, it doesn't matter what I do, the same error keeps comming up 'P/invoke cant find sqlceme30.dll'.
I did notice that when you manually install the .cab files (sqlce30.wce5.armv4i.cab and sqlce30.repl.wce.arm4vi.cab)they say that 'this is not the compatable software platform, do you want to continue?'
Is this an incompatability with wince6.0?
Am I meant to use sqlce3.5?
Isn't this only in VS2008?
Is there another way around this or do I have to upgrade to VS2008?
Please help 
Thanks,
Rob.
|
|
|
|
|
Hi
how to conver string to date not in date time format.
means
like I want to convert this string(15 may 2008) '15/05/2008' in date format.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
The date is not stored in a specific date format in the database, but to do what you have asked:
select convert(varchar,convert(datetime,'15 may 2008'),103)
Bob
Ashfield Consultants Ltd
|
|
|
|
|
not like that
I want finally in date format not in string format.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Then just use a DateTime with a "00:00:00" for the time representation, because you can then just convert it to a string when you need it as shown by the previous poster.
|
|
|
|
|
that's fine but what I want see
varDate is "2008-05-09 21:24:58.407" now I want to get record as per date(2008-05-09)without time but not getting.
select *from tblName where varDate='2008-05-09'
not getting any record
I have stored date with time also.
I tried this also
select *from tblName where varDate like '%2008-05-09%'
ans:saying can not be converted string to date
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Well try using a little logic then. It is obviously failing because you have the time included on the database.
select * from tblName where convert(datetime,convert(varchar,getdate(),103)) = convert(datetime,'05 may 2008')
Bob
Ashfield Consultants Ltd
|
|
|
|
|
not working
You get the best out of others when you give the best of yourself.
|
|
|
|
|
trilokharry wrote: not working
Very useful comment.
If tahts all you can say how can anyone help you - or why should anyone bother? 
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I mean I am not getting my requirement.
your code working fine.
sorry for previous comment.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Well exactly what IS your requirement? As far as I know, myself and others have answered your original question (such as it was)
trilokharry wrote: like I want to convert this string(15 may 2008) '15/05/2008' in date format.
As a final suggestion, try this.
select * from table where CONVERT(VARCHAR(20),vardate,106) = '15 may 2008'
Otherwise explain EXACTLY what you want. The database does not really care what format your date is in as it stores it as a number anyway.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thanks
now it's working fine
You get the best out of others when you give the best of yourself.
|
|
|
|
|
In his first post I was confused and I didn't figure out what excatly he wants.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
