Posts by debasisdas

Lets see what you have done so far.

R.I.P.

That sounds interesting ?

Welcome aboard.

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

whan you executed the rollack ?

When data in the source table changes all the dependent views will also change. so you need not try to update the views again.

This may help.

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

As already suggested you need to use some third party component and you have to decide that by browsing through the list of available components in net. While deciding the component a lot will depend on how much you are willing to spend.

So, what is the question ?

i tried with "explain" query but both saying same execution time.

Then there should be no difference.

Welcome to Daniweb.

Spread the word further.

u need just 5 minute to spend for registration

and registration is absolutely free, so always download from oracle site only.

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

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.

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.

Welcome to Daniweb.

Is that your own code ?

You have to frame the SQL at run time and execute the same using as dynamic SQL in a stored procedure.

Read more here and here.

Welcome aboard.

Most outgoing, vivacious and carefree girls who have more male friends are considered "loose" by those very males.

Yes, i also got similar error messages this morning.

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

plz tell me any third party component or liberary

Google it.

ours is not a free coding service.

you have to use third party components / libraries for the purpose

Are you trying to create or read bar code using your program ?

this is all the code that you have ?

Because of the pay check and all other benefits. :cool:

Else who hell will spend 10-12 hrs a day in front of a dumb machine. :-/

Folks who don't give feedback or just want homework done usually don't get any future questions answered ..

Yes, you got it right.

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

What is the table structure ?

What have you tried so far ?

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

try to debug the code.

use like in place of = in the where clause

move the following lines to form_load event
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient

close the recordset after populating the drid

Set DataGrid1.DataSource = rs

What about the SQL that you are working on ?

Show some effort to get any help.

Please read this.

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

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

Practically impossible to guess anything out of this.

Lots of Birthday wishes to Dani and free kisses :* for the gal.

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.

WHERE clause is not used for sorting in a SQL statement.

First of all you need to log in as admin user to run any script.

then use this only

select * from table 1 left join table 2 using (id)

else consider write outer join for non matching records.

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.

What query ?

Welcome aboard.

You need to read books for all that.

Read this and this.