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 Mike Lewis 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. Wilnicm

    Problem inserting record into Database

    My current code i have inserts the row into the table but the row does not get inserted until Under the Query Designer Menu i click the "Execute SQL" button Am i doing something wrong or i'm not understing.. I thought my code was to automatically insert the row in the table i didn't think i...
  2. Wilnicm

    Can someone help me figure out why this code is not working..

    I have this code when i run it after i add the values in the textbox its suppose to insert the values from the textbox into the database but its not doing it.. i don't know why its not here. I don't get no error message or anything.. System.Data.SqlClient.SqlConnection...
  3. Wilnicm

    Problem inserting record into Database

    Well no exception is being thrown and the database.. is not being updated.. Its probably something simple i'm not noticing.. or something.. <Will The Great>
  4. Wilnicm

    Problem inserting record into Database

    Nothing.. got updated in the database.. I changed the code as you stated.. i'm wondering if its because i'm not using an adapter or i read somewhere my permissions my be preventing me from inserting it.. i've been at this problem for about a Week to no Avail.. <Will The Great>
  5. Wilnicm

    Problem inserting record into Database

    Its still not working i'm not able to insert anything in the database.. here is my current code.. Thanks.. for the help in advanced.. string first = TxtbxFname.Text; string last = TxtbxLname.Text; string User = TxtbxUname.Text; string Email =...
  6. Wilnicm

    Problem inserting record into Database

    Alex.. I'm getting a SQL Exception stating "An explicit value for the identity column in table 'UserProfile' can only be specified when a column list is used and IDENTITY_INSERT is ON" here is my current code with the suggested changes.. SqlConnection CnNew = new...
  7. Wilnicm

    Problem inserting record into Database

    Hi, I'm having problems with code to save inputs from a forms textbox to a data base. I have a Window forms with 6 textbox fields and a button click event that will save the input from these 6 textbox fields to my table called User profile that has 7 columns name Fname, Lname, UserName...
  8. Wilnicm

    How can i make this formula correct..

    How can i make this formula correct i keep recieving the error "string is required here" If {Command_1.AL_DESCRIPTION} = {Command_1.AL_DESCRIPTION} then {Command_1.AL_DESCRIPTION} else if {Command_1.AL_DESCRIPTION} = "Financials (FI)" then {Command.AL_DESCRIPTION} = ["FI","Letters DAY...
  9. Wilnicm

    Need help with Grouping formula..

    How can i make this formula correct i keep recieving the error "string is required here" If {Command_1.AL_DESCRIPTION} = {Command_1.AL_DESCRIPTION} then {Command_1.AL_DESCRIPTION} else if {Command_1.AL_DESCRIPTION} = "Financials (FI)_Stacy" then {Command_1.AL_DESCRIPTION} = ["FI","Letters DAY...
  10. Wilnicm

    Need help with Grouping formula..

    How can i make this formula correct i keep recieving the error "string is required here" If {Command_1.AL_DESCRIPTION} = {Command_1.AL_DESCRIPTION} then {Command_1.AL_DESCRIPTION} else if {Command_1.AL_DESCRIPTION}= "Financials (FI)_Stacy" then {Command_1.AL_DESCRIPTION} in ["FI","Letters DAY...
  11. Wilnicm

    Need help with Grouping formula..

    Madawc Thanks.. so much for you help.. This code i think will work but, how do i specify my group name in the formula. On the design section of the report the group is name is "Group #1 Name" and "Group #2 Name" respectively. I used this text for group one name "Group #1...
  12. Wilnicm

    Problem with a creating a formula with multiple return string

    LBass the name of the current thread i'm talking about is called "Need help with Grouping formula".. Any help you might be able to offer would be great.. ..Thanks.. <Will The Great>
  13. Wilnicm

    Problem with a creating a formula with multiple return string

    Lbass, Can you see my current thread.. It goes to alittle more detail.. to show you what i'm talking about.. I hope its enough information for you to be able to understand.. Thanks.. <Will The Great>
  14. Wilnicm

    Need help with Grouping formula..

    Currently i have two tables {Comand_1} and {Command} There are link with the AL_FATHER_ID field. {Command_1} has these field {Command} AL_DESCRIPTION AL_ITEM_ID AL_FATHER_ID TS_SUBJECT AL_ITEM_ID AL_DESCRIPTION...
  15. Wilnicm

    If statment to replace 1 field string with with 3 different strings

    Jason, thanks.. one last question.. current..my report looks like this..in the group format Financials (FI)<-- this field is in the <--{Command_1.AL_Description} -"FK", "Letters DAY 1", "letter DAY 2" <--these 3 fields are in this table.field {Command.AL_Description} but there are...
  16. Wilnicm

    If statment to replace 1 field string with with 3 different strings

    Yes.. These strings will always be constant... <Will The Great>
  17. Wilnicm

    If statment to replace 1 field string with with 3 different strings

    Jason, I i want the ---> {Command_1.AL_DESCRIPTION} = "Financials (FI) " to equal to three separate different separate strings that are actualy strings that are located in the {Command.AL_DESCRIPTION} table and field. All of these strings are coming from the same field which is the...
  18. Wilnicm

    If statment to replace 1 field string with with 3 different strings

    How do i do this if statements if i want replace a field's string with a different field string Example If {Command_1.AL_DESCRIPTION} = "Financials (FI) " Then "FI", "Letters DAY 1", "Letters DAY 2" This would replace Financials (FI) field with three separate strings which are"FI", "Letters...
  19. Wilnicm

    Problem with a creating a formula with multiple return string

    Well the table i'm working does not have the set up to create the report without modifiying it.. The way the table and the database set up.. i had to create a tables from the command line in crystal the first table has an alias to itself to extract Parent folder names. which is...
  20. Wilnicm

    Problem with a creating a formula with multiple return string

    Hi everyone I have a problem with a formula i've been trying to create for the past 6 days. I have been searching the web and have not come up with nothing. I'm trying to create a grouping formula. My first group is good, but when i go to try to create group 2 off of group 1 that is where the...

Part and Inventory Search

Back
Top