Posts by debasisdas

try this

sqlselect = "SELECT * FROM word_name WHERE ekigambo = '" & writetext.Text & "' OR word= '" & writetext.text & "'"

You need to update the record separately in another SQL.

Check if the oracle service and listener services are up and running.

Also ensure that the account is unlocked and has permission to connect to he database.

552

You have mistyped the common dialog control name.

should be cDialog not dialog.

It will come from cache if the data in the table did not get changed between your select and create as select statements.

To ensure that the number of records are >0 use
select count (*) not select *

556

558

@Kraai

What are you doing online so early in the morning.

go and sleep again. :)

Tyr using this SQL.

sqlselect = "SELECT * FROM word_name WHERE word = " & writetext.Text

562

564

@debasisdas: You are not answering the question.

I didn't get you.

568

You did not respond to my request for your working code.

You need to copy only the table data rather than entire table.

Please read more here.

572

You need to store the payment details in a single table with a payment type flag that specifies what type of payment that was.

Warriors bring Kings XI to knees.

The following two SQL is syntactically wrong, and needs to be fixed.

SELECT* FROM word_name WHERE word OR ekigambo=""

UPDATE ekigambo,dest_lug,word,eng_trans WHERE

Malinga too hot for Daredevils.

Even if login is a key word, since it is wrapped with [] there should not be any problem.

check for any mispelled or spaces in the column name.

Better to try using a different name as suggested by Jx.

572

can i view only 2 column in listview, example only column 1 & 2 only in listview..

Yes

if i remove code in line 5 and 6 i will get error...

why ?

If you want to display only 2 columns why you need to add code for 4 columns ?

It may happen my table contains 200 columns but not compulsory to display all the columns.

572

568

572

While the defending champions proved themselves .newly formed teams are struggling.

570

570

554

What exactly is the nature of transaction that you are going to execute on this data base ?

554

I think this discussion is good for your reference.

554

554

558

562

I know you are in a hurry but would you mind showing the code that you are working on.

566

Indian Premier League -IPL as it is popularly known as in the cricketing world starts this evening. This is the 4th edition of the cricketing extravaganza.

With India winning the ICC world cup last week, global feast is over, time for clubbing.

Defending champions Chennai Super Kings takes on new look Kolkata Knight Riders in the opener.

570

574

578

I can't see the block of the code that you are referring to in the code that you have posted here.

Your question was in MySQL or MS SQL ?

You need to read this for more details on MySQL version of the question.

Your question was in MySQL or MS SQL ?

You need to read this for more details on MySQL version of the question.

582

Have you tried using the MM control ?

586

586

586