[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 Someone can help me From already thank you very much Luis R. Stach ___ 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
Re: [Harbour] Error in SDDFB
Hi, 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 I was offline for some time, but I'm going to check this issue together with other RDDSQL fixes in the nearest future (perhaps end of this week). 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
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
Hello Mindaugas What dou you think of integrate a ORM mapper to allow programm written using sqlmix to be indipendent from sql string 2010/3/15 Mindaugas Kavaliauskas : > Hi, > > > 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 > > I was offline for some time, but I'm going to check this issue together with > other RDDSQL fixes in the nearest future (perhaps end of this week). > > > 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
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 : > 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
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" Sent: Sunday, March 21, 2010 10:02 PM To: "Harbour Project Main Developer List." 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
>> 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 Wow :) Actually I wanted to find the intended meaning of "ORM" in recent discussions based on context (but had a hard time), and above perfectly shows the whole confusion above these three-letter buzzwords. > 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. Maybe I'm wrong, but above description seems to cover the database access concept implemented in all dBase-like languages. Except that the "array" is present on RDD level, so you don't really make separate disk accesses by each FIELD->x reference (but I'm not 100% sure on that in current Harbour implementation). 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. 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
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[2]: [Harbour] Error in SDDFB
English by Google Marek Thanks for answering, The same problem continues, it follows the same mistake Regards, Luis R. Stach 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. > Regards, > Marek Horodyski > ___ > 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[2]: [Harbour] Error in SDDFB
Thanks Mindaugas Saludos, Luis R. Stach Monday, March 15, 2010, 12:42:06 PM, you wrote: > Hi, > I was offline for some time, but I'm going to check this issue together > with other RDDSQL fixes in the nearest future (perhaps end of this week). > Regards, > Mindaugas > ___ > 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