--- Jay Busari <[EMAIL PROTECTED]> wrote: > Hi Jan, > > I noticed that you replied to a problem from John > Miller in the RunRev > lists...and he seems to have solved his problem with > your advice. > > I'm new to RunRev. I have a Sybase database running > with the ability > to connect via JDBC drivers. > > I also have ODBC drivers (from OpenLink), but > haven't tried using them > with Sybase. I am doing the RunRev development on > MacOSX. > > When I create a new main stack, I don't get the > ability to configure > the Database Query Builder (it's all greyed out). I > believe getting > this "working" would be a first step to actually > doing the > revQueryDatabase function call. > > How do I get RunRev to "use" the ODBC drivers from > OpenLink and connect > to my (Sybase) database ? > > > Thank you for your help, > Jay >
Hi Jay, Let me start by apologising for the delay in reply -- I've been mighty busy lately, and have only just begun to keep up again with the abundance of emails on the use-revolution list. Speaking of the list, you may want to post your questions there in the future : there are planty of smart database-wielding Rev developers on the list, more than willing to answer your questions. That being said, let me see how I can help you. The first important thing to note is that the Database Query Builder stores the queries inside the stack where you use them. So you will need to open a new stack forst, or open your current project stack, and then open the Database Query Builder. Now that you have your stack and the query builder open, you need to create a new query by clicking the '+' button in the topright of the screen. Rename the query name to something more useful, then change its type to ODBC and enter the name of the DSN (Data Source Name) -- in case you haven't created that yet, now is a good time to go to the iODBC preference panel and create it. After that, return to Revolution and complete the connection settings by entering the user and password. Then click the 'Connect' button. If all works as planned, you will receive no error message, and the Connection status in the bottomright will read 'connected'. If so, go ahead to the 'Record Set' tab, and enter your SELECT statement -- if there's not much data, I suggest you also tick the 'Cache record set' checkbox. When you have the right SQL query, you can start linking fields and buttons to this query : drag some fields to your stack, open the Inspector palette and go to the 'Database' pane. There you select the name of the query that you just created, and pick one of the columns to display. In a similar fashion, drop a few buttons onto your stack, and use the Inspector palette to edit their database settings. Here you pick the same query, and assign an action : Move to the first record, move to the previous record, move to the next record, move to the last record,... I hope this quick intro help you on your way, Jan Schenkel. ===== Quartam - Tools for Revolution <http://www.quartam.com> ===== "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
