Remote View -- Line Too Long
Remote View -- Line Too Long
(OP)
I am in the process of converting vfp tables to sql server express. I have the connection made and have used remote views. For several tables this works fine.
However, I have a few tables that, have very long field names. When I try to create the remote view I receive an error that "line is too long". I am assuming this means the field name as opposed to the number of fields which is about 245. Is that correct? (In looking at the "view sql", I see it has truncated several of the field names).
Also, if it is the length of the field is there any way around it without having to go through and rename everything?
Thanks for any help.
Greg
However, I have a few tables that, have very long field names. When I try to create the remote view I receive an error that "line is too long". I am assuming this means the field name as opposed to the number of fields which is about 245. Is that correct? (In looking at the "view sql", I see it has truncated several of the field names).
Also, if it is the length of the field is there any way around it without having to go through and rename everything?
Thanks for any help.
Greg
RE: Remote View -- Line Too Long
When you say the number of fields in the view is about 245, are they all coming from one table? If so, I'd take a long, hard look at normalising that table. And if they're coming from multiple tables, what are you going to do with all that data in one view?
Good luck,
Jim
RE: Remote View -- Line Too Long
While my fields are long, they are not 128 characters. The fields exist in a table right now.
RE: Remote View -- Line Too Long
CODE
lnH1 = SQLSTRINGCONNECT(Add in your connection string here)
TEXT TO lcSql NOSHOW PRETEXT 7
*(Create SQL View text goes here)
ENDTEXT
lnResult = SQLEXEC(lnH1, lcSql)
Regards,
Jim