mySQL4VO DataServer
in [Visual Objects]
|
From: Biagio on 7 Mar 2007 13:58 Hi, I'm starting to use the fantastic lib mySQL4VO DataServer but it isn't complete. Where can I find a sample to implement FieldPut() method ? Now I'm using bArrayServer DataWindow ---- > bArrayServer (1 record) ----> mySQL4VO DataServer ----> mySql but isn't elegant solution. Thanks Biagio
From: Klaus on 9 Mar 2007 03:14 Hi Biagio, you can download my pMySql4Vo-lib for MySql 5. It's based on mySql4Vo und FabMySql. Have a look on pMySqlServer, it's inherit bArrayServer and yes it implement the FieldPut() method. The lib is in pre beta and not complete but works for my needs. There is also a small sample how to use pMySql4Vo-lib. Sorry there are no docs and the comments are in german ;-) http://www.ingridschneider.de/VO/pMySql4VO.zip kind regards Klaus On 7 Mrz., 19:58, "Biagio" <softw...(a)notario.it> wrote: > Hi, > > I'm starting to use the fantastic lib mySQL4VO DataServer but it isn't > complete. Where can I find a sample to implement FieldPut() method ? > > Now I'm using bArrayServer > > DataWindow ---- > bArrayServer (1 record) ----> mySQL4VO DataServer > ----> mySql > > but isn't elegant solution. > > Thanks > > Biagio
From: hpeter on 9 Mar 2007 10:54 Biagio: >> lib mySQL4VO DataServer but it isn't complete. Where can I find >> a sample to implement FieldPut() method ? Now I'm using >> bArrayServer- > DataWindow ---- > bArrayServer (1 record) ----> >> ySQL4VO DataServer > > ----> mySql Sorry I never implemented the feature of FieldPut in the library. Although I recompiled the libray with CAVO 2.7a, I never uploaded it again. The solution depicted by yourself and Klaus is acceptable. However, I should point out that carefull attention must be placed when users retrieve huge recordsets, may put a lot of burden on the barrayserver, although many argue that who cares with big memory on computers. It would be nice to implement asynchronus retrieval of records. If the user made a mistake in selecting more than 10,000 records, you can show only few records as they come, or shw them only on demand. I tested also using dbServer, but limitations on "FIELD NAME" to 10 in length prevented me on doing it. Also I tested, bArrayserver and "dettached adorecordsets" What I provded in mySQL4VO is the fastes retrieval of data you can get. Other servers were slower, and my needs were only to retrieve data, not to change it. Of note, mysql4VO was base on the Fabrice idea, but I implemented a conversion between 64bit numbers for accurate record count (I deal with huge databases. Also, I implemented full support for embedded server, to put mysql in an aplication without having the server runing. Regarding the fieldput, you can put an extra "field" or flag in your barray server (record changed, new record) and using that flag to update mysql server immediately after the change takes places or in batches after the user "commits" the transaction. The user then will select the best method to save the data Only records with "changed" or "new" flag will be processed with sql UPDATE or INSERT statement. Klaus: > to use pMySql4Vo-lib. > > http://www.ingridschneider.de/VO/pMySql4VO.zip Te link you provided is not working Hernando
From: Klaus on 9 Mar 2007 11:46 Hi Hernando, sorry i had tested it with IE and Firefox. If you want i can send it per mail. kind regards Klaus On 9 Mrz., 16:54, "hpeter" <hpat...(a)rocketmail.com> wrote: > Klaus: > > > to use pMySql4Vo-lib. > > >http://www.ingridschneider.de/VO/pMySql4VO.zip > > Te link you provided is not working > > Hernando
From: Biagio Notario on 9 Mar 2007 13:46
Thanks, very cool library !!! I will study your solution. Biagio "Klaus" <klaus.przybyla(a)frankfurter-verein.de> ha scritto nel messaggio news:1173428057.430089.243180(a)h3g2000cwc.googlegroups.com... > Hi Biagio, > you can download my pMySql4Vo-lib for MySql 5. It's based on mySql4Vo > und FabMySql. Have a look on pMySqlServer, it's inherit bArrayServer > and yes it implement the FieldPut() method. The lib is in pre beta and > not complete but works for my needs. There is also a small sample how > to use pMySql4Vo-lib. > Sorry there are no docs and the comments are in german ;-) > > http://www.ingridschneider.de/VO/pMySql4VO.zip > > kind regards > Klaus > > > On 7 Mrz., 19:58, "Biagio" <softw...(a)notario.it> wrote: >> Hi, >> >> I'm starting to use the fantastic lib mySQL4VO DataServer but it isn't >> complete. Where can I find a sample to implement FieldPut() method ? >> >> Now I'm using bArrayServer >> >> DataWindow ---- > bArrayServer (1 record) ----> mySQL4VO DataServer >> ----> mySql >> >> but isn't elegant solution. >> >> Thanks >> >> Biagio > > |