Rev - Odbc - Access

[thierry]

Hi Steve and all,

thanks for this answer !
i couldn't expect a better one :-)

SP> I have had a bit of experience over the last few weeks writing a Rev 
SP> front end to an Access db. The objective originally was a simple 
SP> prototype student records system, but I have been very happy with the 
SP> results, as have my staff. Its very fast and very easy to add 
SP> sophisticated new functionality. Maybe soon the tag of "prototype" will 
SP> become irrelevant. 

Hope sincerely for you.

SP> I hadn't done any database work in Rev before, and I based by original 
SP> approach on that used by the "SoftwareDBDemo" which I think is now on 
SP> revOnline. This approach doesn't rely on record sets and cursors but 
SP> loads the result of a SELECT statement into an array. As I understand 
SP> it, that gets around the bugs with moving forward or backward through a 
SP> record set.


i'm going straight through this SoftwareDBdemo,
i've had some experience with HAshes in Perl feeded by a Select,
so it should be the same king of work....

SP> So while some of the power of revDB may not be usable in an  Access/ODBC 
SP> project, enough of it works, and there are easy workarounds, to make 
SP> using Rev to create sophisticated front ends to Access db's very practical.

SP> And now I'm off to add a few more features to my "prototype"....

good luck for the next step :-)

SP> Steve


SP> thierry wrote:

>>Hi all,
>>
>>i'm in the process of accepting or not a new project.
>>roughly, it's a front end to an access database.
>>
>>i've seen few emails passing, concerning some limitations
>>with Rev-Odbc-Access  ; especialy the one quoted by Mark:
>>
>>
>> " [...]  bug #1528. I've had *several* Access projects
>> now that I would have loved to do in runrev,
>> but that forward-only odbc mode is a killer. "
>>
>>is this *forward-only* means that it's really not at all
>>realistic to do a serious Access Front-end with Rev ? don't
>>really understand what are the constraint behind this word.....
>>
>>thanks for some enlightments or general advise,
>>
>>Best regards, 
>>
>>thierry
>>
>>
>>
>>_______________________________________________
>>use-revolution mailing list
>>use-revolution at lists.runrev.com
>>http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>>
>>
>>  
>>

SP> _______________________________________________
SP> use-revolution mailing list
SP> use-revolution at lists.runrev.com
SP> http://lists.runrev.com/mailman/listinfo/use-revolution


Best regards,