False Generated code

Posts   
 
    
Generator
User
Posts: 2
Joined: 09-Nov-2012
# Posted on: 09-Nov-2012 14:58:25   

Hi All,

I have generated code from designer pro v3.5 for new table and the old generated code was working perfectly but the new code caused problems in my existing code and when I undo changes for non needed entities I still have the problem.

the last query that made problem was

"SELECT [DB].[dbo].[UserRole].[Id], [DB].[dbo].[UserRole].[RoleID] AS [RoleId], [DB].[dbo].[UserRole].[UserId] FROM [DB].[dbo].[UserRole]

ORDER BY [DB].[dbo].[WithdrawalType].[Order] ASC

"

although withdrawaltype is another table and it is not related to the new generated table !!

and the error was "The multi-part identifier "DB.dbo.WithdrawalType.Order" could not be bound."

any ideas to begin with, I donot know how to begin ?

Thanks, Generator

Generator
User
Posts: 2
Joined: 09-Nov-2012
# Posted on: 09-Nov-2012 19:02:59   

Hi All,

I made some tracing and I think some generated files are corrupted

like I have this statement

DALHelper.FetchCollection(_removeTypes, null, null, new SortExpression(WithdrawalTypeFields.Order | SortOperator.Ascending));

when I changed it to the below it passed this statement

DALHelper.FetchCollection(_removeTypes, null, null);

but after that it generated another error confused

Any ideas ?

Thanks, Generator

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 10-Nov-2012 00:57:39   

Hi Generator,

  • What is your LLBLGen version + buildnr? (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7725)

  • From what you just said in your last post, I don't understand whether it's a compilation error or a runtime error.

  • If you have more than one version of LLBLGen Pro, make sure that your generated code references the correct assemblies.

  • What if you generate to another empty folder?

David Elizondo | LLBLGen Support Team