Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MyFirstSQL
Message
De
02/08/2011 06:29:15
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Divers
Thread ID:
01519710
Message ID:
01519873
Vues:
37
Hi Christian:

>I use MEDIUMTEXT for memo fields.

>Also, in the mysql.ini file you have to add those lines (restart the service after modifying the file):


># Large log files because we use a lot of large fields.
>innodb_log_file_size=128M
>innodb_log_buffer_size = 8M
>innodb_autoextend_increment = 8M
>innodb_flush_log_at_trx_commit = 1
>After you changed this, you need to stop the mysql service, then delete the log files (ib_logfile0 and ib_logfile1), and then start the mysql service. >This will rebuild the logfiles so the startup will take a few seconds longer.

>Also, add this line so you can have sufficient connections:

>max_connections = 200
>And, last but not least, add this line:

># To avoid slow connection because of a reverse DNS lookup:
>skip-name-resolve

All that??

Well. The problem is not the field type of database when the cursor transform them as memo fields. The problem is still there. Apparently you can't help converting text fields in database table as text fields in local cursor or table.

First I installed the driver as you told me. Then I configured it. Then when I saw the data in the SQLSTRINGCO... instruction is the same of OBDC driver I deleted the "mysql" item and the connection worked well. You perhaps mean if I restart the machine SQLSTRING... doesn't work anymore?

Thank you. I'll go on testing.

Héctor
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform