>Hi Boris
>
>I generally tend to prefix all field names with the first 3 characters of the table so there usuaully is not a clash of field names.
>The reason I dont want to have to nominate the fieldlist, is that the resulting cursor becomes the source for a Grid, and
> the fields to be displayed on the grid are taken from a user specified file. So I want to have all the possible fields available so I dont have to reompile each time a user will request a field. Also, there could be 50 fields in easch table so its a bit of a pain going through each one...... but if that's what I have to do
>
>Regards,
>Gerard
>
>
I remember a while ago my colleague Mike Asherman invented deNUll program for this exactly purpose. I don't know if this program is published on UT, though,,,
If it's not broken, fix it until it is.
My Blog