trying to understand how to do Normalization to 3NF. applying for a job, which involves having to do this. i have all the other requirements for the job are covered, just this is very new to me and is getting me confused.we are to be tested in the interview in 4 weeks, and have been given some pract...

Hello Gurus........ I wanted to query an Access DB from VB 6.0 using input from a Date Picker. I tried to put a query like the following "select * from Table where Date_Join is like # & Format(Datepicker.Value,"mmm-yy") & # order by Date_Join" The value of field Date_Join in the DB is dd-mmm-y...

I want to know what is the maximum capacity of MS-Access to hold records.<br/>I am creating a database which consists of around 10,000 records. Will Access support it. My frontend application is Visual Basic 6.0

Hello all,Question on SQL statement in MS SQL Server.I have a database of Sales Analysis which contains the month of each transaction.I want to group the qty sold quarterly, i.e Jan-Mar, Apr-Jun, Jul-Sep,Oct-Dec, sum it, and find the average by each quarter.I understand that one of the way is to use...

I want to debug the stored procedure in ms-sql 2005 , after all of thing is done , I launched vs.net 2005 , un-folder the destination stored procedure I want to debug , found that there was the item of "step into stored procedure " in the pop-up menu when I right-click the stored procedure in serve...

Hi there.i have a datatable.i want to move to the previous and next records in the table.can someone help me in writing code(preferably in c#).

Dim LBox As ListBox, Build As String, idx Set LBox = Me!List175 For Each idx In LBox.ItemsSelected If Build <> "" Then Build = Build & """, """ & LBox.Column(0, idx) Else Build = LBox.Column(0, idx) End If Next Me!Text171 = Build Set LBox = No...

Hello dev-archives<br/>Sometimes in my C# DB application working with SQL Server<br/>there is bug message like this "Child list for field select * from [TableName] cannot be created"<br/>What is the problem ?<br/>Thanks

I have 2 SQL Queries that I'd like to combine.First, I get BatchDate and Closed Totals. SELECT DISTINCTROW Transactions.BatchDate, Count(Transactions.BatchDate) AS [OpenTotal]FROM TransactionsWHERE (((Transactions.DeletedFlag)=0))GROUP BY Transactions.BatchDate; and this gets BatchDate and Open...

hii am using vb.net 2005 express ed. and oracle 9ii want to write a stored procedure which return a records of a table.still now i am not able to write a select query in Oracle stored preocedure.i am also want to pass 'table name' as parameter. is it posible..?i am new to oracle databse....

Hey gurus. SQL Server 2005 Express! :) I have a terrible problem with one of my queries Here it is. i need to select all the records in one table where the status of it is unpaid during the period of 2005/2006The problem is that the only way to know if it is unpaid is if the primarykey is NOT equal...

Hello,I need help figuring out how to query multiple columns in a table for MSSQL 2000. Here's the table layout:Table 1ID, First_Name, Last_Name, City, State, Country Table 2 - Permission to view a field in table 1T1ID, First_Name, Last_Name, City, State, Country I want to write a query so tha...

Hi all,I have 2 tables. One table with employee names and department # (plus several additional columns) called "Employee_Info" and another table also with employee names and task # (plus several additional columns) called "Tasks". I'm using the following query:SELECT E.Employee_Name AS Emplo...

Hi there,<br/>I am reading and writing to a SQL database. However i wish to read a users details based on which user is logged in. I have tried unsuccessfully to create a session variable and pass it into my query.<br/>Any help would be appreciated,<br/>Adrian

HiI'm a real newbie to SQL, so this might seem very basic. I searched for a solution here already and found thread 342246 as the most similar question, but which didn't work for me.I try to do some update/insert work for a user table. If I find a unique user alias, I do an update, else I h...

Hi Gurus.... Need urgent help in sorting this SQL statement in VB6.0, Access 2000.The SQL query that I passed was like this:- "select (select distinct(Txn_Date) as [Income Date], sum(Amount) as Income from transaction_Table where Txn_type = 'Credit' group by Date_Txn order by Date_txn...

HelloI have an old program made with VC6, a MFC application which uses ODBC to connect with an Access Database in a computer in a LAN.Basically there is LAN with various computers and a Dababase in a computer of the LAN. Every computer connects with the Database and people can make queries and edit...

how to concat strings in one colum. i mean i have a column in my table and i want to concat strings in this column like sum functionid string1 a1 b1 c2 d3 ei will write a sql command and it will return abc for id = 1i hope i could explain...

Hallo everyone, I have another problem related to producing reports from MS SQL Server using Excel. I know how to put the results of a query in an Excel worksheet, but now I want to use the results from a query to populate a combo box in VBA. Does anyone know how to do this?Thanks alot, Dirk...

Just something that's been bugging me for a while(Just using access)Is it possible to use a blanm field (or create a field) and use it for the sum of two other fields in the same record using an SQL statement?For example, my table will look like this:Table1--------ID (numeric)Numb...

Hi,I converted my Access DB file to MySQL by exporting the tables. However, the tables exported, all fields are NULL enabled. Is there a way I can force it to be NOT NULL for all fields or is there any tools available to do the conversion? I tried changing 1 by 1, but sometimes an error prompted, "A...

I'm creating a web application in Visual Studio using C#. This is supported by a SQL server 2005 database. I am reading and writing to the database fine through code. However my problem is when i wish to write a record to two tables within my database. I have setup the relationship but i am un...

for example , <br/>'2007-11-1' , I want to the '11' .

I'm getting the following error: "Incorrect Usage of Update and Limit". I've looked it up on google and got 2 results! One was in a foreign language and one was a news feed, how helpful! So I thought I'd make a post about it and get the error noticed. Upon taking out the limit stateme...

I have developed a database application in vb.net/ms access.Instead of shipping the original access database along with the application ,is there any way we can convert the access database into a resource or some other format so that nobody can tamper with the database once the application has bees...

I'm working on some programs that does batch updates and inserts to our sql server database. I have no problem with doing that but it takes a lot of time to do thousands of updates/inserts (well, a few minutes may not seem like a long time to some people). Anyway, is there a way to group all...

HI!<br/>I have remote db2 server working under windows. My developers are trying to connect using control centre. But reading db info is EXTREMELY slow, even db is empty. It takes about 10 minutes. <br/>Please, help!

How do I find the most common value in a field/column/attribute using MySQL?For example:fin1 fin2 fin32 1 110 10 72 5 72 3 510 3 3 40 2Here the most common value for "fin1" is 2 followed by 10 then 20.fin2 = 2x number 3s followed by the others with 1 instanceetc.How do I get this in a query? Here�...

Hello,I have a typed dataset which I want to display in an ultragrid (infragistics) and display the parent and the children.I can display this ok when I want to display all of the parents and children. But the problem is when user will need to select one parent (by customerID number) from a list and...

Bay Breeze Software just released SQL Edge 3.0 to support auto-layout and multi-page ER diagrams. The ER diagram view now supports outline view, rulers, grid, page breaks, and multi-page print preview. It even allows users to customize fonts and colors of diagram objects.Please refer to this link fo...

This is about the closest forum I can think of to ask this question.I'm maintaining an application which performs an export of data from an Oracle database.This export is exceptionally memory intensive (> 1Gb cached in memory).There is an abstraction layer which enables the code to talk to e...

[VC++ 6.0, SQL Server] Cross-posted from Visual C++ ProgrammingAfter using Triple-DES encryption, I end up with a BYTE* array of encrypted binary data that I need to store in my SQL Server database table. But I cannot seem to find the right way to get it into the table. (The code to convert the BY...

Hi Guys,I am building a contact management database in SQL Server. The front end is built in C# using Visual Studio.I'm using a Gridview to display the results of my query which i've built in the Query Builder. The trouble is is that i wish to query this query. I expect that the query woul...

Hello All,I have to access files using PLSQL. I have set the initialization parameter utl_file_dir as follows:SQL> select value from v$parameter where name='utl_file_dir';VALUE------------------------/u08/reports/I have written a small procedure to write into a file as follows:create or...

hi, can anyone help me with this error. <br/>i'm trying to restore previous year's data into a backup server and am getting error message "Microsoft SQL-DMO(ODBC SQL State:42000)".

HiI have difficulty of updating my MS SQL database with empty field. I'm using sqlDataSource.Update() to update my database. Sometimes, I need to remove certain field, such as: contact no, when the contact no is longer in used. However, everytime when I update with the textbox left empty, an er...

hi friends, I am using sql server 2000 i am facing a problem i am having a field in my database called as "subscrptn_dt" its datatype is nvarchar(10) and this field has dates stored in it as as different format some are dd/mm/yyyy some are mm/dd/yyyy and some are yyyy/mm/dd so i need to re...

I need to open an Excel file that has been stored in the Access Database using the insert Object functionality of MSAccess manually.What i am aware of is that i cant just read the field containing the Excel File into a Byte Array and pass it to the Excel object in C#,as the file is wrapped in the OL...

I have recently trying to work with sequencesI dont know if I am too supid to use it or is it the other way roundMy problem is such:I would like to rollback the sequence(meaning after I work with the sequence, I would like it to come back to its original values)1st attempt:rollback does not work wit...

I have a database tables which contains two tables with records > 30000.I wrote a database query"SELECT rank, b.isbn, book_name, volume_no, author, publisher, price, quantity FROM tbl_rank_books b LEFT OUTER JOIN (SELECT * FROM tbl_rank_stock WHERE customer = " + ddlCustomer.SelectedValue + ") s...

How do i acess the recordset of a table using MS Acess

Hello,I am making a project based on a Distributed Environment Computing, where I have total 11 Servers, and the Client connects to all 11 Servers to upload certain files. Here I am required to maintain a Database on each Server which contains exactly the same information of all the clients(this mak...

I need experts input on what structure and db technology is required to accomplish the following:I have the need for a core engine that takes inputted keywords (e.g. "fish" "food" "eat" "temp" "water" "die" "tank") and figures out the majority-winning *context* of that set of keywords. So for this e...

hello friends<br/>i'n trying to create a trigger in Sql server 2000.<br/>can anyone plz tell me the syntax for create trigger query for Insert, Delete and Update<br/>Rgards<br/>Saira

HiI'm working over a project that comprises of MS Access 2003 Database and Visual Studio 2005 IDE using C#. I want my database to be hidden/untouchable when I deploy my project. What do you think if add my database as a Resource? Note that, the database is being heavily used for Reads and less...

Hi.I have a database in one Excel worksheet.Each line of the database is one of about 5 different types, which is determined by a special column called "type". To be concreate, it is a database of butterflies. On each line there can be one of couple of taxonomical categories.I often need to calculat...

I would like to implement a quick search function in my site. When the user types some strings in it, it will search every tables (except some other's sensitive information) and give the results.I would like to know how to write the database query as i think it will be quite messy if use someth...

I have written an application in vb.net(2005)/ms access. I want to make a case sensitive search in one of the database tables that stores text data stored in ISCII format using the LIKE sql clause. I understand that search in ms access is case insensitive by default. We can make a case sensitive sea...

I have a table created in MS Access. I am using the Jet OLEDB driver to access this table. I am programming in C#.I defined the following UPDATE statement:command.CommandText = ("UPDATE EndOfMonth SET [Rented Depreciation] = @RD, [Unrented Depreciation] = @UD,");command.CommandText += ("CashSales =...

Before you all start flaming me, hear me out!I have an idea, but no idea on how to follow through with it. If this is entirely not plausible, please go ahead and flame me till your hearts content.There is a page on another server that I want to get information off of. I have no access to this serv...