Hi Carlos and All, Oh ya, i am also trying to use VB6.0 and mysql in window environment but is not sure how well they work together, may i know which middle ware you use to bridge the communication between VB6 and Mysql.
----- Original Message ----- From: "Carlos Rovetto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, 15 July, 2002 9:17 AM Subject: MySQL and Visual Basic 6.0 > Hi. I am begining using MySQL with Visual Basic 6.0 in Windows 98 first > edition. Some times i to receive this message but i don't know why. > > Error on rename of '.\video\products.MYI' to '.\video\#sql2-fffa6015-3.MYI' > (Errcode: 13) > > The SQL instruction is: > alter table products add (unitprice double(7,2), precio2 double(7,2)) > > I don't know if use MySQL with VB and Windows is good idea. > > Thanks > > Carlos > > >From: "Shashank Tripathi" <[EMAIL PROTECTED]> > >To: "'Kyle and Beth Kelly'" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> > >Subject: RE: Beginner's question > >Date: Mon, 15 Jul 2002 09:49:12 +0900 > > > >Hi Kelly, > > > > > > | I am writting a search engine using Mysql. I am trying to return > > | a text object value (which contains all of the html), but it is > > | taking about 10 seconds to return each text value matching my > >query. > > | Is there any way that a text value can be optimized? > > > > > >An SQL query example of what you are doing currently would have been > >useful. Are you using '%LIKE%' for "matching"? Or is it taking 10 > >seconds for normal selects as well? > > > >I assume there is a good reason why you are storing the whole HTML in > >your database, because it includes a whole bunch of redundant tags, > >links etc. Editing your page may become one hell of a chore very soon > >(e.g., if you just need to update a link!). > > > >But anyway, as for the text stuff try the INSTR function > >(http://snipurl.com/instr) and see if that helps? Perhaps you could take > >a look at regular expressions in some way too > >(http://snipurl.com/mysql_regexp) but am not sure how useful that is > >unless I know your table structure. > > > >Meanwhile, you could also try a slightly different approach of having a > >separate HTML_SEARCH table which maintains a link to the html blobs in > >your current table, but saves ONLY the content (no html tags etc). This > >way, the db does not have to search for a whole bunch of redundant tags > >but still would have a link to your current html files which are saved > >in a separate table that is used only for a layout. > > > >Hope this helped, > >Shanx > > > > > >-- > >Shashank Tripathi > >www.shanx.com > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > _________________________________________________________________ > Charle con sus amigos online usando MSN Messenger: http://messenger.msn.com > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php