You searched for the word(s): userid:830581

More Search Options

RSS Available

• Re: ***HELP*** Return String from SQL Statment & Increment this String

  Can you give me examples? Of how to input into a string variable from a SQL statement and then how to manipulate a string variable via the substring? I can't find any examples out there. I can't find any examples on putting the value from the SQL statement into a string. And I have been trying to slice my value with the sql substr but I get a error Syntax error (missing operator) in query expression 'substr(TOP 1 branchNo,2,3)'. So far nothing is going well for me tonight and I have

  Posted to MySQL (Forum) by taketothesky on 10/8/2008

• ***HELP*** Return String from SQL Statment & Increment this String

  How can I get one value from a select statement and put it into a string and then modify it in that same method? What I want to do is get the last branch number and increment by 1 and return that value. It will be a string value so I will need to get help B002. So I would want it to assign B003 as my return value. Also, I have to use the OleDbConnection. public string GetNewBranchID() { String sql = "SELECT last.branchNo FROM Branch ORDER BY branchNo"; OleDbConnection connection = new OleDbConnection

  Posted to MySQL (Forum) by taketothesky on 10/8/2008
  Filed under: Return String from SQL