Bug (InnerJoin + RenderPage)

[Eduardo]

Hi, i don't speak english, but need help :)

problem ocurred in query

FromTerm tDocuments = FromTerm.Table("Documents", "d");
FromTerm tTemplate = FromTerm.Table("TD00075", "t");
SelectQuery query = new SelectQuery();
query.FromClause.BaseTable = tDocuments;
query.Columns.Add(new SelectColumn("DocumentId", tDocuments));
query.Columns.Add(new SelectColumn("DocumentPathFolder", tDocuments));
query.Columns.Add(new SelectColumn("DocumentName", tDocuments));
query.Columns.Add(new SelectColumn("TemplateId", tDocuments));
query.Columns.Add(new SelectColumn("Valor Total", tTemplate));
query.FromClause.Join(JoinType.Inner, tDocuments, tTemplate, "TemplateId", "TemplateId");   
query.OrderByTerms.Add(new OrderByTerm("DocumentId", tDocuments, OrderByDirection.Ascending));
SqlServerRenderer renderer = new SqlServerRenderer();
string sqlServer = renderer.RenderPage(pageIndex, pageSize, totalRows, query);

bug on generate sql string..  in ALIAS...
here created alias F on query... but don't use this.

im waiting help...
sorry my translation.

[Alon Catz]

This was a bug in Sql.Net.

Fixed in version 0.54

Alon.