Member Avatar

Hello to all, I have following simple Applet program. import java.applet.*; import java.awt.*; public class myapp1 extends Applet { Label l1, l2, l3, l4; TextField t1; TextArea t2; Checkbox c1,c2,c3,c4,c5,c6; CheckboxGroup cg; Button b; public void init() { l1=new Label("Enter your name: ", Label.RIGHT); t1=new TextField(20); l4= new Label("Enter your gender: "); cg=new CheckboxGroup(); c5=new Checkbox("Male",cg,true); c6=new Checkbox("Female",cg,false); l2=new Label ("About Workshop: "); c1=new Checkbox("Timely Completion"); c2=new Checkbox("Excellent Resourse Persons", true); c2.setEnabled(false); c3=c1=new Checkbox("Good Food"); c1=new Checkbox("Excellent Hospitality"); l3=new Label("Any other comment:"); t2=new TextArea(10,20); b=new Button("OK"); b.setForeground(Color.blue); add(l1); add(t1); add(l4); add(c5); add(c6); add(l2); add(c1); add(c2); add(c3); add(c4); add(l3); add(t2); add(b); …

Member Avatar
0
14
Member Avatar

Hi to all, I am having 1.75 GB of RAM on my 32-bit PC. The speed of computer is very slow for first 15-mins. What should I do to increase speed. Please suggest me, I am very new in this thing. Thanks.

Member Avatar
0
94
Member Avatar

Hi to all, I want to install SQL SERVER 2008 on my XP 32-bit OS. After clicking on "New SQL Server stand-alone installation or add features to an existing " link unser installation tab, Setup Support Rules window shows success status of all rules except "Restart Computer". It neither directly retarting computer nor proceed after I retart computer manually. Again and again it is showing same error. What to do?

Member Avatar
0
18
Member Avatar

Hi.... I am trying to connect sql server with vb.net in Visual Studio 2008 with foll. code.... but it is having problem....what is the problem? Please tell me.... 1. I created "publication" databse. In table i took 2 columns...fname and lname and fill the records... 2. I took DataGridView onto form and did foll. code.... Imports System.Data Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As SqlConnection = New SqlConnection("server=(local);database=publication;integrated Security=SSPI;") Dim objDataAdapter As New SqlDataAdapter() Dim objDataSet As DataSet = New DataSet() Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load objDataAdapter.SelectCommand = New SqlCommand() …

Member Avatar
0
7
Member Avatar

I created the following tables and inserted few values. create table books(bookid integer primary key, booktitle varchar(20), year integer, publisherid integer foreign key references publisher(publisherid), price integer, number integer) create table publisher(publisherid integer primary key, publishername varchar(20)) create table author(authorid integer primary key, authorname varchar(20)) create table bookauthor(bookid integer foreign key references books(bookid), authorid integer references author(authorid), earnings integer ) create table bookreference(bookid integer foreign key references books(bookid), referencebook varchar(20), times integer) create table reviewer(reviewerid integer primary key, reviewername varchar(20)) create table bookreview(bookid integer foreign key references books(bookid), reviewerid integer foreign key references reviewer(reviewerid), score integer) Now, I want to …

Member Avatar
0
9
Member Avatar

hi to all, I created following table create table book(id integer, author varchar(20)) In this, each book may have 1 or more authors. My question is that, how can insert more value to author column like as follows. id author 1 pooja merry james 2 robert stephen Thanks & regerds, Pooja

Member Avatar
0
9
Member Avatar

Hi to all, I created following table and its view. [blue]create table employee(id integer, name varchar(20), age integer) create view Vemployee as select id, name from employee.[/blue] now I want to rename a view, so I wrote a query like [blue]rename view Vemployee to Pemployee[/blue] But, it shows error about 'raname' keyword. what to do for renaming a view? Thanks & regards, Pooja.

Member Avatar
0
2
Member Avatar

Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but i don't get it till now. Will you please help me about constraint. I used 'BETWEEN' constraint, but it failed. What should I do?

Member Avatar
0
3
Member Avatar

Hi to all, I create the following table. create table man(id integer, name varchar(20), city varchar(20), age integer) I want the age, maximum age of person. So, I ran following query, select name, max(age) from man group by name; It shows name of all person in ascending order with their age. What is going wrong? Thanks & regards, Pooja.

Member Avatar
0
2
Member Avatar

Hi to all, I have nothing idea about how to create relation and solve their queries. I want to relation as follows: ------------------------------------------------------------------- BookAuthor(book, author, earnings) BookReference(book, referenceBook, times) BookReview(book, reviewer, score) BookPublih(book, year, publisher, price, numbar) In these database, each book may have 1 or more authors & each author may make a diff. amt. of money from that book. One book may make reference to other book.1 book may be reviewed by diff. reviewers and get diff. scores. an author could also be a reviewer & a publisher. --------------------------------------------------------------------- I want to solve following queries 1. find all …

0
1
Member Avatar

Hi to all, I created the following two table -------------------------------------- create table mail(mid integer primary key, name varchar(20) ) create table phone( pid integer foreign key references mail(email), phone integer) ----------------------------------------- After inserting records on both table, now i want delete perticular record from table say 'delete record of pid=12'. that means, i have to delete record of pid=12 from oth table. so, i ran following query. ----------------------------------------------- delete from mail, phone on mail.mid=phone.pid where pid=12 ------------------------------------------------ but i got the error like 'check the syntax near from', what to do then to get the proper output. Thanks & regards, …

Member Avatar
0
3
Member Avatar

Hi to all, I created following table ------------------------------------------------------------------- create table interiors(id integer, name varchar(20), type varchar(20) default 'baby cot', price integer) -------------------------------------------------------------------- but, when i doesn't inserted any value of 'type', by the definition of table, it should take default value. when i fetch all rows by 'select' query, it doesn't show default value. can anyone tell me that what is the problem? Thanks & regards, Pooja.

Member Avatar
0
2
Member Avatar

Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but i don't get it till now. Will you please help me about constraint. I used 'BETWEEN' constraint, but it failed. What should I do?

Member Avatar
0
8
Member Avatar

Hi to all, I created following table --------------------------------------------------------------------------- create table Interiors(no integer, name varchar, type varchar, dateofstock datetime, price decimal(6,3), discount numeric(6,2)) ----------------------------------------------------------------------------- i want to solve these two queries. 1. Display the type, sum of price and average of discount by grouping type as 'baby cot'. 2. Display the type, maximum and minimum of price by grouping type as 'baby cot'. I wrote following stmt.s for each resp. ---------------------------------------------------------------------------- 1. select type, sum(price), avg(discount) from Interiors group by 'baby cot'. 2. select type, max(price), min(price) from Interiors group by 'baby cot'. --------------------------------------------------------------------------- I got following error same for both …

Member Avatar
0
2
Member Avatar

Hi to all, i created following table ------------------------------------- create table employee(name varchar(20), dob datetime) ------------------------------------- I want to extract names of all months from 'dob'. for that i wrote following query ------------------------------------- select datepart(month, dob) from employee -------------------------------------- it works and shows all months but in number format, i want to display all months in character format. i.e. january, february, march, ... How can I do it? Thanks & regards, Pooja.

Member Avatar
0
2
Member Avatar

Hi to all, I created following table --------------------------------------- crate table publisher(name varchar(20), city varchar(20)) --------------------------------------- I want to run following query. [U]'list all the positions of charcter 'a' from name.'[/U] for this, i ran following query, ---------------------------------------- select patindex('%a%', name) from publisher; --------------------------------------- But, it doesn't show proper output. When i put 'city' column instead of 'name' column, it shows right output. What is the problem? ======================================= Also, I want to dispaly the name of publishers whose getting minimum and maximum profit. for this, i ran following query, -------------------------------------- select name, max(profit), min(profit) from publisher; ------------------------------------- It shows the error …

Member Avatar
0
3
Member Avatar

Hi to all, i created following table ------------------------------------- create table employee(name varchar(20), dob datetime) ------------------------------------- I want to extract names of all months from 'dob'. for that i wrote following query ------------------------------------- select datepart(month, dob) -------------------------------------- it works and shows all months but in number format, i want to display all months in character format. i.e. january, february, march, ... How can I do it? Thanks & regards, Pooja.

Member Avatar
0
2
Member Avatar

Hi to all, i created following table in SQL. =================================== create table employee(name varchar(20), dob date) =================================== But, when i ran the query, i got the massage that 'SQL can not find data type 'date''. How should i include 'date' in to table definition.

Member Avatar
0
5
Member Avatar

Hi to all, I created following table =================================================== create table man(id integer, name varchar(20), city varchar(20), age integer, dept integer) =================================================== I want name and maximum age of person residing in 'mumbai'. I wrote following query, but got the error like 'can not include name with max() fuction since it is not the part of it and there is no GROUP BY clause'. ================================================== SELECT name, MAX(age) FROM man where city='mumbai' ================================================== It displays the age qhen I ran follo. query. ================================================== SELECT MAX(age) FROM man where city='mumbai'. ================================================= How can I get Both i.e. name and age.

Member Avatar
0
4
Member Avatar

Hi to all, table name: mail email name [email]abc@gmail.com[/email] abc [email]def@rediff.com[/email] def [email]pqr@yahoo.com[/email] PQR [email]xyz@daniweb.com[/email] XYZ ======================================= QUERY: List all email and names in lower letters without any blanks. ======================================== I ran ltrim(), rtrim() and lower() function on data successfully. But fail to retrieve this data. Will you please help me? I don't have any little bit idea about code.

Member Avatar
0
3
Member Avatar

//Hi, //i create following table Table name : person ID AGE FNAME LNAME 1 10 Geek Greek 2 20 Seek Bells 3 30 Creek Dells 4 40 Sreek Sells[/B] // I wrote following procedure which is run successfully. Create or replace procedure proc1 as cursor person_cursor (pAge number) is select * from person p where p.age=pAge; Begin For I in person_cursor(30) Loop Dbms_output.put_line(i.fname); End loop; End proc1; // but, to see output i must write "set serveroutput on" in sql stmt. Please tell me why we use "set serveroutput on" into prog.? //Please tell me the neccesity of this line? …

Member Avatar
0
3

The End.