Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Truncation in result of a SELECT
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement