|
Don't cross post.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I need a solution.
Assmbler
|
|
|
|
|
Cross posting to demand a solution from people isn't the ideal approach, either. Now, that aside, what have you tried doing with your problem so far? What is the field type you are using in Access to store the attachments? Are the attachments of one type, or is it various types of file formats?
People will need a little more detail if you expect any real help.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
The field type is Access2007 Attachment data type,the files stored in those fields are 90% jpg images plus some png and bmp images, When I try to get the contents of the field in c# it only returns their file name, I'm sure that there must be a way to get files from db. VBA has LoadFromFile and SaveToFile functions for working with attachments, but We need the equvalent ADO functions.
Assmbler
|
|
|
|
|
Could you show code example why you are just getting the filename in return?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Thanks for the reply.
strCmd = "SELECT FLAG FROM SongsFlagsContinents WHERE SECT='" + CountryName + "'";
cmd = new OleDbCommand(strCmd, Main.Connection);
cmd.Connection.Open();
rdr = cmd.ExecuteReader();
rdr.Read();
MessageBox.Show(rdr["FLAG"].ToString());
cmd.Connection.Close();
where FLAG column is an attachment column with image(s) attached.
|
|
|
|
|
Hi!
I am experiencing the following error and I couldn't find a solution. UserType field doesn't allow null values in the table as it has defined so. Before I INSERT the value for the field I get 1 as a value ofor the USERTYPE field. The data types are identical in both table and in the stored procedure.
I am using VS2008 and with SQLEXPRESS 2008.
However It pops up the following error message. If you know the solution, please let me know.
<br />
<br />
Cannot insert the value NULL into column 'UserType', table 'HolidayDB.dbo.Administration'; column does not allow nulls. INSERT fails. The statement has been terminated.<br />
<br />
'USER TYPE DEFINITION IS AS BELOW<br />
<br />
SetUserType = New SqlParameter()<br />
SetUserType.ParameterName = "@GetUserType"<br />
SetUserType.SqlDbType = SqlDbType.BigInt<br />
SetUserType.Size = 8<br />
SetUserType.IsNullable = False<br />
SetUserType.Direction = ParameterDirection.Input<br />
SetUserType.Value = CType(GetUserType.SelectedValue, Object)<br />
MYCOMMAND.Parameters.Add(SetUserType)<br />
<br />
<br />
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Could you post the SP?
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
Thanks for responding. Here is my stored procedure but none of stored procedures are functioning in SQL server. I have no idea why. I am able to insert a data into tables by querying but when I try to invoke a stored procedure I always get an error message. For the following storedprocedure I get "@GetUserType is not supplied " error message even I supply the data.
Thank you.
ALTER PROCEDURE dbo.StoredProcedure3
(
@GetUserType bigint,
@GetAccountStatus bit,
@GetTitle nchar(10),
@GetFirstName nvarchar(50),
@GetMiddleInitial nchar(2),
@GetLastName nvarchar(50),
@GetEmailAddress nvarchar(125),
)
AS
INSERT INTO Customer
VALUES (
@GetUserType,
@GetAccountStatus,
@GetTitle,
@GetFirstName,
@GetMiddleInitial,
@GetLastName,
@GetEmailAddress,
EXEC StoredProcedure3
RETURN
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Hmm...Despite some sintax errors I could notice in the procedure (maybe from when you paste in here), I think you're problem could be the way the procedure is executing the insert.
When you do:
INSERT INTO Customer (Field1,Field2) VALUES (Value1,Value2);
You are addressing the values (Value1,Value2) in the corresponding order as the appear in the field list (Field1,Field2), but as you did:
INSERT INTO Customer VALUES (Value1,Value2);
You are putting the values in the order the fields appear in the table, so if the table has one more column or a column in the wrong order, you could get unwanted results.
Try using the first form of insert. If it did not work, post the table structure to see if we can help you.
Regards
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
Thanks Cio!
The INSERT syntax I have used is correct in SQL 2008. The syntax you have suggested to me for use is causing an error when I try to save it as a stored procedure. I am experiencing the same problem for all the other stored procedures in SQL SERVER. I am newbie to SQL and I have no idea what is causing the problem. When I use query, it is working fine but when I try to invoke a storedprocedure, it is causing an error.
The table structure is as show below.
COLUMN NAME DATA TYPE ALLOW NULLS
(PK)CustomerNumber bigint False (IDENTITY COLUMN)
(FK)UserType bigint False
AccountStatus bit False
FirstName nvarchar(50) False
MiddleInitial nchar(2) True
LastName nvarchar(50) False
EmailAddress nvarchar(125) False
What a curious mind needs to discover knowledge is noting else than a pin-hole.
modified on Sunday, September 21, 2008 5:40 AM
|
|
|
|
|
Hi,
Basic cause for this is that for some reason you are trying to insert NULL to GetUserType. Reasons in your case could be:
- parameter SetUserType has a value of NULL when call to sp is made (but I understood you have checked this)
- when using INSERT syntax where you don't define columns for the values, you can get mixed in column order as Caio pointed out. Modifying the insert statement to following may help. Also notice GetTitle parameter. Didn't find any corresponding field in your table based on your description
INSERT INTO Customer
(
UserType,
AccountStatus,
FirstName,
MiddleInitial,
LastName,
EmailAddress )
VALUES (
@GetUserType,
@GetAccountStatus,
@GetTitle, <-------- Where is this parameter going
@GetFirstName,
@GetMiddleInitial,
@GetLastName,
@GetEmailAddress)
- also I noticed the call to StoredProcedure3 inside the values portion. Is this intended
@GetEmailAddress,
EXEC StoredProcedure3 <------
RETURN
Mika
The need to optimize rises from a bad design
|
|
|
|
|
Thanks a lot!
The problem has been solved. The EXEC statement was causing the problem. I removed it and then it worked. 
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
You're welcome 
Mika
The need to optimize rises from a bad design
|
|
|
|
|
like it shows the table has a column that can not be null!!!
go to sql server and set column to allow nulls, then if you have to enter a null value code like this in c#:
...
sql_cmd.Parameters.Add("@GetUserType", SqlDbType.BigInt).Value = DBNull.Value;
...
ok? the parameter will be set for null
my coding is diferent, don´t know if your doing it right but check this in your code also:
JUNEYT wrote: SetUserType.IsNullable = False
That is c# code you are in the wrong forum!!! others will not anser to your post ok?
Good luck!!! 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Dear ALL,
I am not getting SQL Server Databse files in the installer
It gives only 2 options of SQL Server Native Client & SQL server Setup support files,
i have checked the files & it was installed over my home PC Easily but its not getting successful over my office PC, i have 4, 5 different DVD's of it & tried over 3,4 different PC but not getting the trouble identified , also i have checked added program list in control panel , no SQL instance was found before, kindly help me in this regard.
|
|
|
|
|
Hi , hw can i give permission so that no one can change my code in stored procedure , and only particular member insert , update , delete my stored procedure which i make in my own database.
Thanx in Advance
|
|
|
|
|
You create specific database users, then let the clients connect to the db with the appropriate username & password
|
|
|
|
|
Harvey Saayman wrote: clients connect to the db with the appropriate username & password
Or use a trusted connection - Must better than exposing passwords in connection strings.
|
|
|
|
|
allow users only to trigger your store procedures, if you only build reports procedures they cannot change data.
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi,
A very newbie question to all you learned folks. I am writing a trigger through Enterprise Manager (using the option New Stored Procedure...)
The following is my code
create trigger trig1 on table1
for insert
as
select * from table2
go
When I check the syntax by pressing the Check Syntax button it says Syntax Ok but when I press the OK button to close the stored procedure editor
it states the following error
Error 21001:[SQL-DMO]Stored Procedure definition must include name and text (for StandardStoredProcedure or library name for ExtendedStoredProcedure)
Now the stupid question, how do I write a trigger through SQL Enterprise Manager for a particular table.
|
|
|
|
|
What are you really trying to create? A trigger or a Stored Procedure?
Intelligence is almost useless for those who have nothing else!
Email: caiokf@gmail.com
|
|
|
|
|
If you're creating a trigger, don't use New Stored Procedure in the management studio, instead:
- navigate to the table you want to create the trigger on
- expand the tree
- select Triggers
- and then New Trigger option.
Mika
The need to optimize rises from a bad design
|
|
|
|
|
I have tried MSSQL 2000 server error handling part but I still have Error Message in SQL Analyzer. I called the procedure from the application and it failes because of Error Message. Is it possible to eliminate error message ?
|
|
|
|
|
Yes, fix the cause of the error!
You haven't given anyone much information to help, have you?
Bob
Ashfield Consultants Ltd
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
