MySQL in bBrowser
in [Visual Objects]
|
From: TW on 23 Apr 2010 15:24 Hello, Thanks everyone. Since MySQL cannot be changed, I am going to use bBrowser 3 and VO2ADO. I found an ADO OLEDB Provider for MySQL from a web search. I will download and try it out. VO2.8 upgrade may consider later if possible. I'm highly appreciated for all your recommendations. Thanks again. Tyrone
From: Jorge on 21 Apr 2010 04:58 On 21 abr, 00:06, "Geoff Schaller" <geo...(a)softxwareobjectives.com.au> wrote: > TW. > > The problem is your select - it is select * and if there are any serious > numbers of rows here you are doomed. bBrowser will call a go top about 6 > times in its creation cycle, causing a recordset refresh each time. > > The answer is to do a select top 0 * from xxxx, set up your browser then > reselect without the top 0. > > Then you will be fine. > > It has nothing to do with bBrowser versions. > > Geoff > > "TW" <TYRON...(a)LIVE.COM> wrote in message > > news:eaec2513-5ef5-4c9c-b3aa-1ddd5a557587(a)x23g2000prd.googlegroups.com: > > > > > Hi, > > > I have a problem in using MySQL in bBrowse 1.4 (Limited) with VO2.7B > > (Build 2740). I use ODBC driver 3.51. > > > The browser takes a long time to load and also cannot focus in the > > browser to move up and down by pressing the up down arrow keys in the > > keyboard. > > > The coding is as follows : > > > oConn := SQLConnection{"MySQL-Server","root","1234"} > > oSelect := SQLSelect{ "SELECT * FROM SQL_TABLE", oConn } > > > SELF:oDCbBrowser:Use( oSelect, , { } ) > > oColumn := bDataColumn{SELF:oDCbBrowser, SELF:oDCbBrowser:Server, ; > > {|oServer| oServer:Field1 }, #Expression, SELF} > > oColumn:Caption := "FIELD-1" > > oColumn:Width := 165 > > SELF:oDCbBrowser:AddColumn(oColumn) > > SELF:oDCbBrowser:OpenColumn(oColumn,1) > > > --- > > > Recently, I move my VO from the old machine with Windows 2000 to a new > > machine with Windows XP Pro. When I run an application with bBrowser > > under VO in the new machine with Windows XP Pro, I get an error > > message "The ordinal 125 could not be located in the dynamic link > > library VO27OLE.DLL". In the old machine with Windows 2000 or if I > > compiled and link it, I do not have such problem. > > > Does anyone know what's wrong ? > > > Thanks. > > > TW- Ocultar texto de la cita - > > - Mostrar texto de la cita - Hello I want to clarify that I have recommended bBrowser 3.0 from a general point of view (not to solve any type problem in particular) I simply observed that TW works with Vo in combination - MYSQL and I thought, from personal experience, very appropriate Best regards Jorge Accinelli
From: TW on 21 Apr 2010 14:37 Hi, I would like to thanks for Geoff. I can make it work now but the speed of loading is so much slower than DBF. DBF can show it almost right away. Anyway I can set the Query statement to include less columns and rows. For this table I have 68 fields and 3785 records. It does not seem to be a problem in DBF. Also thanks for Jorge. I will consider of upgrading to version 3, but can you tell me what features to make it worth upgrading. Does anyone know the following problem ? Recently, I move my VO from the old machine with Windows 2000 to a new machine with Windows XP Pro. When I run an application with bBrowser under VO in the new machine with Windows XP Pro, I get an error message "The ordinal 125 could not be located in the dynamic link library VO27OLE.DLL". In the old machine with Windows 2000, I do not have such problem. Thanks. TW
From: Willie Moore on 21 Apr 2010 15:16 Hey, The SQL classes in VO used ODBC. That is why I went with VO2ADO. Much better performance. When you use SQL, it is really best to pull only the records that you need. I have tables that have more than 100 fields but I never need them all on the same screen. But just in case I did because I was reading in the data for a tab window. I would set my bBrowser up to only include the fields on each tab that needed to be shown. Keeps everything nice and neat. Regards, Willie "TW" <TYRONEWU(a)LIVE.COM> wrote in message news:c8e7093a-b4bc-48d6-ba80-7999bbd19cc2(a)x18g2000prk.googlegroups.com: > Hi, > > I would like to thanks for Geoff. I can make it work now but the speed > of loading is so much slower than DBF. DBF can show it almost right > away. Anyway I can set the Query statement to include less columns and > rows. For this table I have 68 fields and 3785 records. It does not > seem to be a problem in DBF. > > > Also thanks for Jorge. I will consider of upgrading to version 3, but > can you tell me what features to make it worth upgrading. > > > Does anyone know the following problem ? > Recently, I move my VO from the old machine with Windows 2000 to a > new > machine with Windows XP Pro. When I run an application with bBrowser > under VO in the new machine with Windows XP Pro, I get an error > message "The ordinal 125 could not be located in the dynamic link > library VO27OLE.DLL". In the old machine with Windows 2000, I do not > have such problem. > > > Thanks. > > TW __________ Information from ESET NOD32 Antivirus, version of virus signature database 5048 (20100421) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com
From: Geoff Schaller on 21 Apr 2010 18:20 TW, (What is your name please). In summary, a SQL version can always be made to run as quickly as DBF, with some caveats, but there are many things that can be 1000 times faster than for DBF. Computation and reporting among them. There are some things that a just too difficult to do in DBF that is a snap in SQL. And remember that filters are fast and exciting in SQL. Let's look at how you can make your app work faster: 1. Use ADO instead of ODBC. This is just simply vital. 2. Use MS SQL Express instead of MySQL. It is an order of magnitude faster. 3. Do not use the VO SQL classes. Use VO2Ado. There is a small cost here. 4. Make sure you have appropriate indexes, a primary key, etc in your table. 5. Pull only the columns and rows you need. Having said that, I would expect 4000 rows to load virtually instantly and in my applications they do. And this is on bBrowser. Why should you upgrade to bBrowser 3.0? Well for exactly the same reason you should be using VO 2.8 - major, major class and functionality upgrades and bug fixes. Please tell me the argument for NOT upgrading? The cost is small. Read their update and What's New docs for precise details. Your DLL error is simple DLL hell. You have one with the wrong version in the execution file path. Cheers, Geoff "TW" <TYRONEWU(a)LIVE.COM> wrote in message news:c8e7093a-b4bc-48d6-ba80-7999bbd19cc2(a)x18g2000prk.googlegroups.com: > Hi, > > I would like to thanks for Geoff. I can make it work now but the speed > of loading is so much slower than DBF. DBF can show it almost right > away. Anyway I can set the Query statement to include less columns and > rows. For this table I have 68 fields and 3785 records. It does not > seem to be a problem in DBF. > > > Also thanks for Jorge. I will consider of upgrading to version 3, but > can you tell me what features to make it worth upgrading. > > > Does anyone know the following problem ? > Recently, I move my VO from the old machine with Windows 2000 to a > new > machine with Windows XP Pro. When I run an application with bBrowser > under VO in the new machine with Windows XP Pro, I get an error > message "The ordinal 125 could not be located in the dynamic link > library VO27OLE.DLL". In the old machine with Windows 2000, I do not > have such problem. > > > Thanks. > > TW
First
|
Prev
|
Pages: 1 2 3 Prev: Application created with VO 2.8 on Windows 7 Next: Color Cell in DataBrowser |