|
Pete O'Hanlon wrote: post the question on the forum for that software or email it to the company in question
I did that, and mailed on id they had provided on their site.
Pete O'Hanlon wrote: the error message looks funnily like you attempting to issue a SQL command on a closed connection
Any one who know English will say what you had...!!
But its like this, its giving an error like this.
But i couldn't understand, if i use single select statement its running
But the actual procedure i need to call, creates a temp table , insert data in it and then drop this table.
its giving error in this?
|
|
|
|
|
Hum Dum wrote: But its like this, its giving an error like this.
But i couldn't understand, if i use single select statement its running
But the actual procedure i need to call, creates a temp table , insert data in it and then drop this table.
This is why they are better placed to solve this than we are. How on earth do you expect us to know what it's doing internally? I would expect that it's expecting a query and you are supplying it with DML and that's causing it to bork. Again - they will know the answer.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
1) You are talking about an error with a third party application.
2) You have not provided any code.
It will be tough for anyone to help you in those circumstances.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
|
|
|
|
|
string SQL = "SELECT `Calories` FROM `NutritionInformation`";
Engine btEngine = new Engine();
LabelFormatDocument btFormat = btEngine.Documents.Open(@"C:\NutritionLabel.btw");
((OLEDB)btFormat.DatabaseConnections[0]).SQLStatement = SQL;
Well above is part of code. Which i used mentioned at their SDK help file.
I am replacing the SQL with sql i want to use - Working
I am just mentioning SP name in SQL (Sp contain only single Select) - Working
But when i call SP which i had to use actually, its giving error.
For above code to work you have to download their SDK and install it, then add reference to Seagull.BarTender.Print.
|
|
|
|
|
Well - you could try searching for a similar problem on their forums.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
|
|
|
|
|
This is a complete guess as I have never even heard of that product before but do you have the correct permissions to connect and run a stored procedure? Sorry if that is complete bollocks but worth a try.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Hallo
I'd need to write into a textbox of an external application.
Investigating with Spy++ I found that its controlID changes: the only thing helping to identify it unequivocally is the Class attribute: it is the only control of that Class in that form.
How could I address the textbox by this value?
Could you post a snippet?
Thanks in advance
|
|
|
|
|
the search is your best friend
try searching like TextBox Text Win32Api
|
|
|
|
|
thank you for the reply, I previously did a search and adapted a snippet found on Stackoverflow.com, but it (and many other examples in the net) shows how to address controls by their handle.
In this case, I have a control contained into a modal window addressable by portion of its name (the only part that doesn't change).
|
|
|
|
|
I guess that would be done using the FindWindowEx [^] function. At least, that way you could retrieve the current handle.
I are Troll
|
|
|
|
|
I have two tables: table1 field contains the ID type UniqueIdentifier and table2 contains ID as foreign key when inserting values is not the same values filled in the two table table1 in this ID is filled eg e210d5ad-BC41-439th-b8e8-e8ed775ee932, and in table 2 it is filled with zero
So how do I do to unify all relationships necessary is active
the two queries are:
CREATE Procedure [dbo].[Insert1](@ID uniqueidentifier, @name varchar(10),@tel varchar(10))AS INSERT INTO [table1] ([ID], [name], [tel])VALUES (NEWID(), @name, @tel)
CREATE Procedure [dbo].[Insert2](@ID uniqueidentifier, @cmd1 varchar(20))AS INSERT INTO [Table2] ([ID], [cmd1])VALUES (@ID, @cmd1)
table1: ID Primary key
Table2:ID foreign Key
Thank you very much for your help
|
|
|
|
|
You don't need procedures for this, but if you do, why not have both statements in one procedure?
With SQL Server, even when using SQL in your code, you can have both statements in one command.
But the important thing is to generate the Guid in code (don't use NEWID() in this case), before executing the SQL. Something along the lines of:
System.Guid ID = System.Guid.NewGuid() ;
cmd1.Paramaters [ "@ID" ].Value = ID ;
cmd2.Parameters [ "@ID" ].Value = ID ;
Knowing the ID before hitting the database is one of the benefits of using Guids as keys.
|
|
|
|
|
thank you very much, it works very well, I have not used newid() in the stored procedure, and I put in the code GUID.NewGuid (), thank you again
|
|
|
|
|
Please post your questions to one forum only!
You posted this very question just a few minutes earlier to the General Database forum...
|
|
|
|
|
I am developing a small image editing program and the output is in a compress tiff file.my program runs well in my workstation which is win7 but when i try to run my program in winXP,it throws an exception "paramater is not valid".the exception is caused by my compression that am using,which is CCITT4.is there any other way to make CCITT4 work in winXP? thanks a million guys...
|
|
|
|
|
The first thing you should do is read the posting guidlines above in "How to get an answer to your question[^]" in regard to your subject. Everyone posting a question is here for help, the fact that it's urgent for you is irrelevant and writing in upper case is SHOUTING and considered very rude.
If you edit your subject then you are far more likely to get useful, timely responses.
DaveIf this helped, please vote & accept answer!
Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
am sorry abnout that...my deepest apology...
|
|
|
|
|
Hi i have created a generic collection . I have My custom class.
When i am adding objs of my custom class in the collection .I am not able to
Search remove from the collection even i contains() method is not working .Can u plz Tell me where i am wrong. Or How should i do this.
public class GCommon<T> : Collection<T> where T : ICommonInterface
{
new public void Add(T item)
{
if(!base.Contains(item))
base.Add(item);
}
public void Clear(T item)
{
foreach (T it in base.Items)
{
if(it.Equals(item))
base.Remove(item);
}
}
new public bool Contains(T item)
{
bool retval = false;
foreach (T itm in base.Items)
if (itm.Equals(item))
{
retval = true;
break;
}
return retval;
}
}
public interface ICommonInterface
{
}
public class clsContent : ICommonInterface
{
public clsContent()
{
}
public clsContent(int id,string Name, string Content)
{
_Id = id;
_ContentName = Name;
_Content = Content;
}
private int _Id;
public int Id
{
get { return _Id; }
set { _Id = value; }
}
private string _ContentName;
public string ContentName
{
get { return _ContentName; }
set { _ContentName = value; }
}
private string _Content;
public string Content
{
get { return _Content; }
set { _Content = value; }
}
}
|
|
|
|
|
montosen wrote: public void Clear(T item) { foreach (T it in base.Items) { if(it.Equals(item)) base.Remove(item); } }
You cannot remove an item from a collection while enumerating over the collection with a foreach . Youd would have to use an index into the collection instead.
Also, the name you picked for this method, "Clear", would tell me that the method removes all items from the collection, not just a single element. "Remove" would be a better choice.
Why are you even implementing this Clear (Remove) method when the base Collection class already implements it?
|
|
|
|
|
if i am using a collection of int,string or any system defined data type base.Remove(item); is removing the item
but when i am a custom class in this case clsContent it is not removing the item from collection .
Offcouse i can use base.Remove(item); instead of clear
can u plz tell how i use <code>base.Remove(item);</code> and not using any index
|
|
|
|
|
montosen wrote: can u plz tell how i use base.Remove(item); and not using any index
Use a for loop rather than a foreach .
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
hi
how is it to write a remote desktop server or client?
thanks
|
|
|
|
|
This is not something that can be answered in a forum like this. There are many articles here[^] that will help you. Try a search for "client server".
It's time for a new signature.
|
|
|
|
|
hi,
It's not that I'm try to be mean, but you shouldn't ask such wide questions.
Get some information, start your project and if you stuck in some point maybe someone can help you.
|
|
|
|
|
If you have implemented anything so far, post the problem you are facing here on this forum.
Otherwise, do a search on the internet and you might find some samples.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
|
|
|
|