debasisdas

Find more [URL="http://www.google.co.in/search?tbo=p&tbm=bks&q=intitle:Beginning+intitle:Database+intitle:Design&num=10"]here[/URL].

You can't.

R.I.P.

Lets see what you have done so far.

[QUOTE=selman0;1658386]u need just 5 minute to spend for registration [/QUOTE] and registration is absolutely free, so always download from [URL="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html?ssSourceSiteId=ocomen"]oracle site[/URL] only.

Do you know how that .DLL works ?

You have to read books for answer to all these basic questions.

whan you executed the rollack ?

Yes, i also got similar error messages this morning.

[QUOTE=prem2;1659641]i tried with "explain" query but both saying same execution time. [/QUOTE] Then there should be no difference.

Why RFID is required for Library management system ?

try this 1. add the column pad to all the views. 2. join the views to select all the desired columns on pad. without join the record will be a Cartesian product so the number will be huge.

Why are you storing number as characters why not as numbers ?

300 columns and 3 million rows is not that huge as it sounds. Any standard RDBMS application would do that. To decide the database a lot would depend on how much you can spend on the DB and server(hardware).

Have you coded all that or simply referring to a piece of code compiled by someone else ?

ours is not a free coding service.

[CODE]If DateDiff("d", Now, "9/2/2011") =< 0 Then MsgBox "the software has been expired." Unload Me End If[/CODE]

None of those are generic Oracle syntax. Those are either OS or environment setting commands. If you are not understanding anything it is you, not the professor to blame.

You have to frame the SQL at run time and execute the same using as dynamic SQL in a stored procedure. Read more [URL="http://www.rocket99.com/techref/sybase8621.html"]here[/URL] and [URL="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35570.1550/html/clcprgde/X80489.htm"]here[/URL].

Nothing comes free in life. If you are trying to do, that is illegal in country.

[QUOTE=mb01a;1654989]Folks who don't give feedback or just want homework done usually don't get any future questions answered ..[/QUOTE] Yes, you got it right.

What is the table structure ? What have you tried so far ?

It will be easy to do the same at database level.

do you how to fetch first 5 records from a table using SQL in MySQL ?

what is the table structure and lets see what you have tried so far.

Practically impossible to guess anything out of this.

Which dbms ?

This is what happens when you supply the code to someone without him showing any effort at all. Forget of feedback, i seriously doubt if that guy remembers this thread and is ever going to return back read to your answer.

You need to use the function RUN_REPORT_OBJECT [CODE] DECLARE repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status varchar2(20); BEGIN repid := find_report_object('report4'); v_rep := RUN_REPORT_OBJECT(repid); ...... END; [/CODE]

you need to call label_click event in the Key press event.

The 3rd and 4th column of your output clearly shows, this output is not of the query that you have posted here. Please recheck.

Please read [URL="http://www.snaphow.com/make-windows-welcome-you-with-audio-voice-messages-with-narrator/"]this[/URL].

Welcome aboard.

1. You need to frame the query dynamically at run time by taking parameter from the input. 2. Open the record set using the sql. 3. Populate the grid from the recordset. 4. If record count is 0 display the alternate message.

Every user logs in into its own schema. Did you log in through an admin account and tried to grant admin role to the user ?

You need to read books for all that. Read [URL="http://books.google.co.in/books?id=21FthymRusoC&printsec=frontcover&dq=vb.net+2010&hl=en&ei=AnF5TteeA4mqrAfpktSyDw&sa=X&oi=book_result&ct=result&resnum=2&ved=0CEAQ6AEwAQ#v=onepage&q&f=false"]this[/URL] and [URL="http://books.google.co.in/books?id=unV37pUZdpQC&printsec=frontcover&source=gbs_ge_summary_r&cad=0#v=onepage&q&f=false"]this[/URL].

then use this only [CODE]select * from table 1 left join table 2 using (id)[/CODE] else consider write outer join for non matching records.

try like this [CODE]select * from table_name where ( event_start between 13/8/11 and 15/9/11 ) and (event_end between 13/8/11 and 15/9/11)[/CODE]

Welcome aboard.

try this query [code] CREATE VIEW TopLevelCust AS SELECT Customer.CustomerNum, Customer.CustomerName, Customer.Street, Customer.Balance, Customer.CreditLimit FROM Customer WHERE CreditLimit >= 10000;[/code]

you need to handle the [B]key ascii[/B] in [B]Key press[/B] event

1. Select the distinct value from the column Car Manufacturers and display in the first List Box. 2. Select the value from the first List Box. 3. Pass this value to another SQL dynamically at run time. 4. Fetch the values from the SQL and populate the second List Box.

The developer has used an evaluation version of a third party control. And since the evaluation period has expired, so you can't keep using that any more.

error.

You need to connect VB to oracle and insert the data into oracle tables.

Lets see the code that is throwing the error.

As already suggested no need to install Access if it is used as database only. Having the .MDB file only is enough.

You need to keep tracking all the records.

What is stored in the database ? The path of the physical location of the picture file or the actual picture ?

More information is required to answer your question . Which report ? What is the source of data ? ................ ?