ODBC connection to MS SQL 2000 help needed

2006-04-04 Thread Mark Stuart
Hi Mark, I voted on this bug using RevZilla. BTW: how many times can one vote on a bug? The option in RevZilla allows me to vote as many times as I want - with the count option. :-) Well, after reading the bug Description, I'm getting a little disappointed with Rev Studio for

Re: ODBC connection to MS SQL 2000 help needed

2006-04-02 Thread Mark Wieder
Jan- Sunday, April 2, 2006, 12:29:58 AM, you wrote: The way I solve it right now, is to query the database with: SELECT * FROM TheTableName and append TOP or LIMIT clauses for databases that support this. Then I can use revdb_columnnames to fetch the information and then call

Re: ODBC connection to MS SQL 2000 help needed

2006-04-02 Thread Mark Wieder
Jan- Sunday, April 2, 2006, 12:29:58 AM, you wrote: It is now available as bugzilla #3479 for your voting pleasures. Just sent five votes in that direction... -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list

Re: ODBC connection to MS SQL 2000 help needed

2006-04-01 Thread Trevor DeVore
On Mar 31, 2006, at 11:04 PM, Jan Schenkel wrote: 6) Improve transaction support: right now you can commit and rollback transactions, but you can't tell the DBMS when the transaction starts? If possible, allow nested transactions. (You could call this 'revdb_starttransaction', and make it a

Re: ODBC connection to MS SQL 2000 help needed

2006-04-01 Thread Ruslan Zasukhin
On 4/1/06 7:16 PM, Trevor DeVore [EMAIL PROTECTED] wrote: 7) A little more exotic now: could you make the revdb library run in its own thread, and allow callbacks, similar to the socket communication model? (That way we could just fire off a lengthy query and the app UI remains responsive;

Re: ODBC connection to MS SQL 2000 help needed

2006-04-01 Thread Troy Rollins
On Apr 1, 2006, at 11:25 AM, Ruslan Zasukhin wrote: Actually Revolution should have Active Listbox if it still do not have it. Any threading will not help you if you want to browser 10 millions table. Active Listbox is an answer. Agreed. Then again, *any* multi-column listbox which is

Re: ODBC connection to MS SQL 2000 help needed

2006-04-01 Thread Trevor DeVore
On Apr 1, 2006, at 8:25 AM, Ruslan Zasukhin wrote: Actually Revolution should have Active Listbox if it still do not have it. Any threading will not help you if you want to browser 10 millions table. Active Listbox is an answer. Well, I want one of those then too :-) -- Trevor DeVore

Re: ODBC connection to MS SQL 2000 help needed

2006-04-01 Thread Mark Wieder
Jan- Friday, March 31, 2006, 11:04:56 PM, you wrote: 4) On a similar note, add a 'revdb_fieldnames()' function that returns a list of the fields in a table for a given database connection ...as in revDatabaseColumnNames? But basically amen to everything Jan said. Jan - can you write up a

Re: ODBC connection to MS SQL 2000 help needed

2006-04-01 Thread Jan Schenkel
--- Mark Wieder [EMAIL PROTECTED] wrote: Jan- Friday, March 31, 2006, 11:04:56 PM, you wrote: 4) On a similar note, add a 'revdb_fieldnames()' function that returns a list of the fields in a table for a given database connection ...as in revDatabaseColumnNames? No,

Re: ODBC connection to MS SQL 2000 help needed

2006-04-01 Thread Jan Schenkel
--- Ruslan Zasukhin [EMAIL PROTECTED] wrote: Jan, Trevor, Actually Revolution should have Active Listbox if it still do not have it. Any threading will not help you if you want to browser 10 millions table. Active Listbox is an answer. -- Best regards, Ruslan Zasukhin Hi

RE: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Lynn Fredricks
All that is true. I built a test harness for the database functions and MySQL comes through fine. If you don't absolutely *need* odbc functionality you might consider going with MySQL or SQLite. Or Valentina (I had to beat Ruslan to the draw here...). If you have real clients with

Re: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Stephen Barncard
ODBC has always SUCKED, and still sucks the big one. It's like getting your data through a straw with a bunch of tape to plug the leaks. Don't blame RunRev for that. I'm writing a complex MySQL based project with Rev and Trevor's externals. In a word - it rocks! sqb -- stephen barncard s a n

RE: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Stephen Barncard
Incorporate Trevor's DB Library into RevDB. I found working with RevDB incomprehensible. Nice to have the primitives there, but I as a designer am more interested in writing code for getting data in and out of a database, not having to keep track of the cursor. If you were to

ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread mfstuart
Ahhh, you pose THE question for me to feast on :) Lynn Fredricks wrote: If you were to prioritize improvements to database access in Revolution, what would you want? You mention improvements. I would first request that you apply fixes to all outstanding bugs related to the database libraries.

Re: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Mark Wieder
Lynn- Friday, March 31, 2006, 8:40:19 AM, you wrote: If you were to prioritize improvements to database access in Revolution, what would you want? g Well, it's hard to find fault with stephen's response, but also... to put it in a nutshell, I think the functionality should match the marketing

Re: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Ruslan Zasukhin
On 3/31/06 10:26 PM, Mark Wieder [EMAIL PROTECTED] wrote: If you were to prioritize improvements to database access in Revolution, what would you want? g Well, it's hard to find fault with stephen's response, but also... to put it in a nutshell, I think the functionality should match the

Re: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Pierre Sahores
I would'nt say anything else Kevin and All. Thanks Stephen to let us know about your experience of Trevor's DB lib ;-) Best Regards, Incorporate Trevor's DB Library into RevDB. I found working with RevDB incomprehensible. Nice to have the primitives there, but I as a designer am more

RE: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Jan Schenkel
--- Lynn Fredricks [EMAIL PROTECTED] wrote: If you were to prioritize improvements to database access in Revolution, what would you want? Best regards, Lynn Fredricks Worldwide Business Operations Runtime Revolution, Ltd Ooh, where shall I start? *grins as he cracks his knuckles*

Re: ODBC connection to MS SQL 2000 help needed

2006-03-31 Thread Mark Wieder
Ruslan- Friday, March 31, 2006, 12:48:58 PM, you wrote: Mark, I am not big expert of ODBC, but I remember that ODBC have few levels of implementations. Some levels of ODBC do support only forward cursors. This is issue of particular ODBC driver. No, it isn't. The odbc dll that ships with

ODBC connection to MS SQL 2000 help needed

2006-03-30 Thread mfstuart
Hi all, I’m enjoying this forum immensely – lots of pros with great advice and friendly chatter. Hence I’m looking for help with the subject matter. I’m using Sarah’s MySQLtest.rev to learn the required database connections, but I’m wanting to connect to MS SQL 2000 with an ODBC DSN name. I’ve

Re: ODBC connection to MS SQL 2000 help needed

2006-03-30 Thread Jan Schenkel
--- [EMAIL PROTECTED] wrote: Hi all, [snip] Problem is, the select returns no data (when I know there is data) and the Counter = -1 for Matching records. I’ve tried with and without the semicolon “;” in the “on mouseUp” for the “Select” button. Here’s the select statement: SELECT

Re: ODBC connection to MS SQL 2000 help needed

2006-03-30 Thread Mark Wieder
Thursday, March 30, 2006, 9:34:50 AM, Jan wrote: There's nothiong worng with your SELECT query ; the g problem is in the ODBC database driver not always returning the correct record count. I've seen this with Access and Progress databases as well. See BZ #3291 for details about

ODBC connection to MS SQL 2000 help needed

2006-03-30 Thread mfstuart
Hi Mark, I voted on this bug using RevZilla. BTW: how many times can one vote on a bug? The option in RevZilla allows me to vote as many times as I want – with the count option. #61514; Well, after reading the bug Description, I’m getting a little disappointed with Rev Studio for database

Re: ODBC connection to MS SQL 2000 help needed

2006-03-30 Thread Mark Wieder
mfstuart- Thursday, March 30, 2006, 4:19:59 PM, you wrote: I voted on this bug using RevZilla. BTW: how many times can one vote on a bug? You're allowed five votes per bug. Well, after reading the bug Description, I’m getting a little disappointed with Rev Studio for database access. I’m