Re: [Harbour] Error in SDDFB
Viktor Szakáts wrote: So, if that's all ORM means, we already have it, and that was one of the features that made dBase so popular versus other database languages. My understanding is that there is a disconnect between the programmers object based view of the data and the DBMS's relational view of the data. ORM's seek to mend this disconnect. Of course they do other things such as make CRUD easy and provide factory methods to create data classes. I would not say dBase addressed this issue in any significant way, but I am not convinced that it needs to either. Regards Alex ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Error in SDDFB
So for me it's hard to understand why to reinvent it, if we already have it by the name RDD. If we want to go beyond this and implement the whole ORM buzzword, it's a whole separate project, not just some extra lines of code in sqlmix. ORM is defined as Object Relational Mapping at wikipedia, but there is another meaning for that, that is Object Role Modeling acording to www.orm.net. Maybe the example pointed by Massimo is more related to Object Persistence. Wikipedia moved/renamed Object Persistence page to System Prevalence (http://en.wikipedia.org/wiki/System_Prevalence) and acording to it, the advantage of this aproach is Simply keeping system state in memory in its normal, natural, language-specific format is both orders of magnitude faster and more programmer-friendly than the multiple conversions that are needed when it is stored and retrieved from a DBMS. One case of use is that objects can be collected in an array, so once they are loaded it is much faster to access ascan form them than using searching in a disk file. Brgds Leandro -- From: Viktor Szakáts harbour...@syenar.hu Sent: Sunday, March 21, 2010 10:02 PM To: Harbour Project Main Developer List. harbour@harbour-project.org Subject: Re: [Harbour] Error in SDDFB New generation languages (Python, Ruby etc. and even Java) have shifted focus to using ORMs rather than SQL directly. Now instead of explicit SQL statements, ActiveRecord (Ruby's Object Relational Mapper) uses something like emp=Employee.new emp.name = Emp1 emp.basic = 4500 emp.designation = Programmer emp.save I guess you're talking about this: http://en.wikipedia.org/wiki/Object-relational_mapping Well, above example just doesn't even scratch the surface. And it's in fact an example which makes thing just much less efficient than it normally is in Harbour. IOW it's adding extra complexity without any benefit. This is how it's done in Harbour: Employee-(dbAppend()) Employee-name := Emp1 Employee-basic := 4500 Employee-designation := programmer Employee-(dbCommit()) The advantage of ORM is that programmers can write database code that are not specific to the back-end engine. This is also strikingly similar to the Clipper concept of RDDs So for me it's hard to understand why to reinvent it, if we already have it by the name RDD. If we want to go beyond this and implement the whole ORM buzzword, it's a whole separate project, not just some extra lines of code in sqlmix. Brgds, Viktor ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Error in SDDFB
Hello Mindaugas, Monday, March 15, 2010, 4:42:06 PM, you wrote: MK Hi, MK Luis R. Stach wrote: Error SDDFB/1903 Prepare statement failed: SELECT * FROM agenda (DOS Error 335544569) What I do is this: ANNOUNCE RDDSYS REQUEST SQLMIX, SDDFB RDDSETDEFAULT( SQLMIX ) hConn := RDDINFO( RDDI_CONNECT, { FIREBIRD,, SYSDBA, masterkey, 192.168.0.1:d:\data\agenda.fdb } ) MsgInfo( hConn ) //Return 1 DBUSEAREA( .T.,, SELECT * FROM agenda ) //Line error I use Firebird 2.1.3.18185 Someone can help me MK I was offline for some time, but I'm going to check this issue together MK with other RDDSQL fixes in the nearest future (perhaps end of this week). MK Regards, MK Mindaugas Any chance for it on this weekend ?? -- Best regards, Jacek Kubica ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Error in SDDFB
Jacek Kubica wrote: Any chance for it on this weekend ?? Almost finished. Compiles without error, but have not tested any SQL backed yet. Regards, Mindaugas ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Error in SDDFB
Massimo Belgrano wrote: Hello Mindaugas What dou you think of integrate a ORM mapper to allow programm written using sqlmix to be indipendent from sql string Hi, I suggest you to write down your idea in C or PRG code and share it on mailing list. Regards, Mindaugas ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Error in SDDFB
New generation languages (Python, Ruby etc. and even Java) have shifted focus to using ORMs rather than SQL directly. Now instead of explicit SQL statements, ActiveRecord (Ruby's Object Relational Mapper) uses something like emp=Employee.new emp.name = Emp1 emp.basic = 4500 emp.designation = Programmer emp.save This syntax closely resembles the tight integration between the language and database for the xBase languages. A comparable Clipper syntax was Employee-name = Emp1 The advantage of ORM is that programmers can write database code that are not specific to the back-end engine. This is also strikingly similar to the Clipper concept of RDDs http://article.gmane.org/gmane.comp.lang.harbour.user/437 http://news.gmane.org/gmane.comp.lang.harbour.user http://article.gmane.org/gmane.comp.lang.harbour.user/453 2010/3/22 Mindaugas Kavaliauskas dbto...@dbtopas.lt: Massimo Belgrano wrote: Hello Mindaugas What dou you think of integrate a ORM mapper to allow programm written using sqlmix to be indipendent from sql string Hi, I suggest you to write down your idea in C or PRG code and share it on mailing list. Regards, Mindaugas ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour -- Massimo Belgrano ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Error in SDDFB
New generation languages (Python, Ruby etc. and even Java) have shifted focus to using ORMs rather than SQL directly. Now instead of explicit SQL statements, ActiveRecord (Ruby's Object Relational Mapper) uses something like emp=Employee.new emp.name = Emp1 emp.basic = 4500 emp.designation = Programmer emp.save I guess you're talking about this: http://en.wikipedia.org/wiki/Object-relational_mapping Well, above example just doesn't even scratch the surface. And it's in fact an example which makes thing just much less efficient than it normally is in Harbour. IOW it's adding extra complexity without any benefit. This is how it's done in Harbour: Employee-(dbAppend()) Employee-name := Emp1 Employee-basic := 4500 Employee-designation := programmer Employee-(dbCommit()) The advantage of ORM is that programmers can write database code that are not specific to the back-end engine. This is also strikingly similar to the Clipper concept of RDDs So for me it's hard to understand why to reinvent it, if we already have it by the name RDD. If we want to go beyond this and implement the whole ORM buzzword, it's a whole separate project, not just some extra lines of code in sqlmix. Brgds, Viktor ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
RE: [Harbour] Error in SDDFB
-Original Message- From: Luis R. Stach [mailto:luisrst...@yahoo.com.ar] Sent: Wednesday, March 10, 2010 11:04 PM To: harbour@harbour-project.org Subject: [Harbour] Error in SDDFB English by Google Hi I'm trying to connect to Firebird but I can not, I get this error: Error SDDFB/1903 Prepare statement failed: SELECT * FROM agenda (DOS Error 335544569) What I do is this: ANNOUNCE RDDSYS REQUEST SQLMIX, SDDFB RDDSETDEFAULT( SQLMIX ) hConn := RDDINFO( RDDI_CONNECT, { FIREBIRD,, SYSDBA, masterkey, 192.168.0.1:d:\data\agenda.fdb } ) MsgInfo( hConn ) //Return 1 DBUSEAREA( .T.,, SELECT * FROM agenda ) //Line error I use Firebird 2.1.3.18185 *--- I use this so : dbUseArea( .T., SQLMIX, select pok, oddz from jednostki order by pok, JEDNOSTKI) with Oracle. Try so like I. Regards, Marek Horodyski ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour
Re: [Harbour] Error in SDDFB
Hello Luis, I can only confirm your bug raport (the same error here). IMHO sddfb is still buggy oposite to sddoci which work just fine. sddfb can only make connection (I can see it on Flamerobin fb tool) and nothing more ;-( ... but maybe is someone on our list, who can say - it work ?? Mindaugas, can you look at this problem and help us to find solution ?? Regards Jacek Kubica LRS Thursday, March 11, 2010, 8:36:01 PM, you wrote: LRS English by Google LRS Marek Thanks for answering, LRS The same problem continues, it follows the same mistake LRS Regards, LRS Luis R. Stach LRS Thursday, March 11, 2010, 6:11:16 AM, you wrote: -Original Message- From: Luis R. Stach [mailto:luisrst...@yahoo.com.ar] Sent: Wednesday, March 10, 2010 11:04 PM To: harbour@harbour-project.org Subject: [Harbour] Error in SDDFB English by Google Hi I'm trying to connect to Firebird but I can not, I get this error: Error SDDFB/1903 Prepare statement failed: SELECT * FROM agenda (DOS Error 335544569) What I do is this: ANNOUNCE RDDSYS REQUEST SQLMIX, SDDFB RDDSETDEFAULT( SQLMIX ) hConn := RDDINFO( RDDI_CONNECT, { FIREBIRD,, SYSDBA, masterkey, 192.168.0.1:d:\data\agenda.fdb } ) MsgInfo( hConn ) //Return 1 DBUSEAREA( .T.,, SELECT * FROM agenda ) //Line error I use Firebird 2.1.3.18185 *--- I use this so : dbUseArea( .T., SQLMIX, select pok, oddz from jednostki order by pok, JEDNOSTKI) with Oracle. Try so like I. -- Best regards, Jacekmailto:clip...@wssk.wroc.pl ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour