Posts by debasisdas

Photography is my passion.

try this sample query

insert into temp values(101,'vijaya''s');

hope that solves your problem.

hi folks,
i want some help with dlls

i want to create dll which will take image file path as input string do some processing, and five different strings as output.
how to use it.

can anyone give sample code

thanks

What exactly is your requirment ? What is the processing you want the code to do and what the 5 output strings contains ?

If you are trying to store value retrived from database then try to use

x=DE.rsPegawai!NmPeg

We will either find a way, or make one !

Try to create the view using simple where clause for checking the PurchaseDescription field and change the other fields accordingly.

You simply need to join the tables to get the desired output. Try from your side and post the query that you have tried to get further clarification on the topic .

This problem is because you are trying to create two objects by same name. You are creating a column and a constraint by the same name with in a table . this why u are getting this error . Try to use different name for the coumn and the constraint.

The wise only speak when they have something to say. Fools speak, because they have to say something.

Marquee is used in webpages . to et the same effect create a gif image with the Marquee text and add thet to the status bar in a particular pannel.

In spite of everything that was done to me and my race, in spite of the adversity and the bitter moments, again we rise.

The superior doctor prevents sickness;
The mediocre doctor attends to impending sickness;
The inferior doctor treats actual sickness.

A diplomat is a man who remembers a lady’s birthday but forgets her age.

He who wishes to be rich in a day will be hanged in a year.
- Leonardo da Vinci

Then you only need to change the connection string.

Nobody remembers who came in second.

This code is written assuming you are using Oracle and ADO to connect to database.

Dim Con as new ADODB.Connection
Dim Rs As New ADODB.Recordset

Con.ConnectionString = "Provider=OraOLEDB.Oracle.1;Password=tiger;Persist Security Info=True;User ID=scott;Data Source=das"
If Con.State = 0 Then
Con.Open
End If

 
Dim SQLName As String
CboName.Clear
SQLName = "SELECT NAME FROM ENGINEER"
Rs.Open SQLName, Con, adOpenDynamic, adLockOptimistic
Set CboName.DataSource = Rs
For i = 0 To Rs.RecordCount - 1
CboName.AddItem Rs(0)
Rs.MoveNext
Next i
Rs.Close

Hope it solves your problem.

Kindly mention what is the databse you are using and how you are trying to connect the control to the database.

Actually ADO and DAO are totally different technologies. DAO is much older in comparision to ADO,which is the best technilogy as per performance and security that is available in VB 6.0. theya re not compartible with each other. so if you wna to change your cod efrom DAO to ADO u need to do so manually.

No man is fit to command another that cannot command himself.
William Penn

I get paid for every line of code by my company . So no chance of supplying free coding to any one . BTW how do you expect someone else doing your home work / assignment for free in a open forum like this.

Resolve to pay any price or make any sacrifice to get into the top ten percent of your field. that payoff is incredible!

I am glad to know that you found the solution before i do that for you. Happy programming.

That might be because of the driver is not installed properly.

try to use the following

Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=orcl;Persist Security Info=True

I was nauseous and tingly all over. . . . I was either in love or I had smallpox.

Its nice to know you got the acurate solution of the problem and your problem got solved.

Thanx for shairing the info .the book is really useful. I have already gone throught that one.

The logic is so simple .This can be implemented at the database level it self by using SQL statments. When the user tries to login check for existance of such an user with the corresponding password . If the user exists then go further.

To check for existance try to follow the sample SQL

SELECT COUNT(*) FROM USER_TABLE_NAME WHERE USERNAME='DEBASIS' AND PASSWORD='DEBASIS'

If the sample query returns 1 then login else display a message like invalid username or password.

Use join to retrive record from both the tables by joining on CUST_NUM field. then use group by.

try to use this as connection string.

Provider=OraOLEDB.Oracle.1;Password=tiger;Persist Security Info=True;User ID=scott;Data Source=orcl

hope that solves your problem.

do what ever you like.

Yo Papa ---> Yo dad

-351

3209

4151

dude

Nice explanation.

If I advance, follow me! If I retreat, kill me! If I die, avenge me!

If you are using crystal report viewer to display the crystal report just enable the export button from the property pallet of the crystalreport viewer.

Be not afraid of greatness; some are born great, some achieve greatness, and others have greatness thrust upon them.

William Shakespeare

A man never stands as tall as when he kneels to help a child.

Man was designed for accomplishment, engineered for success, and endowed with the seeds of greatness.

The time is always right to do what is right.

Positive thinking won't let you do anything but it will let you do everything better than negative thinking will.

Ninety-nine percent of all failures come from people who have a habit of making excuses.

If you can't accept losing, you can't win.

Kindly post what you have done so far. Post where you are struck.

No way you can trap the events of Win Key using Vb 6.0. that is a special key for which microsoft provides no methods to handle that.

First you need to establish the connection witht he database. Then only you can execute some SQL commands for all the operations.

The best way to prepare for life is to begin to live.