|
Troubleshooting Troubleshooting and Known issues with Apex SQL Tools Some of my SQL objects have multiple words in their names (for example, [Order Details]) and this causes the errors when they are used as... Some of my SQL objects have multiple words in their names (for example, [Order Details]) and this causes the errors when they are used as method names? CAUSE Database object names like [Order Details] not valid for identifiers in programming languages. RESOLUTION Write your own function to convert names or define aliases (see help here: http://www.apexsql.com/help/apexsqlcode/HTML/Support/_FAQs.htm#How_do_I_change_an_Alias_of_an_Object_) for the objects and use alias in your templates. For example, take the following function MakeValidFilename (VB.Net) as the base: Function MakeValidFilename(vString As String) As String And call it in proper cases Public Interface I<%= MakeValidFilename(objTable.Name) %> For the Order Details table it writes Public Interface IOrder_DetailsLAST REVIEW DATE 10 August 2007 Labels: ApexSQL Code |
© 2008 Apex SQL Tools All Rights Reserved | 1.919.968.8444 | Contact Us | Terms of Use | Privacy Policy
