debasisdas

you need to capture value from any control using variable and later use the same in your SQL statemnet.

try this, may work for you. [CODE]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`;[/CODE]

Go to User Control Panel > Edit Email & Password and change the settings.

try installing from another CD.

Please read more [URL="http://www.google.co.in/search?hl=&q=Error+40&sourceid=navclient-ff&rlz=1B3GGLL_enIN395IN395&ie=UTF-8"]here[/URL]. Please check your [URL="http://www.connectionstrings.com/"]connection string[/URL].

yes that sky rocketed a couple of days back and yesterday nose dived back to where it was

Yes those are system tables. that will depend on the schema through which you have logged in into the DB.

[QUOTE=VernonDozier;1510700] ... you can vote as you please[/QUOTE] What the hell, how can he vote, is till a minor. :twisted:

Hi Quark, Welcome to Daniweb.

Welcome aboard.

Yes, it can be.

You need to alter the table. Please read more [URL="http://dev.mysql.com/tech-resources/articles/mysql-cluster-50.html"]here[/URL] and [URL="http://dev.mysql.com/doc/refman/5.5/en/alter-table.html"]here[/URL].

Hi Mk zaman, Welcome to Daniweb.

You need to go and read books and then complete your own assignment by yourself only.

Tr using this [code]SELECT TO_CHAR(sysdate,'DAY') from dual [/code] for the 2nd part of the question use the above query (modified as per your requirement) and use [B]group by[/B] clause on the day.

^ Another Nice Human on Earth < Browsing for last 4 hours. V will continue.

That seems to be a paid project. How much ?

why not simply try BillNumber = max(BillNumber) +1

The error message is displayed to maintain REFERENTIAL INTEGRITY. While deleting records from a table you need to ensure that that there is no dependent child record in any other table, values of which are dependent on the records of the current table.

let me understand first why you need to pass a out parameter to a function.

read more [URL="http://msdn.microsoft.com/en-us/library/system.windows.forms.toolstripprogressbar.aspx"]here[/URL].

@Dani: great job. I can only imagine how fast you cooked it. :D

CASE executes faster. DECODE works with expressions which are scalar values. CASE can work with predicates and subqueries in searchable form: CASE handles NULL values differently

May be you need to set the [B]RootFolder[/B] property.

all the machines are able to access the central server over network ?

What you have done so far ?

What are you talking about ?

You need to join both the tables using SQL if tables are related. Why two separate tables for managers and clerks ?

Why you need YEAR if try to display all the failures ? Does the same course id repeats across all the years ?

You need to use DELETE to delete records. Use proper where clause for the same. If you want to delete all the records simply use DELETE without any WHERE clause. I don't think TRUNCATE is supported in ACCESS.

better to ask from whom you got this .

You need to read [URL="http://msdn.microsoft.com/en-us/library/bb500469.aspx"]this[/URL].

You need to store the path of the file stored in the folders along with other details in the employee table. To retrieve the same yo need to fetch the path stored in the DB and read the file from file systems.

what are you working on ?

option1 -- use a refresh button option2 -- refresh using timer (bad idea)

Not sure exactly what is your confusion. All arithmetic operations works on database tables while used as part of a SQL.

so, what you have done so far ?

That is [URL="http://www.daniweb.com/software-development/cpp/threads/359811"]here[/URL].

[QUOTE=deceivingrakesh;1536138] users will upload texfiles which might include images[/QUOTE] Images in text files, How ?

you need to use [B]COMMON DIALOG CONTROL[/B]

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

what is a system in your case ? is it a PC or an application ? What will log off ?

What is the relation between these two tables ?

as per the rule of referential integrity. 1. No child record can exist without a parent record i.e.--Parent record must be created first and then the child record. 2. Parent record can't be deleted till there exists a dependent child record i.e.-- Child record must be deleted first and then …

[QUOTE=vinothmca;1536174]How to insert into components.[/QUOTE] what are you trying to do ?

It is practically impossible to predict without knowing the actual structure of both the tables and their relations.

You need to read books for all those beginners level questions.

Do you have any code that you are working on ?

[QUOTE=vanpersie;1535918] I need others to work with me in DFD and DRD[/QUOTE] This must be a paid project ?

error on which line ?