Databases Forum

I have the following data in a table named dtlstbl which has columns id and refid 100,1 100,2 101,1 102,2 103,1 103,2 I am fetching data from this table thus select id from dtlstbl where refid in (1,2) All the records are returned. I want a SQL 2000 query that …

Hi, I created a simple application in Oracle APEX, and on the first page (blank page), I put a textbox. Now, I want to be able to insert the input data from the textbox into the tables, e.g. insert new first name, last name etc... Can someone tell me if …

Can anyone suggest me how to create web pages using PlSql??

Hello I've moved from graphic designer to static site builder and now want to begin exploring dynamic sites. I'm on a MAC and would like to use FileMaker Pro as my database app. Any comments? Thanks

Hi, I've managed to piece together an SQL query (not literate in the language), but it isn't giving quite the data I expected. Here is the code: [CODE]SELECT products_description.products_name, products_description.products_description, products_description.products_id, products.products_image, products.products_price_sorter FROM products_description INNER JOIN ( products, salemaker_sales ) ON ( products_description.products_id = products.products_id AND products.master_categories_id = salemaker_sales.sale_categories_selected …

pls, help! how can i connect to mysql 5.0 database with vb6 and how do i connect to mysql database from php5.Where do i download the necessary drivers.

I am having trouble with one thing on my project. I have already created the following table and inserted all of the information into it. Items ItemID Description BidFloor 100 1943 Monopoly game 80 101 1972 Ford Pinto Station Wagon 80 102 1.5 L 1921 Chateau Neuf du Pape 1,000 …

Hi frnds.. Currently i am working as a php developer.i know php,mysql and smarty... i am interested to change my domain from [B]web developer to mysql admin..[/B] plz give me some suggestions to me... how can i need to follow? and where can i get information regarding mysql totally.....what should …

Hello Everyone, I have a pretty simple problem for an expert. I want to access the database on the server from my localhost, I don't know how to do it. On our localhost the way is mysql_connect("localhost","name","password"); But how I will access the database on a server from my localhost?? …

how can we take backup of a database with shutdown the server in mysql.

Hi, I've been asked to create a proof of concept for a new database tool we need to develop, combining various existing databases. It’s been awhile since I’ve touched any database work and I’m a little unsure how to go about it. Let me explain the problem...the analogy I’m using …

Hi I was wondering what the syntax would be to have a left join from one table to a resulting query without the view. Currently I use a view and it works fine but I was wondering how to achieve this without creating the view. Here is the current view's …

I need help with structuring a mysql database query so that if a certain condition extists, then a further condition is applied to the "WHERE" clause. This is my standard query: [CODE]SELECT * FROM products LEFT JOIN access ON product_id = access_product_id LEFT JOIN manufacturers ON product_manufacturer_id = manufacturer_id LEFT …

I don't have a clue how to do this. Have a PHP web site template, that has a 'submit ad' form. Works just fine for that web site. What I want to do, is to include a number of additional sub-domains, so that one can run the same ad on …

I know this is for MySQL, but there really isn't a forum for 'other databases.' I was wondering if anyone could point me in the right direction for learning SQLite. I tried googling it, and I did find some helpful things, but nothing that shows me how to use it. …

All, Have a set of nested forms/subforms in this order: frmMain => sfmMain => ifmTABset => sfmUSR => sfmSETcfg where sfmMain & sfmUSR are the control fields containing the subforms being called and the TAB control TabCtl0 resides in the TABBED form of ifmTABset. I am trying to open the …

i have thisnew script if anyones interested i have lots of questions just pm me i get emailed if someone pms me and im online a lot so ill get notified fast see i have an emil checker on my firefox browser. i need help with lots thanks guys!

Hi Guys, I'm new to SQL and just know the basics. My boss has asked me to help him with a new system they are developing using MS. Access. In the form, the user enters their information as well as checks the applicable check boxes. When they have completed the …

I'm new to mysql and I need some more practice with this stuff since were going to have a test soon ([I]this is not a homework assignment[/I]). One thing I still don't get is how to check if two tables contain an equal set of values. Heres the practice problem …

Hi! all Let me explain the problem:- I have two tables A(aid,aname,adesc),B(bid,aid,bdesc). I want a query which will extract all records of 'aid' in 'B'. means aid bid aname bdesc 1 1 qw eeg 2 null re null 3 4 sd v tyuy 4 null dffg null Hope to get …

hi. Im afiya . i have a company's product catalogue . Im asked to represent the products in treeview control of VS2008 . Please can any one tell me how the database must be designed so that i can add a product as parent node or child node on the …

Hi, Can anyone please help me with my command button. What it's suppose to do is if vbYes is chosen, then it will update a Field (fieldname "Approved") = True. If vbNo then the updates will be deleted. This command Save button is in a form which calls on a …

Hello all!! I wonder if anyone can help me and I hope I am posting in the right place, forgive me if not. I have a fairly complicated scenario but to simplify it, I have a Customer table which is connected to Order table. Staff members can be customers and …

Hi. Please forgive me if this is posted in the wrong section. I'm starting a sports website and I'm hoping to have a section with each sports team that will display the team roster in a table format. Each player will have a line for their name, position, height, weight, …

Some design advise please. I have the following 2 tables. How far does one go with referential integrity. In the below example, the schools table has type_name (which is ... 2 elementary, 3 high school, 4 baccalaureate degree..... I have created a child/parent table reference between 'schools' and schools_type. I …

Hi, How can I delete duplicate records from a table in a single query. Thanks in advance.

Hai frnds. I started doing a project for my college [B]online Examination[/B] This project is exclusively for college for conducting Aptitude and Reasoning test. There are 2 groups MBA MCA and these 2 are divided as MCA I yr MCA II yr MCA III yr MBA I yr MBA IIyr …

Hi all It’s required from me to create a database for a company which have three branches; the company does repair and sale second hand cars. I have created the database with my tutor but I think there are things missing but I don’t know where they should go and …

when i install mysql, my computer keeps restarting I can't even uninstall it! i fixed it by logging into Safe Mode and do a System Restore. MSQL is now uninstalled, so it's fine now. I want to have MSQL working. - using XP SP2.

Hi, this is the first time I have posted a question. I'm really hoping for somebody to help me. I have a text box in a report that I need to populate via a function. The data required (OPENING BALANCE) is already in another query titled: "qryEOD Report Query". I …

Hello everyone. I'm now working on a banner software which allows admins to see full statistics of banner displays, clicks and other information in selected time interval by minutes, hours, days etc. I want to consult any experts who have experience using large tables with JOIN queries and optiomize my …

i'm using sql server 2005 for my asp.net program. i have 2 tables, first table X, second table Y X has column: [code]DEM_ID int DEM_DATE datetime DEM_QTY numeric(18,0) constraint PK_DEMAND primary key nonclustered (DEM_ID)[/code] Y has column: [code]FRC_ID int FRC_YEAR numeric(4) FRC_MON numeric(2) FRC_SALES numeric(18,0) FRC_FRCSALES numeric(18,0) FRC_FRCLOG numeric(18,0) constraint …

hi guys, I have one table: exams(e_no integer primary key,e_name text); now i want to create another table called questions which should have primary key that is combination of exam.e_no (foreign key) and question.q_no questions(q_no,e_no,questions text); so i would like to make q_no and e_no both act as primary key …

Hi all, i have a table, it will store millions of rows, corresponding to raw byte sequences from many sources. I´m thinking on using for primary key two options: 1- Columns: (source_id, date, data) and PK = (source_id, date) 2- Columns: (id, date, data) and PK = (id) The sources …

I dont actaully know where to post my question below, so this looked like the best place next to a "generel web discussion" forum but none found. OK, basically i need some advice from you guys on excately what steps i should follow on how to create a browser based …

Hi friends I have written my first code using dynamic SQL which is as follows [code=sql]CREATE OR REPLACE PROCEDURE Insrt_Chld_Dtl AS CURSOR_ID INTEGER; V_FORMAT_ID NUMBER(20):=1; COL_NM VARCHAR2(50); VLS VARCHAR2(50); V_COL_NO VARCHAR2(20); SEARCH_STRING VARCHAR2(20); --ID VARCHAR2(100); PRNT_VL VARCHAR2(100); COL_CNT INTEGER; V_SQL VARCHAR2(200); CURSOR FETCH_MST_DTLS(V_FORMAT_ID VARCHAR2,V_COL VARCHAR2) IS SELECT WHETHER_COMBO, ABV, DESCRIPTION, …

Hi, Can anyone tell me how can we know if any updation is done in table such as insertion | Deletion | Modification of record in one or more table without peeping inside the table... say, finding the history records that are updated... To be more clear; say I have …

Dear all, How do I change primary key field from query because if I use VS Designer, raised an error about [B]time expired[/B] ? I want to extend my FK field length. Thanks

hi all Database Masters Here i have suffer one critical issue,i have two column a and b, Table name : Student "A" "B" "1" "SAntOsh" "2" "SAuraV" "3" "SAriya" "4" "SAnju" "5" "SAthiYa" These are the sample records from my Table field. The "B" column always start with 'SA', the …

hi, i would like to make an insert statement with a subquery, i know that it is possible with a following select command, but i would like to combine it with scalar vars from a data grid ? please help: [code] INSERT INTO akquise_dispo_stunden(sb_id,akquiseprojekt_id,monat,jahr,ma_name,stunden)VALUES(@sb_id,'test',1,@jahr,([B]SELECT name FROM ma WHERE user_id=@sb_id[/B]),@JanStd); [/code] …

Hey, I've just started using mysql and I have som problem with JOIN. I have table1 and table2 and I would like to join these two on table1.col1 and table2.col1 to eliminate all identical rows. In addition I need to have a WHERE statement on table1. This is my attempt: …

[B]I am trying to insert a new record into a mysql database and get the following error:[/B] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '30, 60, 90, DayCreated) VALUES ( 'Rush Shirt', …

Good Morning All I have a table named “Final” with Values like this [code] ID || DESCR || CYCLE ====================================== 1 || Earl G || 20 2 || Earl G || 21 3 || Earl G || 22 4 || Davidson I Dr || 20 5 || Davidson I Dr …

when we for trigger in c# .net ..can anyone expalin me with simple example

I am using SQL Server 2005 express. I want to insert a record into a table and return its primary key. Here is my SQL Procedure: [code=sql] ALTER PROCEDURE InitialiseHistory AS INSERT INTO StatusHistory (StatusCode, DateChanged, Comments) VALUES (0, { fn NOW() }, 'Status initialised to UNKNOWN') RETURN SCOPE_IDENTITY() [/code] …

Good morning , [COLOR="Green"]I'm facing a difficulty defining some enty type in this case : 1. You are a systems analyst. You have been assigned to design a database management system (DBMS) for Mechanical Engineering (ME) company. ME orders its parts from two types of vendors-local and non-local vendors. Vendors …

Hello friends, I want to clear a table by clicking a button on a form. I have created the query to clear the table but I cannot make it the source for the command button on the form. Is this possible? Thanks for your time and help.

In The Name Of God Hello All i will connect to my table in sql server 2008 but display this message to me. [url]http://www.uploadgeek.com/share-10D4_49F1AEF5.html[/url]. can anyone tell me how can solve this prfoblem? thanks alot. goodbye.

Hello! I have a DB setup which simplified looks like this: PRODUCT(id, owner_id) OWNER(id) What I want to do is to produce a list of how many products each owner has, and then sort it in some way, all in a single query. How do I go about this? Thanks!

Hey I am working on a database final project and I am almost done but it would be awesome if some database guru could look over my erd and my sql code and tell me if anything seems amiss. for the project we just had to design a database with …