Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by xavstone

  1. xavstone

    Finding a contextmenustrip strip added in design time.

    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...
  2. xavstone

    Cannot perform and aggregate function on an expression...

    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...
  3. xavstone

    Invalid object name 'pos'.

    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...
  4. xavstone

    Dynamic SQL headache

    Wow, thanks for all the tips guys! Esp Markros for actually rewriting my rubbish SQL! :-D Sorry for late reply been on holiday. Thanks again. Xavi
  5. xavstone

    Dynamic SQL headache

    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...
  6. xavstone

    INSERT INTO not inserting - losing will to live, please help!

    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...
  7. xavstone

    INSERT INTO not inserting - losing will to live, please help!

    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...
  8. xavstone

    How to update an existing table with a new uniqueidentifier column?

    ah! *Slaps forehead* Thank you very much :) Ben
  9. xavstone

    How to update an existing table with a new uniqueidentifier column?

    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...
  10. xavstone

    Foreach loop through sqldatasource result set

    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
  11. xavstone

    applet coordinates

    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.
  12. xavstone

    applet coordinates

    lo all, how can i return an applets screen coordinates. i.e. the origin at the top left corner of applet. thanks...
  13. xavstone

    Text file parsing

    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...
  14. xavstone

    Text file parsing

    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...

Part and Inventory Search

Back
Top