Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MyFirstSQL
Message
From
02/08/2011 06:29:15
 
 
To
31/07/2011 20:44:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Miscellaneous
Thread ID:
01519710
Message ID:
01519873
Views:
36
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform