Posts by debasisdas

Then go and read books and any online material that you can find, that will really help

in which tool ?

Hi Shikha,

Welcome to Daniweb.

Hope you have a nice time here.

did you hit any search engine with the desired keywords ?

FYI--login screen code in inbuilt to VB 6 IDE, you simply need to modify that as per your requirements.

select count(*) from table1 where name= 'john'

will do that for you.

Sorry dear,

We do not solve assignments / home works for you.

You need to do that yourself.

FYI-- asking for code without showing any effort is against forum rules.

sorry, we do not solve assignment / home works here.

You need to do that your self.

There are enough material available online and u have sufficient time to learn and do that yourself.

i really do not understand what you are trying to do.

the query is doing exactly what is it is written for.

what is the code that you are working on ?

that did not answer my question.

what is the input string (without any function) for the expected output---Harry.E

i.e.----is it something like harry e

so what is the problem ?

Hi,

Welcome to Daniweb.

Hi paul,

Welcome to Daniweb.

Do you predict results by any chance :)

check this.

What is the code that you are working on ?

Which version ?

check the details here.

what is the input for the expected output ?

Why not handle that part using SQL.

Checking data in a loop is going to kill the performance.

Hi ,

welcome to Daniweb.

Hi Raim,

welcome to Daniweb.

To call form2 you must to make an object of form2 :

Dim Myform as New Form2
    Myform.show

NOTE:---Please start a new thread for a new question.

to which property of the object you are assigning that string ?

Try using this.

public myform as Form
 myform = New Form1
call thisisasub(myform)

Check if the file open while you are trying to write to it.

Simply because you are taking the count after adding more records.

Hi Arda,

Welcome to Daniweb.

have you tried using the NEW keyword.

please go through this , this and this.

check if your query satisfies any condition.

what is the data type of target variable ?

it gives 0.04890
And i think it should be 0.04890

If you are getting what is expected, what is the problem ?

how i will know what data is in the .csv file

can u post some sample data here.

kindly post your complete SQL statement.

check if the path is proper (properly check for that date part in your path).

also check if any file already exists in the location by the same name.

modify your .net code and ensure that you get the above SQL before executing the same.

try this

INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES (505056,'CPU',15000, 1,'RAM', 1200,1,'KEYBOARD',1500,2,'','','','','','','','','','','','',' ','','',' ','','',' ','','','BACKUP',to_date('06/03/2011 11:41:43','mm/dd/yyyy hh24:mi:ss'),'IT Support')

and fix all that missing single quotes from your .net code.

If you are getting syntax error what is fine then ?

what happened to all those single quotes, why are they missing ?

That should work, ensure that you are using where clause on the proper column.

Also check if the column contains any white spaces.

the error message is self explanatory

Hi Alan,

Welcome to Daniweb.

@zebnoon

can you please rephrase your last question.

May be you can store system shutdown time into registry or any other location and read the same on system start up. If the difference is < 30 mins call the shutdown routine again.

If you are opening the picture in any browser, check for zoom settings.

Did you really go to the link,..........
You did not see the game appear...........
didn't you read the author's comments?...........
Nevermind, you can play the other games,.............
Look, the game .........

But i don't understand why you want everyone to open that link.

If are really a student and want to learn, then stop posting SPAM repeatedly.

After opening the link only one will know what you have posted here.

If you are deliberately posting SPAM, may be its time for some moderator to handle the case.

Proving that he posted SPAM.

what have you done so far ?

Do you have any code that you are working on ?

I'm in charge...

you misunderstood that :D

what exactly you are storing in the table ?

table structure please.