9,022 Topics
Hey guys, I'm currently testing my application with some scripts I have written. I'm using the following query to list known errors within my application, and the status of the tests that are are affected by each error: [code=sql]SELECT ERROR.BG_ERROR_ID, ERROR.BG_USER_03 as HardwareID, count (RUN.CY_RUN_ID) as NumAffected, sum (CASE RUN.RESULT …
hello I want to create a page,where there will be a gridview,with 2 columns. 1st column will have Numbers..1,2,3,4,5........as much as user want. next column is where people will insert data,say a,b,c,d,e,f,g..... After pressing the button, 1,a 2,b 3,c ....all these wil be inserted in database rows. can somebody please …
I downloaded SQL Server 2005 standard edition from MSDN. I tried to install it but the splash.hta and setup.exe don't work. When I click on splash.hta, northing happens. When I click on setup.exe I get the message "setup failed". When I uninstalled the standard edition and instead downloaded the developer …
Hey can anyone give me the query to retrieve a list of databases on a server rather than this query [code]SELECT NAME FROM sysobjects[/code] which gives me a list of tables ???? Thank you
was directed here by another member...great site! (am a newbie and I recently posted this on MSDN with 0 replies, am hoping someone can help here - you do not need to know VFP, just need help formatted a correct string that ASP will honor), Current Setup: Using: Visual Web …
Hello, I'm using VB6 and SQL Server 2000. I've got a problem with an insert statement that seems to be randomly failing. Its job is to copy everything from one table into another, removing duplicates using WITH IGNORE_DUP_KEY ON [PRIMARY]. Then my code copies the records back to the original …
Please fellow programmers am relatively new in programming and am currently working on a Library Maintainance and Administration software and am finding it hard inserting pictures with other data's into the database The picture insertion should be optional.Please i need to know the codes i need to achieve this Please …
[code=sql]res = PQexec(conn,"BEGIN"); PQClear(res); res = PQexec(conn,"DECLARE myportal cursor for select * from test"); PQClear(res); res= PQexec(conn,"FETCH ALL IN myportak"); ---- ---USE THE RESULT SET ------- PQClear(res); res = PQexec(conn,"END"); PQClear(res);[/code]
hello sir , i am getting problem with crystal report VB.net and SQL Server i want selected values to be printed in crystal report so i have written sql query for that . dataset shows selected values but crystal report shows all data in database Please help me . following …
i have a project of Call Management System with database SQL SERVER,now i want to limit the connected users in my database in 55 connected users only,where in this 55users can only use the system and if there is 1 user trying to connect on my database the system will …
G'Day all, I've got a plugin for an application. When it's installed it runs the following:[CODE]Alter table DocketItem ADD Optimised BIT DEFAULT 0 NOT NULL[/CODE] However, when the plugin is uninstalled it tries to run the following: [CODE]Alter table DocketItem DROP COLUMN Optimised[/CODE] When the plugin is uninstalled, I get …
i have a project of Call Management System with database SQL SERVER,now i want to limit the connected users in my database in 55 unit only,where in this 55users can only use the system and if there is 1 user trying to connect on my database the system will not …
Hi We are going to be starting a new ASP.NET website that will use an MSSQL database and the database is likely to eventually fill up as each database has limited size. Is there a way to have a database overflow into a new database when it is full but …
The following stored procedure is supposed to add a new record to the database OR update Mdescript if it already exists. However I keep getting errors such as primary key violations. Please take a look, many thanks :) [CODE=SQL] USE [COSHH2008] GO /****** Object: StoredProcedure [dbo].[CHSP_OR_ACTIVITYAREA_001] Script Date: 12/02/2008 13:59:33 …
Hi all, I am working with a project which includes Crystal Reports in Vb.Net and SQL Server2000 as Back end. The code in button click is [code] str5 = "D:\AttendanceReport.rpt" If Not IO.File.Exists(str5) Then Throw (New Exception("Unable to locate report file:" & vbCrLf & str5)) End If str6 = "SELECT …
HI Everybody,I just need yours help. I am trying to develop a windows base application just like multiuser . where i have a database (MS SQL Server)and users can access the database table at a time and using resources to complete their task. it is necessary to configuring MS SQL …
Hi friends, Please someone how to create a dll in vb. net class library , how to register it and how to call it using sp_oacreate. Pls provide some sample codes.
Dear Friends, I have created a dll in VB 6.0 and i am calling this dll using a trigger which is for INSERT record. But when my application inserts a record to the table, Trigger runs succefully but record is not inserted and gives this Error: Description: Receipt. Database error …
Have made DSN, Now i want to make connect to database.. want a vb script for this. have to fetch data from data base Somebody help please.
I am working on microsoft MS SQL 2005, want to connect with vb script. Want a connect string for this.
Dear Friends, I have created a dll in VB 6.0 and i am calling this dll using a trigger which is for INSERT record. But when my application inserts a record to the table i am getiing this Error: Description: Receipt. Database error (operation=INSERT, error=0). [Microsoft][SQL Native Client]Connection is busy …
topic continued from here: [url]http://www.daniweb.com/forums/post748453.htm[/url]
I'm trying to display data in cold fusion but when I add my history table I get duplicate listings. I've tried select distinct different joins. How do i join my history table and not get duplicate listings My store procedure in MS SQL is [CODE]USE [Website] GO /****** Object: StoredProcedure …
Hi all, I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i try it errors. Do I have to reword the statement …
I have 2 related tables, master and a child, the master table have a primary which is an autonumber and I reference that autonumber to my child table as a foreign key so my problem is to get the value of the autonumber from a master table and write it …
Is it possible to call a sql view in vb.net? I can call stored procs, but when I change the code to read a view it says that "request for procedure failed because it is a view object"
Hi all.. dis is kinda urgent case though coz i dun have much time to complete my final project.:'( I've installed sql server 5.0 and the connection is on.I have also created the tables related to my interfaces As for vb.net, i've finished with all my interfaces. Now, the problem …
The class should support a function named Profiles which takes a ID as an Integer parameter and returns the name corresponding to that ID as a String. If the name is NULL, then the function should simply return an empty string (String.Empty). If the ID does not exist in the …
I have converted around 395 Excel survey forms to MS SQl database with that many tables. Well, I run a script to assign a primary key on all the tables on my database.First I set the column property to NOT NULL and then i assign the primary key to it. …
I would like to create a variable in my trigger - @DBNAME. When the trigger executes, this value should be set to the name of the database it was executed in. E.g. for the master database the value of @DBNAME would be master. How would I go about figuring out …
Please how can i code a combobox in my software to be able to update itself whenever a new item is keyed in so that it automatically becomes a member of the combobox dropdown list.the combobox should be able to update itself with new items so that users will be …
I am writing my first database app (windows form in c#) and I am using an access database. I have 2 tables with the following fields: payroll --Store --lastName --PayFreq --SSN (PK) --HireDate --EffectiveDate --TermDate --DeductionCode --Deduction --NAD CHAR hrconnection --Store --lastName --CoTime --Plan --Dependants --HireDate --EffectiveDate --TermDate --SSN (PK) …
Hello, im a rookie i would like to connect to a MSSQL2000 server Retreive information post it on the website then detele it on a condition please help i have compiled this so far. [code=asp]<% '* database server parameters Dim serverIP '* ip adress Dim serverPORT '* ip port Dim …
Hello, me and my programming group were given the task to build a program to save peoples information, for instance, Name, Last Name, Age, I.D., etc. Is there a guide, A VERY BASIC GUIDE, to pass the values of, say, a text box to an SQL Database? Or to make …
Hi all, Just a quick question: I have my website done and the database I used is MS Access. Problem is MS Access' return of results are really really really slow. Now I want to shift to SQL server, but the web hosting site we paid does not support this …
Hi Friends!! I have done a task of Importing excel in SQL server 2000 using Vb.Net 2003. I have provided Import/Overwrite facility to the User here. For this i used a Combobox. I have inserted values in Combo at design time. From the Property, Items (Collection). In Code i checked …
hi all, I want to create a link in Reporting Service that redirect me to another page(Not a supreport) or executes some code. e.g, the customers IDs appears as links and when clicking it retrives this customer details or redirct me to another page that displays the customer details. I …
hai friends, I am developing a application like a job portal on that i have to use the file upload control to store the resume and download the resume. how can i do that. please send me the sample code to do that. AS SOON AS POSSIBLE
Guys I need to upload an image on SQL server 2000, I dont want a C# or VB code for that I just wana know if it is possible to just upload a picture straight to SQL server without the insert statemt coz I have loads of images I need …
Hello! I want to use the following code [code=sql]SELECT * INTO Persons_Backup IN 'Backup.mdb' FROM Persons[/code] But all I ever get is the error message: "Incorrect syntax near IN" How could I solve this? But when I miss the IN clause, it works perfectly. I think the problem is that …
I'll start off saying I am not a programmer. I am making a database that imports data from Word forms. It requires code and I found some that works almost perfectly for me at [url]http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx[/url] It does exactly what I need. The only thing that would make this code better …
I am using MS SQL server, and I'm trying to create a SQL query that adds data to a "Reminder" table if data in the "Occurrences" table meets certain criteria. This might be a little difficult to explain. Here's the problem... I have a table "Occurrences" which i updated every …
i have a problem inserting record into the sql server databases. but i could not get the corret sytax i have read a lot of book but i am getting a lot of bug in the code pls i need you help to help me get code that i could …
I need help with joining these two tables: Table1 idx idy --------- one 1 two 2 tree 3 Table2 idy u ------- 1 a 2 b 3 c 4 d 5 e 6 f I want to show rows from the Table1 that have idx=one joined with all the rows …
i am working in vb.net application, .net 2005 and sql server2005 i am doing multi user application, my doubt is how to restore database in my server system without interrupt client systems?
i am developing a job site and i require to search for records from the database. i m passing value fro that parameter in textbox. so please help me thanks in advance
Please friends am working on a project in which am trying to make it possible that when the first letter/alphabet of a name is keyed into a textbox linked to a search button and when the search button is pressed, all the names/rows begining with that first letter will appear …
Hi, I was just wondering if anybody new of a way to store an encrypted file to an sql server database through a stored procedure. I have managed to encrypt a file selected from a FileUpload control but at the minute the encrypted file and the key are created and …
Dear Friend , I am Using Vb.NET for creating windows application. I have attched MS SQL database to my application and project is over. I dont know how to create setup file. please someone help me regarding this. Thank you,
pls help job at stake!! An image is stored into database using delphi with a back end Access.This images were imported into sql server.Now i want to display the image using vb6.Please help with the code
The End.