Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 14

Displaying posts with tag: MyComponents (reset)

MyComponents: Product End-Of-Life
+1 Vote Up -0Vote Down
It is with much regret and after a long deliberation and consultation process that we have to announce that, after an epic run of almost 11 years in the era of MySQL 3.11 in the late 1990s, the MyComponents product has reached the end-of-life stage. Given Delphi's progressive slide in popularity, it is no longer economically viable for SciBit to maintain.

We will however continue to sell and support licenses for the current Delphi 2007 compatible version. As well as support (and even contribute) to any open source project born from this product should someone feel so inclined.
MyComponents: Version 2006.4.5 - Delphi 2007 Release
+0 Vote Up -0Vote Down
It gives us great pride to announce the release of MyComponents V4.5 native Delphi/Kylix VCL suite. This update includes mainly fixes to issues as it has been reported to Support and on this and other forums as well as Delphi 2007 packages, help, apis and demos.

This update is free of charge for all customers whom own a 2005.4.x MyComponents serial. Everyone still using a pre-2005.4 MyComponents may upgrade to the newest version by logging into their Secure accounts: simply click the Secure link at the top of this page.

Previous articles concerning MyComponents 4.x are:
MyComponents 2005.4.4 released
MyComponents 2005.4.3 released







  [Read more...]
MyComponents: Version 2006.4.4 released - Maintenance Release
+0 Vote Up -0Vote Down
It gives us great pride to announce the release of MyComponents V4.4 native Delphi/Kylix VCL suite. This update includes mainly fixes to issues as it has been reported to Support and on this and other forums.

What's new?

TMySQLDataset:
New: RemObjects' DataAbstract driver 3 and 4 API included.
Fix: Various issues as has been reported to SciBit Support

This update is free of charge for all customers whom own a 2005.4.x MyComponents serial. Everyone still using a pre-2005.4 MyComponents may upgrade to the newest version by logging into their Secure accounts: simply click the Secure link at the top of this page.

Previous articles concerning MyComponents 4.x are:
MyComponents 2005.4.3










  [Read more...]
MyComponents: RemObjects DataAbstract 3 API Released
+0 Vote Up -0Vote Down
SciBit is proud to announce the release of the MyComponents API packages for interfacing with RemObjects' DataAbstract.

This release includes packages for both the VCL as well as the standalone DAD driver for MyComponents. This API will become part of any future releases of MyComponents.

You can now use your favourite remote objects with your favourite MySQL components just as you would have used an ADO or IBX connection. The new API is available on the MyComponents website
MyComponents: Version 2006.4.3 released - Now with Delphi 2006 Support
+0 Vote Up -0Vote Down
It gives us great pride to announce the release of MyComponents V4.3 native Delphi/Kylix VCL suite. This update includes mainly fixes to issues as it has been reported to Support and on this forum, as well as Delphi 2006 certification.

What's new?

TMySQLDataset:
New: doSingleSQL option which allows an SQL script to be executed as a single SQL statement, thereby enabling you to use the SQL property to define functions and procedures in MySQL.
Fix: Various issues as has been reported to SciBit Support

This update is free of charge for all customers whom own a 2005.4.x MyComponents serial. Everyone still using a pre-2005.4 MyComponents may upgrade to the newest version by logging into their Secure accounts: simply click the Secure link at the top of this







  [Read more...]
MyComponents: Quick Tip 2: MyComponents for MySQL in Threads
+0 Vote Up -0Vote Down
Definitely an issue that arises more often than not in real world applications, and definitely one that pops up on our forum from time to time.

Firstly, a bit of the fundamentals. MyComponents are derived from the standard Borland TCustomConnection and TDataset classes, and it is therefore important to realize that if these base classes' methods are not thread protected (using synchronization), neither are those of the MyComponents. That said, the MyComponents are quite safe to use in an isolated manner from and within threads (TThread). Moreover, the MyComponents classes actually makes special provision for you to create threaded connections to the MySQL server.

Also to be kept in mind, is that all Borlands' GUI VCL runs in the main application thread, and therefore is it not possible to create a dataset in a thread and have it be connected to a DBGrid for example. However, the



  [Read more...]
MyComponents: MySQL ClientLibrary 4.1.14 released
+0 Vote Up -0Vote Down
SciBit now also maintains our own libmysql.dll which supports both old and new authentication and is only 160KB in size. So if you absolutely have to use a dll (instead of the Direct driver), then you can download it from MyComponents

Unlike MySQL's newest clientlibraries, which are 1-2MB in size and is usually not versioned, does the SciBit library contain full version info, is small and works 100% with the MyComponents. NOTE: It only implements the API needed by the MyComponents, which is minimilistic, so don't go replace all your other apps' libmysql.dll with it!

It is also free, and contains 0% MySQL source code (it is written 100% in native Delphi) and therefore does not carry any licensing issues for your commercial applications.
MyComponents: Issue Notice: To BLOB or not to BLOB
+0 Vote Up -0Vote Down
It was brought to our attention that some MySQL (http://www.mysql.com) server versions, ex. 4.1.14, responds with a result containing blob columns from certain types of SQL statements, ex. "show create table abc", yet, the columns are not marked with the blob_flag by MySQL, and therefore are these columns not presented as blobs in Delphi when using MyComponents.

You can correct this in your code by update your source like this:
MySQLDataset.pas, method InternalOpenResultBlock, line ~1550
...
if (do2KStrToMemo in FOptions) and (FieldType in [FIELD_TYPE_STRING,FIELD_TYPE_VAR_STRING,FIELD_TYPE_VARCHAR]) and (FieldLength > 2048) then begin
FieldType := FIELD_TYPE_BLOB;
FieldFlags := FieldFlags or






  [Read more...]
MyComponents: Issue Notice: LastInsertID (non-critical)
+0 Vote Up -0Vote Down
A non-critical, non-severe issue was recently discovered by one of our customers in the latest release of the MyComponents. This bug will affect you if:
1. You have the latest MyComponents (2005.4.x)
2. You use the Direct driver (the bug doesn't affect any MySQL (http://www.mysql.com) libmysql.dll drivers)
3. You display or explicitly use the LastInsertID string property of a dataset
4. Your table's autoinc column's count is beyond 16 million

You can fix this bug if you are a registered customer by changing

uMySQLClient.pas, function net_field_length_ll, line 391:
...
packet:=packet+9; //8 bytes value
result:= (byte(pchar(packet)[1]))+
(byte(pchar(packet)[2]) shl 8)+













  [Read more...]
MyComponents: Version 2005.4.2 released - Now with piping support
+0 Vote Up -0Vote Down
It gives us great pride to announce the release of MyComponents V4.2 native Delphi/Kylix VCL suite. This update includes mainly fixes to issues as it has been reported to Support and on this forum, as well as some new functionality. Without explicitly setting the new properties, and thereby using the new features, should this version be completely compatible with your existing code.

What new?

TMySQLServer:
ptTCP/ptPipe: now sports connection capabilities which includes tcp (default), as well as using the MySQL pipe on the localhost.

TMySQLDataset:
New: Carry over support for previously set macro values
New: Added QueryInfo public method to obtain MySQL query informative result string
New: Added support for MySQL 5.0.3 FIELD_TYPE_BIT as ftBoolean
New: Added support for MySQL 5










  [Read more...]
MyComponents: Quick Tip 1: Flying Datasets
+0 Vote Up -0Vote Down
Due to popular demand, are we reposting our flying dataset MyComponents Quick Tip from almost a year back.

Many times in development, do you find yourself just quickly looking for a dataset containing something from the database. Usually will such a dataset not be connected to visual controls. TMySQLServer is capable of creating, maintaining and destroying just such dynamic "in-memory" datasets. These datasets closely resemble ADO or ASP style coding and each dataset is referenced by a userdefined name. You can even connect such datasets up master-detail. The aim is of course to minimize the number of lines you have to write and your effort in general. Here are a couple of examples:

Example 1 (Usage):
...

with TMySQLDataset(MySQLServer1.Dataset) do begin
ShareConnection







  [Read more...]
MyComponents: MySQL ClientLibrary 4.1.10 released
+0 Vote Up -0Vote Down
SciBit now also maintains our own libmysql.dll which supports both old and new authentication and is only 157KB in size. So if you absolutely have to use a dll (instead of the Direct driver), then you can download it from MyComponents

Unlike MySQL's newest clientlibraries, which are 1-2MB in size and is usually not versioned, does the SciBit library contain full version info, is small and works 100% with the MyComponents. NOTE: It only implements the API needed by the MyComponents, which is minimilistic, so don't go replace all your other apps' libmysql.dll with it!

It is also free, and contains 0% MySQL source code (it is written 100% in native Delphi) and therefore does not carry any licensing issues for your commercial applications.

Regards, Support
MyComponents: Campus: MYSQLTABLE1
+0 Vote Up -0Vote Down
SciBit is proud to announce the availability of our newest portal: http://campus.scibit.com.

This site is open to any and all whom which to publish or present a course on any subject. Of course, we will appreciate it very much if some of your courses do address solutions and work arounds to problems you might have experienced in regards to products and/or environments in which some SciBit products function, ex. MySQL, Delphi, Kylix, ASP, etc. But, as mentioned, your courses can be on any subject you choose, and is a way for you to give back some of your acquired knowledge to the world. We have added a few categories already and any one can register as a teacher, to compile your own courses, or as a student, to signup for courses (if they are hidden from public view).

If you wish to compile private courses and do so as a commercial venture



  [Read more...]
MyComponents: Quick Tip 7: How do I get any file contents into a blob?
+0 Vote Up -0Vote Down
This question pops up often, but the solution is not specific to MyComponents, and will work in and with any Borland dataset component (in fact, this is how you are suppose to do it in Delphi/Kylix):

TBlobField(MySQLQuery1.FieldByName('MyBlob')).LoadFromFile('MyBlobContents.doc');

the following of course also works:
TBlobField(MySQLQuery1.FieldByName('MyBlob')).SaveToFile('MyBlobContents.doc');

or you can also use the LoadFromStream and SaveToStream methods.

NOTE: If you post blobs to a table in MySQL you should keep a couple of things in mind:
1. The blob value is sent to the MySQL using a standard SQL statement. For this purpose, the value is hexed by the dataset and thus 2 SQL characters=1 blob byte.
2. Most MySQL servers' "max_allowed_packet" variable is set to a default value of










  [Read more...]
Showing entries 1 to 14

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.