Windows ODBC
I am using Runtime Revolution on Windows XP Professional and am unable to successfully connect to either Firebird or MS Access via ODBC. Using the Microsoft Access 2003 ODBC driver I can get as far as connecting within the Database Query Builder, but when I go to the Record Set table there aren't any tables in the Table drop-down. Note that I CAN successfully use this ODBC Driver within other programs, such as R:Base. Using the Firebird ODBC driver my results are identical. I can establish a connection with the Database Query Builder but cannot get any tables to appear within the Record Set Table drop-down. Once again, I can successfully use this ODBC Driver within other programs, such as MS Access 2003. Using the Gemini ODBC driver for Interbase/Firebird my results are a bit different. With this driver I can establish a connection and I do see tables listed in the Record Set Table drop-down. However, my results at this point vary. For tables that contain a certain configuration of columns (I haven't locked down the pattern yet) RunRev will GPF and terminate as soon as I select a table from the list. For other tables I can successfully select a table - resulting in the creation of a select statement in the SQL Query edit field. However, for these tables as soon as I attempt to bind the table to a field in card RunRev will again GPF and terminate. Can someone please shed some light on this for me? Am I doing something incorrectly or is this a bug? Thanks Bob ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Windows ODBC Recordset Navigation Problems
Can anyone help me with this? I didn't get any responses from the first post. Thanks. On Tue, 13 Jan 2004 20:19:52 -0600, KumaSoftDev wrote: I am using Run Rev on Windows XP Pro. I have created a query against an ODBC database. I have added Edit Fields to a Card and bound them to a query using the Database properties of each field. I have then put 4 buttons on the Card and used the Database properties of each to map to the operations First Record, Last Record, Next Record, and Previous Record. Unfortunately, only the Next Record functionality seems to be working. The other buttons neither change the record not throw an error. I am having the same results with both MS Access and Firebird ODBC drivers. These drivers DO work as expected within other programs (Access and R:Base). Can someone shed some light on this for me? Thanks. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Windows ODBC Recordset Navigation Problems
I am using Run Rev on Windows XP Pro. I have created a query against an ODBC database. I have added Edit Fields to a Card and bound them to a query using the Database properties of each field. I have then put 4 buttons on the Card and used the Database properties of each to map to the operations First Record, Last Record, Next Record, and Previous Record. Unfortunately, only the Next Record functionality seems to be working. The other buttons neither change the record not throw an error. I am having the same results with both MS Access and Firebird ODBC drivers. These drivers DO work as expected within other programs (Access and R:Base). Can someone shed some light on this for me? Thanks. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
RE: Windows ODBC
It's definitely a bug with the Query Builder. You'll find the same thing happening with SQL Server. Skip the Database Query Builder and use the revdb commands. They work just fine even if the Query Builder can't come up with a list of tables. Also, you'll find that if you enter valid SQL into the query builder it *will* work, it just won't give you any help getting there. Mark, has this been BugZilla'ed? Just wanting to make sure RunRev knows about this one... Thanks, Ken Ray Sons of Thunder Software Email: [EMAIL PROTECTED] Web Site: http://www.sonsothunder.com/ ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Windows ODBC
I am using Runtime Revolution on Windows XP Professional and am unable to successfully connect to either Firebird or MS Access via ODBC. Using the Microsoft Access 2003 ODBC driver I can get as far as connecting within the Database Query Builder, but when I go to the Record Set table there aren't any tables in the Table drop-down. Note that I CAN successfully use this ODBC Driver within other programs, such as R:Base. Using the Firebird ODBC driver my results are identical. I can establish a connection with the Database Query Builder but cannot get any tables to appear within the Record Set Table drop-down. Once again, I can successfully use this ODBC Driver within other programs, such as MS Access 2003. Using the Gemini ODBC driver for Interbase/Firebird my results are a bit different. With this driver I can establish a connection and I do see tables listed in the Record Set Table drop-down. However, my results at this point vary. For tables that contain a certain configuration of columns (I haven't locked down the pattern yet) RunRev will GPF and terminate as soon as I select a table from the list. For other tables I can successfully select a table - resulting in the creation of a select statement in the SQL Query edit field. However, for these tables as soon as I attempt to bind the table to a field in card RunRev will again GPF and terminate. Can someone please shed some light on this for me? Am I doing something incorrectly or is this a bug? Thanks Bob ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Windows ODBC
Bob- Sunday, January 11, 2004, 9:41:15 AM, you wrote: K Using the Microsoft Access 2003 ODBC driver I can get as far as K connecting within the Database Query Builder, but when I go to K the Record Set table there aren't any tables in the Table K drop-down. Note that I CAN successfully use this ODBC Driver K within other programs, such as R:Base. It's definitely a bug with the Query Builder. You'll find the same thing happening with SQL Server. Skip the Database Query Builder and use the revdb commands. They work just fine even if the Query Builder can't come up with a list of tables. Also, you'll find that if you enter valid SQL into the query builder it *will* work, it just won't give you any help getting there. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution