December 19, 2002 at 10:28 am
Hello,
I'm trying to create a replication of a database for use as a 'workspace' for the client so they can go, try changes, if they like them, replicate the changes back without fear of destroying anything real until they're sure they want to make the changes.
Tables and data replicate over fine using a PULL subscription.
Views and stored procedures are giving me fits. Views do not seem to be smart enough when auto generated to create themselves in dependency order.
Stored procedure replication seems to have issues with aliased columns made up select col1 + "-" + col2 + "-" + col3 as "CombinedField" Grumps that the column names "-" are invalid.
Any thoughts on this? Everything else is falling into place except for this pain.
Regards,
Christopher Klein
Point Software, Inc.
December 19, 2002 at 12:27 pm
Change from double quotes to single quotes. Your syntax should be
col1 + '-' + col2 + '-' + col3 as CombinedField
Note that I didn't put quotes around the field name although I could have. If you have spaces in the field name you can use either double quotes or [] to name the field but I would opt for the [] myself.
Gary Johnson
DBA
Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply