Ok so I added a contextmenustrip to form1 in a winforms app. I have a standard class elsewhere that takes a treenode as a parameter and does things to it. One of the things I would like to do is set the context menu. The context menu was added to the form manually at design time.
I have tried...
I am getting the error: "Cannot perform and aggregate function on an expression containing an aggregate or a subquery."
on this portion of my query:
(SELECT SUM(
CASE
WHEN closeDate > '1950-01-01' THEN closePrice
WHEN closeDate < '1950-01-01' THEN
(SELECT dbo.symbolData.priceClose
FROM...
Hi all,
Any ideas why 'pos' is an invalid object name?
Thanks in advance,
Ben
ALTER PROCEDURE dbo.PortfolioReport
@portfolioId int
AS
SELECT
AVG(DATEDIFF(day, openDate, closeDate)) as 'Average Length',
MAX(DATEDIFF(day, openDate, closeDate)) as 'Longest',
MIN(DATEDIFF(day, openDate...
Hello chaps,
Any ideas why this wont work? Apparently varchar and unique identifier cannot be used with the + operator. New to dynamic SQL so havent a scooby...
Thanks in advance.
ALTER PROCEDURE dbo.AddPriceDataToExchangeTable
@symbolId uniqueidentifier,
@date smalldatetime,
@dateId int...
Finally figured it out. It was nothing to do with my code but the way Visual C# compiles. Basically it copies across the previous version of the .mdf file (the one prior to the build) back to the working directory after the solution is closed again. Or something similar.
I got round this by...
Hi All,
Have come back to programming after a lengthy break for a personal project using visual c# and SQL Server Express in a win forms app.
The problem I have is that my INSERT INTO statements are not working, while my SELECT statements are working perfectly.
While debugging the command...
Hi All,
I have added a uniqueidentifier column to an existing table in Microsoft SQL Server.
All I want to do is populate the existing records with new Guids. I have tried things based on this to no avail:
@GUID uniqueidentifier
AS
UPDATE sysx_groups SET GUID=@GUID
RETURN
Any help much...
Hi All,
I am trying to find a way to loop through the results of a stored procedure using foreach. Its part of an approach to populate a treeview.
I was hoping that some of you could provide an example snippet on how they might go about it.
Thanks as always in advance...
Ben
i needed to know the position of the applets screen coordinates. i found them by calling this.getLocationOnScreen(); in case antbody else needs to know. 'this' being the applet component itself.
thanks for that bill, i did this with it:
import idi.*;
class idi.trimesh {
//Mesh data
public var vCount:Number;
public var vList = new Array();
public var tCount:Number;
public var tList = new Array();
public var intext:String;
public function trimesh() {
vList.Array = null...
Hi all,
I need to parse text in a file into an array. The file type im trying to read is an .obj file. In c# i would just create streamreader object and get parsing. But new to actionscript(v8). Obj files store information like this:
v 123 145 234
v 234 245 242
...
where v indicates the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.