I'm trying to use a procedure with to arguments. But there is an error: "expected: =" (VBA)I'm writting exactly following codeSub Multiply(x as Integer, y as Integer) ??1.CommandButton1.Caption = x * yEnd SubIn the required place I write:Multiply (5, 6)And the result - ERRORWhat should I...

Hi,Simple question :I have a table and one column is ID (int identity(1,1) not null).Say I have 5 rows:ID Name Color 1 Bob White2 Jane Black 3 Lucy Red4 Gang Brown5 Dub YellowIf I delete the row 3, the remaining ID's are 1, ,2, 4, 5....

SELECT'if not exists (select* from dbo.sysobjects where (id = object_id(N'''+c_obj.name+'''))and OBJECTPROPERTY(id,N''IsConstraint'')=1) '+' BEGIN '+'ALTER TABLE ' + t_obj.name + ' ADD CONSTRAINT '+c_obj.name+...

i need to write to my database(dao), i've managed to write only text type by using the function SetFieldValue(), but now i'm trying to write to my primary key(which i defined as an "automatic number"), and i dont have a clue how to do that!please help...you probably asks yourselfs why to c...

I'm really writting such code:Dim CurrentHeaders as New Collection 'Global collectionSub InitCurrentHeaders() Set CurrentHeaders = New Collection for i = 1 to 3 CurrentHeaders.Add 0 Next iEnd SubIn the place where I need this collection (after InitCurrentHeaders procedure calling) I'...

Hi, I just can't get this thing to work right. I have 9 forms in a switchboard (Access). I created a macro to save all these forms individually. When I click on the save button on the first form, it save it, but i don't know where!. When I click on the Save buttons for the other 8 forms,...

Situation: Access Database Goal: Construct a SQL statement to join data from two tables. Table1 is a schedule Fields are like this: Date | Time | Team1 | Team2 |Location etc. Table2 has the Team Names: Team_ID | TeamName I am trying to write a SQL statement that will give me the complete schedule fo...

Hi,How do i update my existing blob data in my database...For e.g my table has following column :-varchar classname, int idnum, image data.i have my new blob in my Byte[] newdata;how do i update.update mytable set classname = 'newclass', data = ?( newdata)where idnum = searchnum.Thanks,Sam...

Could anyone of you here introduce me some tutorials or good books on database ? Especially those for beginners...Since I am absolutely new to this major and I find it quite hard for me to make some clear understandings of what my teacher explains in class, I would also like to ask for your instruct...

How to set the variable value from the "inserted"?Here I want to insert value inserted into one table, insert another tables too.but I have error in red line,May be there are other ways to do that?CREATE TRIGGER GeneralInsertON PersonalFile FOR INSERTAS BEGIN DECLARE @PF varchar(10)SELECT Personal...

Please can you find a solution to this error"Error Type:Microsoft OLE DB Provider for ODBC Drivers (0x80004005)[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6f8 Thread 0x5dc DBC 0xc7203c Jet'./npsa/Admin/Aler...

Hi,Access 2000 provides a facility to prevent record deletes when creating a replica database from the command menu.The only options when creating a replica via DAO are 'make read only' or 'make partial replica'.Does anyone know how to 'prevent deletes' with a coding op...

I am currently trying to save encrypted data to a field in an Oracle 8i database table. I currently have the field set up as a datatype of VARCHAR2(500). The value that is being sent to the database with the SQL statement is not the value that is showing up in the data of the table. For example t...

does anyone out there know how i can debug server-side pl/sql in real time so to speak, using live data??All pl/sql debuggers out there dont seem to have this functionality, but you guys out there must have a way of doing this.. I dont think there is anything like a DebugBreak() in c++ for pl/sql so...

Hi, plz, help me with the following, (the code is attached)Trying to insert, I have the following message:(1 row(s) affected)Server: Msg 8152, Level 16, State 9, Procedure Trig_PUD, Line 8String or binary data would be truncated.The statement has been terminated....

Hi,<br/>Does anyone have an example of how to retrieve a field description using ADO? I'm using microsoft access for the database.<br/>Thanks a lot,<br/>Beatrice

Hi,we currently try to develop an application, which is capable to work with different databases. The interface is ADO. The problem is that the some providers (native ADO Access 2000, SQL Server, ODBC for MySql,...) behave different in the SQL syntax, they accept. For example in a SQL-join, some pro...

Can anyone tell me what are the limits of the free SQL License?<br/>Thanks

How to insert single quoted string in text field of a database<br/>eg:factors to Alzheimer's disease (AD)<br/>Thanks<br/>Vidhu

Hello my new friends at CG..I found out this site when i was browsing around for information on database management systems. The situation is that I am doing my First year of post graduation in computer science in Pune, India. The course we are doing is M.Sc. in computer science. We have a DBMS imp...

Hello, I have the table below:[ ID ] [ NAME ] [ RELATED_ID ][ 1 ] [ Item_1 ] [ 3 ][ 2 ] [ Item_2 ] [ 1 ][ 3 ] [ Item_3 ] [ 5 ][ 4 ] [ Item_4 ] [ 4 ][ 5 ] [ Item_5 ] [ 1 ]How can i query the following output ?[ ID ] [ NAME ] [ RELATED_NAME ][ 1 ] [ Item_1 ] [ Item_3 ][ 2 ] [ Item_2 ] [ Item_1 ][ 3 ]...

I'm kind of new to writing SQL queries and all. I was wondering, can any changes be made to anything in a database using a SELECT statement?

Hello, I have the following table, [ id ] [ name ][ 1 ] [ A ][ 1 ] [ B ][ 2 ] [ B ][ 3 ] [ C ][ 3 ] [ D ][ 4 ] [ A ][ 4 ] [ D ]I want to get the following output, is it possible?[ id ] [ list ][ 1 ] [ A, B ][ 2 ] [ B ][ 3 ] [ C, D ][ 4 ] [ A, D ]Thanks in advance,abkkn....

Hello .. I very interesting Replication Technology,but i don't know clearly understand how to use.Here is my problem let me tell you.. In my environment we have one server and two client.i am one client owner.We using SQL 7 DB.We are already connected with server.In my client ,i have student...

We have a site developed using J2EE Technology. The DB is Oracle 8.1.7 and Application Server is Weblogic 5.1 SP 11 both running on Red hat Linux 7.2.Some times when browsing the site the weblogic gives an errorError ORA-03114 : Not Connected to Oracle.Can you suggest something.Regrds,Shivakumar...

Replication Problem in SQL Server.<br/>I am about to implement replication server in my real life projects for multi-place deployment.<br/>Anyone want to share the problems I may encounter?

Hi,Does anyone know how to set the current selection in the DataCombo control?In the Combobox I think there's a SetCurSel method, but this method is not available for the DataCombo control.Please help, I've been trying to figure it out the hole day.I'm using ADO and the binding code i...

I want distinct result but its still giving me duplicate record query is belowSELECT RegisteredUser.*, UsersGroup.GroupFROM RegisteredUser RIGHT JOIN UsersGroup ON RegisteredUser.Email = UsersGroup.Email;RegisteredUser is a table ,its primary key is a test feild and both table are in one to many rel...

Hi,I just wanted to post this for an Example.I ran into a situation where I needed to increment a Revision. The revision could be up to two letters in length. The following code works well. Please let me know if there are any questions.declare @r varchar(2)declare @MaxRevLetter INTdeclare @series...

Is there any advantage or disadvantage with the DBLib API<br/>coming with Microsoft SQL server when compared with ODBC<br/>or OLE DB Data Access in terms of speed and performance.<br/>thanks<br/>Suresh.

I'm looking into the possibility of creating a standalone application that will be distributed to certain employees of the company I work for. I was considering using Access 2000 as the database backend for the VB frontend. The problem is that not all of the users have Access 2000 already, and...

Hi guys,I have a MySql DB, I was wondering if I have a newer version of a table can I just simply copy the data file (.MYD) to the data directory and the table is updated, I have concerns that the DB will not let you copy the file because it is in use and will need to stop the service to overwrite.N...

Hi all,I'm want to make a list of birthdays of my friends.Now, I wish to make it send greeting card by e-mail automatically every week.I have a seperate asp file that can do it but how can I make him proccess itself (or sql server to run it) every sunday morning?any ideas?...

In cases of selects with very large results, which is the optimal desired size of the results ? (to be truncated to)<br/>that would be intended to be fetched with ADO.NET

hi,i've currently develop a chat application using java. I now ned a database(mysql) to store my user personal data & password).1)other than downloading mysql(since it is open source), what else whouls i take note?? 2)If i 1 2 connect the mysql with my java program using the windows existing "s...

Hi everyone,I am using a Stored Procedure to try and select data from a table where the ID is matching the value of a variable that I passed through, and a certain field (Sales) is null. This is my code in my Stored Procedure.....CREATE Procedure accounting.BookingsFollowUp_s( @JwlrNo char(6))A...

I DELCARE PARAMETER WW AS NVARCHAR(100)AND I SET @WW=' BRANCH=5'AND I WANT TO BUT THES PARAMETER IN SELCT STATMENT LIKE IN TSQL QUERY DESIGNERIN SQL 2000IF @WW IS NOT NULLBEGINSELECT * FROM COUNTS WHERE @WWENDBUT ITS GIVE ME ERROR ANY HELP PLZ ON THES MATTER.THANK YOU...

Hi gurus,<br/>I have Wondows 2000 professional installed in my cmputer. Can i install SQL server 2000 in my computer with all the features?<br/>Because i could install Only client componets in XP<br/>Please clarify me

Declare @fromitem varchar(15), @toitem varchar(15)set @fromitem=10set @toitem=60select categoryid,categoryno ,@fromitem , @toitem from category where categoryno>=10 and categoryno<=60thes must return categoryno between 10 and 60 but it return 1 and 2 and 3 and......Why?Categoryno varchar(15)...

I have developed a program that uses MSSQL2K extensively. I need to deploy this application onto a machine that does not have MSSQL2K. Using Access, I know you can deploy without having to install MS Access. <br/>Can the same be done using MSSQL2k ?

Hello mates,I have a database, made in SQL server,and i have records, of the all the telephone company's clients, kept in multiple tables.I am stuck on the part of name searching, !!!! as the requirement is, that the search shall forgive spelling mistakes in names, since many poeple spell their...

Hi,I have a MFC database application which uses MS Access mdb's. It works fine on Win NT and Win 2000. But when the same code runs on Windows XP I get a errror mesage box saying 'Invalid password' and the tile of that mesage is ODBC Microsoft Access Login Driver Failed. The MS Access...

:confused: <br/>I am using DSN less connectivety and trying to retrieve all records in a single textbox one by one by using next button from the database,but only first record is retrieved.<br/>How can I retrieve next record?:confused:

Im working with an Access Database doing data validation stuff and its been awhile for me.Im currently using find and replace to remove all Capital Letters, for example; or remove all the sentences that begin with a comma. But, id rather use an update query.How, without using variables, can I repla...

I want to develop urgently using replication technology.<br/>Who want to share your knowledge?<br/>I really appreciate your suggestion.

I'm have inherited a PL/SQL trigger that selectsthe os_authent_prefix from v$parameter .But, I'm getting this error in user_errors for the trigger declared in thescript;PLS-00201: identifier 'V$PARAMETER' must be declaredBut I do not get the error when I compile the trigger as a...

I have an Access Database, and write a small program to update a table (A) using linked table (LINK_B). (I need some other steps to do, so I'm using VB, not VBA in Access)When I try to run a Query from VB to update table A, I always get the error:"The field is too small to accept the amount of...

I have an app. that connects to a database and linked to one table of that database. i would like to be able to use 2 tables at the same time. how do i open more than one tables in the application.<br/>thanks <br/>brian

Hi ,I have created a database using MS 2000 Access on a machine running win2K and all the code done in the VB window. I tried to place this database on a windows 98 machine running office 2K. Whenever i try to view my code on this machine i get a out of memory error message. also when i click on som...

I am new to database design and I am not sure of the most secure way of doing the following:There are 3 tables, tblProjectInformation, tblContractorInformation, and tblContacts. Now in the tblProjectInfoamation, I have the fields contractor and contact. 1) What should I use as the primary key in th...