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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. robertkjr3d

    xp_cmdshell runs as administrator but not with access

    Ok got it!!! I'm guessing the ImageConverter guys are comparing the entered username and possibly ignoring the domain of the user logged in. For I originally had activated the account in when I logged in with 'Administrator' as the username and in the domain box {our domain}. However If I...
  2. robertkjr3d

    xp_cmdshell runs as administrator but not with access

    Let's start with the bottom line: I can login to the machine as Administrator... and the command line product works. When I run the same command line app from xp_cmdshell running as the same user 'administrator' it does not. Long Description: I have this software that I'm calling from...
  3. robertkjr3d

    Dynamic calling of members

    Can I also call a function that way... In earlier code... if I didn't get the compile error it would be: parent.go(); How would I call a function undernearth an unknown form with this interface stuff?
  4. robertkjr3d

    Dynamic calling of members

    How do I programmatically call a member of an unknown type? I have form A... which opens up another form B. However Form A will be the parent of B. In fact I have this code: listing list1 = new listing(); list1.parent = this; list1.Show(); In list1 parent is an object. Because it could come...
  5. robertkjr3d

    Datagrid edit... but not add row

    Yes sir... that's it! But I'm doubting there is a 'AllowAdd' = false
  6. robertkjr3d

    Datagrid edit... but not add row

    Yes... But the Datagrid at least gives them the look of an add row. I don't want to make them think that they can add a row.
  7. robertkjr3d

    Datagrid edit... but not add row

    I have a datagrid in a C# Win32 application in VS03. I do wish to be able to edit rows.. (or the one row). But I do not want to allow adding rows. How can I accomplish this? I know this is something simple, but my brain is not giving it to me.
  8. robertkjr3d

    Dynamic variable names

    Oh yes... already did. But with 70 fields inputed, I didn't like it. It's ugly, but it works. I was just having fun arguing the language issue.
  9. robertkjr3d

    Dynamic variable names

    Here is a more official article with the words "execute function" in the first bolded sentence. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro2k/html/sql00g7.asp
  10. robertkjr3d

    Dynamic variable names

    http://www.4guysfromrolla.com/webtech/020600-1.shtml http://blogs.msdn.com/mrorke/archive/2005/10/24/484237.aspx http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=210272&SiteID=1 Apparently I'm not the only one that defies your language issue! and the above links are only a few... search...
  11. robertkjr3d

    Dynamic variable names

    http://www.dictionary.com 8) Computer Science. A procedure within an application. This is certainly true is it not? Can you find a definition of function that doesn't fit? I asked you what your definition was.
  12. robertkjr3d

    Dynamic variable names

    umm yes... it takes the argument of a stored procedure and executes it Function takes argument (or no arguments) and returns or performs something!
  13. robertkjr3d

    Dynamic variable names

    arguing symantics are we? Your definition of function is? A function is a procedure that takes arguments (or lack there of) and returns or does something. You mean because it does not return anything it is not a function? It still takes an argument and performs a task. But neither here nor...
  14. robertkjr3d

    Dynamic variable names

    I did this. It is cumbersome, and requires me entering in all of them into a temp table. The exec(@sql) function should not be out of scope. It should function much like the eval() in javascript. Or create an eval() in sql.
  15. robertkjr3d

    Dynamic variable names

    Ok here is the simple version of what my problem is: declare @Field int declare @Field2 int declare @sql varchar(150) set @Field = 2 set @Field2 = 2000 set @sql = 'select @Field' + Convert(varchar, @Field) + ' [Value]' exec(@sql) I get the error must declare the variable @Field2 It doesn't...
  16. robertkjr3d

    Dynamic variable names

    Ok here is the simple version of what my problem is: declare @Field int declare @Field2 int declare @sql varchar(150) set @Field = 2 set @Field2 = 2000 set @sql = 'select @Field' + Convert(varchar, @Field) + ' [Value]' exec(@sql) I get the error must declare the variable @Field2 It doesn't...
  17. robertkjr3d

    Stored Procedure help.... Loop with changing variables

    well... change of plan again. It doesn't work if values are null. I don't want to enter in a record if the response is null. So I'm back to this.. similiar to the original if @Field1 is not null begin INSERT INTO ReviewData (ChaseID,FieldID,[Value],IsValid,ModifiedBy) VALUES...
  18. robertkjr3d

    Timezone DOB gathering.

    I'm writing a pocket app, and I'm sending to the Pocket PC an XML file, that is data dumped from a SQL Server. The problem is that SQL Server has no just Date field. It is a Date Time Field. So when the DBA puts dates into the server, she uses Enterprise manager or something, and enters in...
  19. robertkjr3d

    Stored Procedure help.... Loop with changing variables

    What makes you say that I will be storing the wrong data type? See above where I do the concatenation... Look for set @Fields = ... If the data needed is not string or date, then I will just concatenate without the semiquote.

Part and Inventory Search

Back
Top