Salut Mike.

That's it. A regular character field. But i need this field to be a memo. Any idea why?

Thanks.

>Salut JF

>So what are you getting? A regular character field? Because in MSSQL you do get a memo >field from a TEXT type.

>>Hi.
>
>I use this command to create a cursor.
>
>SQLEXEC(lnHandle, "SELECT * FROM test", "mycursor")
>
>I was expecting that data field type (in MySql) "TEXT", was the same as MEMO. But it does not seem to.
>
>I am using this cursor in a maintenance and my column is the recordsource of an editbox and behaving badly.
>
>Any suggestion are welcome.
>
>Thanks.