tomato.pgn commented: Nice work!!! +5
debasisdas 580 Posting Genius Featured Poster
496
500
500
496.
496
496
what happens when you comment this line
sd.InitialDirectory = "C:\"
and then try to create the file by browsing the file dialog ?
In this case important question is what are going to do with all those data .
494
Your PK should be based on the combination of
booking_code and type.
494
494
why the fields
name
buying price
are repeating in both the tables ?
are you trying to create something like inventory management, where you maintain the incoming and outgoing stock and finally prepare reports on the transaction on periodic basic ?
496
500
MCA from Sikkim Manipal University is good option for working professionals like you.
Yes age will be a factor, only if you are interested in big MNCs.
And the other concern will be any gap in education, because most of the IT farms opt for 16 years of continued education. Local companies may ignore that.
500.
500
500
hope you can understand them :(
How ?
you can rename the tables to A ,B,C and post the structure and their relations.
500
since the tables are related, once the data in the master table changes its dependent records can be made to change accordingly (by implementing some business logic) using a trigger.
can you please post your table structure for reference.
500
use this.
UPDATE runquery.table1 SET runquery.table1.Column1 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM runquery.table2 WHERE runquery.table2.itemid = 3 AND runquery.table1.Userids = runquery.table2.userid),
runquery.table1.Column2 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM runquery.table2 WHERE runquery.table2.itemid = 5 AND runquery.table1.Userids = runquery.table2.userid)
500
if you wan to automate the process, a trigger will do the trick for you .
try this
select code, description, count(code) as total
group by code
are the tables related ?
I want to decide what to do due to the data values !
i really did not understand.
can you post some sample data for reference.
i was asking about database not dataset.
repeat the same for other column also.
UPDATE runquery.table1
SET runquery.table1.Column1 = (SELECT (runquery.table2.Col1/runquery.table2.Col2*100) FROM runquery.table1 , runquery.table2 WHERE runquery.table2.itemid = 3 AND runquery.table1.Userids = runquery.table2.userid
is this working ?
500
try this, may work for you.
UPDATE runquery.table1
SET runquery.table1.`Column1` = (select (runquery.table2.`Col1`/runquery.table2.`Col2`*100) from runquery.table1 , runquery.table2 WHERE runquery.table2.`itemid` = 3 AND runquery.table1.`Userids` = runquery.table2.`userid`, runquery.table1.`Column2` = select (runquery.table2.`Col1`/runquery.table2.`Col2`*100) from runquery.table1 , runquery.table2 WHERE runquery.table2.`itemid` = 5 AND runquery.table1.`Userids` = runquery.table2.`userid`;
what is the underlying database ?
What is the query that you are using ?
504
508
is the data being stored is case sensitive ?
Better to use LIKE inplace of = for character search.
try something like this
"select * from Movies WHERE upper(Movie_Name) like %'" & upper(txtMovieNamesearch.Text) & "'%"
508
508..
5 0 8
508
502.
502
5 00
500
498
488
4 9 2
492