Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MyFirstSQL
Message
From
02/08/2011 13:25:22
 
 
To
02/08/2011 08:36:07
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:
01519922
Views:
33
Hi Christian:

First I haven't change any settins yet.

>That should not happen. Maybe I misunderstood your problem, but can you give me an example whhich query you run and what the cursor contains?

I'm uploading four images.

table.jpg is the remote table (it's really on a web server)

records.jpg are the first records of the mentioned table. I hope you can see they look very nice and proper.

select.jpg are the two instructions I tested.

Cause I tried to use VFP functions and they failed I assume MySQL has a different sintax so I'll have to learn it.

finally cursor.jpg is the result. As you can see "tinytext" converts to memo field. (as text, as fulltext)

I can't believe it but as Juan Perón said: "There's just a truth: Reality"

Thank you.

Héctor
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform