|
i used Vb6 front end to fire the Proc, when save button is click the it become disabled and the recordset move to the First record, so there is no way to be fired twice.
what do you think is Wrong? Do you want me to send you the vb6 code?
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: what do you think is Wrong? Do you want me to send you the vb6 code?
No.
If I were you, I would take a look at using the SQL Profiler to see what is actually coming across. For an example of how to do this, read this article Clickety[^]
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
AM NOT SURE, I THINK THE pROBLEM IS IN MY BUTTON, THIS IS THE CODE IN MY BUTTON TO SAVE .
Private Sub cmdAdd_Click()
rrs("Num_key") = txtnumkey
rrs("EXTENSION") = txtextension
rrs("Actual_Extent") = txtactualextent
rrs("Lis_key") = txtliskey
rrs("Func_Key") = txtfunckey
rrs("Prop_Category_ID") = txtcategory
rrs("GEOCODE") = txtgeocode
rrs("Add_Date") = txtadddate
rrs("Add_user_ID") = txtadduserid
rrs.Update
cmdNew.Visible = True
cmdUpdate.Visible = True
cmdRefresh.Visible = True
cmdDelete.Visible = True
End Sub
IS IT CORRECT?
Vuyiswa
Vuyiswa
|
|
|
|
|
Hi
I have SQL server installed in a machine. From another machine if I create a DSN using windows authentication, I am getting an erro message.
Thanks
|
|
|
|
|
Windows Authentication means that the user account that the client application is running under is the account used to connect to SQL Server. That means that either the server and client must be in the same Windows domain or forest or that the server and client domains/forests must trust each other, or that there must be a Windows user account on the server with the same username and password as the client software runs as.
In addition, the user, or a group that the user is a member of, must be granted a login on the instance of SQL Server that you're connecting to, and that login must be mapped to a user or role in the database you're trying to use.
|
|
|
|
|
Hi All,
what is the use of import or export feature in SQL Server2000
and also wht is the difference between import/export and backup/store database
|
|
|
|
|
These options are provided for the movement of databases!!!
Let us say you have Database A and now you created Database B and in this you want the same data aso Database A then you can use these options.
Other example would be, If you want get to data for DataBase B from any other source like Access then again you have to use these options.
Gautham
|
|
|
|
|
Hi All
I am doing an analysis on a web project whre the estimated number of concurent users is between 2000 & 3000.
In this project iam doing tracing and need to put this trace in SQL table. my question is how many rows can this table hold knowing that number of records per year is between 2 & 3 millions. This table will take time when trying to query data in it.
What strategies must be taken?
Thanks
|
|
|
|
|
You can easily insert this number of records into a SQL Server table. If you want to query the data in the table, you may want to copy it into a different database and add additional indexes to speed up the querying (or you could look at using an Indexed view on it).
If this is a really active table that only uses inserts, then don't put any indexes on it other than a primary key. Use the suggestions above for reporting purposes.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi there,
If I use SQL Server Migration Assistant for Access to convert my Access database to SQL Server Database, it adds constraints to each string type data column in my SQL database. Why is that? I've checked the string values in my Access database, and they do allow Zero Lenth values. If I add that Access database to my SQL Server Migration Assistant for Access project, and I select a Table to see the design of it, the Allow Zero Lenth flag is false. I want those characterlistics to be the same as in the Access Database. Is there a way to do that?
Thanks,
Werries
A programmer's life is good... or is it?? Ek dink nie so nie!
|
|
|
|
|
I have written a SQL procedure to send mail using CDONTS. Now I want to specify Smart Host name in the procedure itself instead of specifying it in the IIS(Default SMTP Server). How I can do that.
thanks in advance
|
|
|
|
|
hello frnds,
I have a problem
i have 3 tables updating one by another if any of the update query get failed the whole transaction should be rollback and if the update query get successful then the transaction should be get commit,
i have called three methods for three table and if exception occour then in last method transaction object as rollback but failed...
plzz help me....
thankx in advance
-Koolprasad2006
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
begin transaction
update statement1.......
if(@@error<>0)
begin
rollback transaction
end
update statement2.......
if(@@error<>0)
begin
rollback transaction
end
update transaction3......
if(@@error<>0)
begin
rollback transaction
end
commit transaction
end
Try this out, hope this works if not will look for other options.
Gautham
|
|
|
|
|
Hi All,
I have one connection string which can be of MySql, Sql Server , Orable , access or anything.
i have create OdbcConnection object from connection string. now i want to know which DBMS i am using... any idea how to ? 
- thanks & ragards
- Sanket
|
|
|
|
|
You can always retrieve the connection string from the connection object.
|
|
|
|
|
but that is not giving me what i want.
e.g. oracle will give me DBQ=ORCL which can be configured as well.
|
|
|
|
|
hi
i am converting stored procedures in sql server 2005 to oracle 8i.
In one of the procedure they are using an insert statement which calls another stored procedure..
how can i convert this to oracle 8i..
eg;
insert into table1
exec test_procedure
|
|
|
|
|
I have a feeling that you cannot execute Stored Procedure in DML statements though functions can be used.
Am i wrong?
Gautham
|
|
|
|
|
Possibly return a cursor in the stored procedure, then iterate over that cursor to insert each record.
You may get more joy from a more Oracle-specific forum.
|
|
|
|
|
Hi
i m using javascript to open a popup window and want to paa one value from parent window to popup window. i need to use that value in my javascript function but i m not getting the point to retrieve the query string value using javascript.....
can anyone help
Thanks
Dinesh Sharma
|
|
|
|
|
|
hey Dinesh,it's easy
use the window.open() method and pass the desired value as a parameter the wll be get inherited on pop-up window
Best Luck
-koolprasad2006
Be A Good S/W Eng... Life is swing with you..Enjoy..
|
|
|
|
|
I have the following stored procedure that works except that the "print" does display on the page when the "IF" condition is met...it shows up as a message when run from Query analyzer but not when the stored procedure is called.
Can anyone tell me what is wrong with my print? I have tried a few things with no success just errors. the solutions I saw in books online did not work for me.
here is the stored procedure:
(
@ticketid as varchar(20)
)
AS
Declare @Technician as varchar (40)
declare @count int
set @count=(Select count(*) from job_ticket WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20))
and status_type_id like '[1-2]')
if @count =0 print 'there are no open tickets'
set @Technician=(SELECT email
FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assigned_tech_id WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20)))
SELECT job_ticket.job_ticket_id, job_ticket.question_text 'Report', 'Ticket Number', @Technician
'Technician Assigned',job_ticket.subject 'Issue Description',
report_date 'Open Date'
FROM job_ticket WHERE job_ticket.job_ticket_id =Cast
(@ticketid as varchar (20)) and status_type_id like '[1-2]'
-- modified at 20:56 Thursday 17th May, 2007
Regards,
Hulicat
|
|
|
|
|
How are you running your stored procedure?
Under ADO, a print statement does not create a resultset. Instead it adds an item to the Connection.Errors array.
Normally I would do the zero-records check back on the front-end (because the resultset is empty).
Also, most people add "SET NOCOUNT ON" to the top of their SQL-Server stored procedures.
|
|
|
|
|
Thanks for the tips, they are greatly appreciated.
Regards,
Hulicat
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
