debasisdas

Hi, Welcome to Daniweb. Hope you have a nice time learning new stuff here.

welcome aboard.

welcome aboard.

before inserting any record into the table take a count of records [CODE]Select count(*) from users where id = "txtid.Text"[/CODE] proceed only if the count returns 0

What is the code that you are working on ?

You can use either crystal report or form. To display in Vb forms , you need to use Move methods of the ADO. To display CR , you need to insert page brakes after each record.

Both are same and refer to similar kind of job. Just a different terminology.

go and read books

What button you would like to add ?

dates are in which file ,is it in a database ?

You need to look into the property pallet of the control, and refer to the property mentioned in the previous post.

What about storing the voting time in DB and allow the user to vote again only after 24 hrs.

Any tool that supports reverse engineering should do that for you. Try using MS Visio for the purpose.

changing the data type of a field is a bad idea.

The solution in the link will work if you are using some of the basic controls like a textbox and buttons. Other wise backward compatibility is not supported on most of the applications.

Do you have both the OCX files with you ?

[URL="http://social.msdn.microsoft.com/Forums/en/vssetup/thread/2044f33a-6f8d-4dae-950d-4019d7eeb3e6"]This[/URL] may help.

since you have only 2 fields try the following. 1. [CODE]CREATE TABLE Mytable_New AS SELECT ESN, min(Shipdate) FROM Mytable group by ESN, Shipdate;[/CODE] 2. Drop the table Mytable. 3. Rename Mytable_New to Mytable.

Use distinct.

From MsSQL export data into a .csv file and use SQL Loader to load the same into Oracle. source and destination table fields should be compatible.

What exactly you mean by [B]startup is very slow[/B] ?

I am not sure if Shell supports that file extension.

try this [CODE] Form2.WindowsMediaPlayer1.URL = "c:\Users\lapi\Desktop\DOWNLOADED\365.wmv"[/CODE]

[QUOTE=burntout;1606240]On both links it told me it should be 5.1 or 5.2, actual 6.0? [/QUOTE] What are you talking about ?

[B]ds[/B] refers to what ?

I do not know about what you are trying to say, please let me know.

Lets see your code that you are working on and fix it.

what is the code that you are working on ?

You need to contact the vendor of API.

You need to schedule that using Event Scheduler. Create a procedure to delete the desired records and schedule the same. please read more [URL="http://ushastry.blogspot.com/2009/09/mysql-event-scheduler-or-scheduled.html"]here[/URL] and [URL="http://dev.mysql.com/doc/refman/5.1/en/events-overview.html"]here[/URL].

How you populate the data grid ? is it from database ?

When you say synchronize, what exactly you are trying to do ? How many records ? Do you still want to use both the DB afterwards ?

Try using DATE ADD()----add 7 days and then use [B]%W[/B] for mat to extract the day o use [B]DAYNAME(date)[/B] [CODE]SELECT OrderId,DATE_ADD(OrderDate,INTERVAL 45 DAY) AS OrderPayDate FROM Orders[/CODE]

Just refer to the standard EMP and DEPT tables of SCOTT schema. Try to analyze that , you will be able to write your own.

That version of the software is de-supported for over a decade now so is not available any more. It was not a freeware.

When the event [B]Label1_Change()[/B] fires, as you are not changing the Caption of the label1 any where other than the change event of itself.

try this [CODE]SELECT parent.MEMBER_ID, parent.lname, COUNT(child.MOVIE_ID) FROM parent left join child parent.MEMBER_ID = child.MEMBER_ID GROUP BY parent.MEMBER_ID,parent.lname;[/CODE]

You need to use ADO , please find the connection string [URL="http://www.connectionstrings.com/"]here[/URL].

CHECK(Status IN('OPEN',"CLOSED'))); replace " with ' -- in above line.

add a semicolon at the end of procedure call. insert_reorde_pp (:NEW.isbn);

Welcome aboard.

Welcome aboard. I hope Daniweb will benefit from your knowledge.

How the data is stored ? Is it in any database or any other file format ?

Replace the comma with space in the string and then use LIKE search.

What is the question ?

you just need to run the counter backwards. (-1)

I think your data is not proper. also change the following line to IF lv_shipdate_date = NULL IF lv_shipdate_date IS NULL

You need to mention the exact problem, what is not working ?

Have you tried using SendKey {BREAK}

Does that involves a complex query or fetching too many records ?