Database

Re: Selecting a row with least creation time without using top

6-Mar-14 4:00

Kornfeld Eliyahu Peter wrote:
Why not using order by and top?

Just a guess; "it's too slow"

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Kornfeld Eliyahu Peter6-Mar-14 4:10

Re: Selecting a row with least creation time without using top

6-Mar-14 4:10

And nested select not? It's performance depends only on the proper indexing...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Eddy Vluggen6-Mar-14 6:12

Re: Selecting a row with least creation time without using top

6-Mar-14 6:12

Kornfeld Eliyahu Peter wrote:
And nested select not?

I did not say that Smile | :)

Kornfeld Eliyahu Peter wrote:
It's performance depends only on the proper indexing...

..and the amount of records, the amount of fields in a row, their size, and the speed of the harddisk.

Ya reckon there's an index on the date? Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Kornfeld Eliyahu Peter6-Mar-14 6:30

Re: Selecting a row with least creation time without using top

6-Mar-14 6:30

Eddy Vluggen wrote:
and the amount of records, the amount of fields in a row, their size

Not quiet right... With indexed table there will be two page reads only (and if the index clustered only one), not matter what size the table is...

Eddy Vluggen wrote:
Ya reckon there's an index on the date

I do not think there is a table at all - it sound me like a school exercise...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Simon_Whale6-Mar-14 6:07

Simon_Whale

6-Mar-14 6:07

Damn you Eddy you made try to learn something today!

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

Re: Selecting a row with least creation time without using top

Jörgen Andersson6-Mar-14 12:01

Jörgen Andersson

6-Mar-14 12:01

Maybe it's just not for an SQLserver. If you want a generic query TOP is out of the question.

Wrong is evil and must be defeated.
- Jeff Ello[^]

Re: Selecting a row with least creation time without using top

Eddy Vluggen6-Mar-14 8:31

Re: Selecting a row with least creation time without using top

6-Mar-14 8:31

Create a table called "Cheater", containing both PatientId and last updatetime. Set both from a trigger on the Patient-table - do an insert of it doesn't contain the patient-Id, otherwise simply update the time.

Index the table on time, id.

You now have an indexed int/date table for your lookup.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Yes Yes Yes7-Mar-14 2:30

Yes Yes Yes

7-Mar-14 2:30

Hi,

I am a user of MySql. In Mysql we can go for the query

select * from Patient where time=(select max(time) from Patient);

Hope it will work for you. Check n update.

Insufficient privileges : Dynamic View Creation ORACLE

prathameshpitale5-Mar-14 1:06

prathameshpitale

5-Mar-14 1:06

Hello,
i have two user schemas.
Let's Say A & B.
A has a procedure written in it SAY 'XProc'.

B has a package which has Procedure say 'B_Pack_Proc', which creates a dynamic view in B user schema.

The B_pack_proc creates view in B schema itself.

but i am executing the B_Pack_Pro from A, i am getting error insufficient privileges.

I am using oracle forms 11g and oracle DB 11g.

i have granted explicit grants to User A from User B
i.e Create any view
Execute on view.

please help.

-
Prathamesh

Re: Insufficient privileges : Dynamic View Creation ORACLE

Jörgen Andersson5-Mar-14 2:58

Jörgen Andersson

5-Mar-14 2:58

Have you given user A privileges to execute the package?

SQL

GRANT EXECUTE ON B.packagename TO A;

Wrong is evil and must be defeated.
- Jeff Ello[^]

Re: Insufficient privileges : Dynamic View Creation ORACLE

prathameshpitale5-Mar-14 23:23

prathameshpitale

5-Mar-14 23:23

i have explicitly granted permission on the view, package and the tables in the views.
still not working

-
Prathamesh

Re: Insufficient privileges : Dynamic View Creation ORACLE

Jörgen Andersson5-Mar-14 23:58

Jörgen Andersson

5-Mar-14 23:58

What's the exact error message?

Wrong is evil and must be defeated.
- Jeff Ello[^]

MS ACCESS ODBC Problem

Aravinth Spirited1-Mar-14 7:28

Aravinth Spirited

1-Mar-14 7:28

I created a table in ms access, and then i wanted to connect it to a java gui front end using type 1 driver. so i tried to create an odbc dsn for access. the test for connection failed while creating the dsn itself. Any suggestions will be extremely helpful, thanks.

Re: MS ACCESS ODBC Problem

Eddy Vluggen1-Mar-14 9:02

Re: MS ACCESS ODBC Problem

1-Mar-14 9:02

Aravinth Spirited wrote:
the test for connection failed while creating the dsn itself. Any suggestions will be extremely helpful, thanks.

Did the test fail silently, or was there an error-message?

I suggest you add that message to your question.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

CHill601-Mar-14 10:59

CHill60

1-Mar-14 10:59

Please don't cross-post across forums - Quick Answers MS ACCESS ODBC problem[^] - it won't get your question answered any quicker!

Re: MS ACCESS ODBC Problem

kmoorevs1-Mar-14 11:44

kmoorevs

1-Mar-14 11:44

Use a DSN-less connection like OLEDB. It is much faster than ODBC anyway.

"Go forth into the source" - Neal Morse

how do I need to create a module for mysql command handler ?

Santhoshpettacode26-Feb-14 18:22

Santhoshpettacode

26-Feb-14 18:22

When there is case for writing a many number of mysql command line in VB.NET programming to how to write the module or dll file to handle easily all the command .Please suggest other weblinks or code project article in this discussion. If there is any further idea also add to this discussion.
Online Mysql with VB.Net Smile | :)

Re: how do I need to create a module for mysql command handler ?

Mycroft Holmes26-Feb-14 19:28

Mycroft Holmes

26-Feb-14 19:28

Sounds like you are trying to build a Data Access Layer (DAL), there are many articles and examples on this subject.

Never underestimate the power of human stupidity
RAH

Re: how do I need to create a module for mysql command handler ?

Santhoshpettacode26-Feb-14 21:02

Santhoshpettacode

26-Feb-14 21:02

Thanks for your replay can you please suggest me the better links to refer that will help me to create my own DLL file .

datetime problem

Member 1026351925-Feb-14 20:45

Member 10263519

25-Feb-14 20:45

Hi,

am developing application in .net,c#.

am saving datetime value as: yyyy-MM-ss HH:mm:ss (24 hour format)
after saving in database i observed in database , it's stored in specified format .

and here the problem is:

when i retrieve data , datetime is coming as 12 hour format.
what to do........

Kornfeld Eliyahu Peter25-Feb-14 21:25

25-Feb-14 21:25

When you store date/time AS date/time in database you store some binary (like milliseconds since 1st of January 1970). Database do nothing and care less about the representation of that date/time. You have to look into the code to see where the problem (you may have locals with 12 hours).
If you store date/time as string - you do a big mistake!!!

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Member 1026351925-Feb-14 22:39

Member 10263519

25-Feb-14 22:39

it's ok, but how to add milliseconds.

actually, in c# am using DateTimePicker control.this will give only (year-month-date hour:minutes:seconds)

it doesn't support milliseconds.

so , Is there any way to get the data stored in database as it is.(24 hour format)

Kornfeld Eliyahu Peter25-Feb-14 22:44

25-Feb-14 22:44

You didn't read or didn't understand what I've told - database do not store date/time in any format but binary!!!

For proper formatting in your DateTimePicker go to the help of that specific control...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Bernhard Hiller25-Feb-14 22:46

Bernhard Hiller

25-Feb-14 22:46

You store DateTimePicker.Value, not DateTimePicker.Value.ToString() or DateTimePicker.Text. Also make sure that you set the display format of the DateTimePicker to the format you want to see.