New topic: ASP.Net/Oracle to Real Studio Web
<http://forums.realsoftware.com/viewtopic.php?t=47438> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message tcorcoran Post subject: ASP.Net/Oracle to Real Studio WebPosted: Thu Mar 28, 2013 10:46 pm Joined: Thu Mar 28, 2013 9:53 pm Posts: 1 I've looked and found nothing. I'm investigating the plausibility of migrating from the visual studio/asp.net/Oracle devlopment environment to Real Studio/Oracle. We use a dedicated Oracle data server. Wanna point me to some useful info/examples? I'm trying to do a simple proof of concept and then move on from there, but something isn't cooperating. I'm thinking that though Real Studio is reporting a valid connection, it really isn't. I have a simple form with a label (lblConnection), a button (btnSearch), and listbox (lbData). The user, password, and data base all work and are part of my normal development environment (I've changed the data below for obvious reasons). Click the button and the listbox fills with the table data. Well, it's supposed to... Dim db as OracleDatabase Dim sqlstring as OracleSQLPreapredStatement 'open a database connection db = New OracleDatabase db.DatabaseName = "database" db.UserName = "user" db.Password = "password" db.Debug = 1 if Not db.Connect() Then MsgBox(db.ErrorMessage) Return Else lblConnection.Text = "Connected!" sqlString = OracleSQLPreapredStatement(db.Prepare("SELECT * FROM table WHERE id = '12345678'")) 'Perform the search Dim rs as RecordSet rs = db.SQLSelect("SELECT * FROM table WHERE id = '12345678'") if db.Error Then MsgBox db.ErrorMessage End if rs = NIL Then Return lbData.DeleteAllRows lbData.ColumnCount = rs.FieldCount lbData.HasHeading = True Dim hasHeadings As Boolean While Not rs.EOF lbData.AddRow "" For i As Integer = 0 To rs.FieldCount-1 If Not hasHeadings Then lbData.Heading(i) = rs.IdxField(i+1).Name lbData.Cell(lbData.LastIndex, i) = rs.IdxField(i+1).StringValue Next rs.MoveNext hasHeadings = True Wend End If Running the web app shows the form fine and changes the label (lblConnection.Text) to a "Connected!" but when I walk through the code, it hangs at the rs= db.SQLSelect("SELECT * FROM tabel WHERE id = 12345678"). You'll note that I call the db.SQLSELECT with a string though I have an OracleSQLPreparedStatement defined earlier in the code. That's because I've found several mutations of interacting with a db and have been experimenting. As usuual, Oracle seems to require something special. Just what that is, I'd love to know! I've tried the example Oracle app included with the installation with similar results. The documentaiton wiki does not go into enough detail on Oracle (well for me anyway) and the more I followed the links the more I ended up in the weeds. Oh, and this is the first time I think I've ever completely stumped Google! I appreciate anyone's help here... -Tim Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
