I am doing something that involves populating a cursor that matches a table living in a MySQL back end.

In one instance, I simply want to create a cursor with empty records having the same field definitions as the backend. I have been trying to do this by sending the equivalent of "SELECT * FROM Table WHERE .F." and then running some append blanks to make my blank records. The problem arises with text fields. If I get an empty cursor back from the passthrough, the text fields are defined to be of zero length, rather than the lenght of the field on the back end.

Does anyone know of a way to make the fields retain their original length without explicity specifying fields or definitions?

TIA

Russ