field that's added to typedList isn't in the generated sql

Posts   
 
    
yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 07-Nov-2007 17:20:06   

version 1.0.2005.1 final (self-servicing) VS2005 asp.net 2.0


hiya,

I have:

1) added a field to a typedList 2) saved the project 3) regenerated the project 4) reloaded the c# generated project 5) rebuilt my entire client solution.

I've tried several other things, but the bottom line is that the new field is not being found. I don't think it's relationship issue, becuause the field in question is a simple text field, and I can ALREADY display a similar field from the same table.

I can also see the field in the "TypedListClasses" folder of the DAL project.

Any ideas? I've been cleaning, building, rebuilding and even manually adding the dll from the DAL project.

I'm not using source control, so that can't be the issue

Why can't it find it? When I look at the datagrid field, it simply displays System.Data.DataRowView

I have the column correctly set up, and as I say, the field isn't in the generated sql..so that is my issue.

many thanks,

yogi

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 08-Nov-2007 10:02:08   

So when you bind the TypedList to a new Grid, a column gets displayed automatically at runtime corresponding to the new field?

Which runtime library version are you using?

but the bottom line is that the new field is not being found.

What do you mean by the field is not found?

the field isn't in the generated sql

Are you missing the field itself, or the field is there but no data is retrieved for it.

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 08-Nov-2007 11:32:31   

hiya Walaa,

So when you bind the TyoesList to a new Grid, a column gets displayed automatically at runtime corresponding to the new field?

No, if I use autogenerate columns, then the field does NOT appear in the datagrid.

Which runtime library version are you using?

As stated, version 1.0.2005.1 final (self-servicing).

What do you mean by the field is not found? Quote: the field isn't in the generated sql

Are you missing the field itself, or the field is there but no data is retrieved for it.

The field does not exist in the generated sql.The query does not contain the field.

many thanks,

yogi

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 08-Nov-2007 12:07:59   

That's the LLBLGen pro version, but I need the runtime library version. The runtime library version is obtainable by rightclicking the SD.LLBLGen.Pro.ORMSupportClasses.NETxy.dll in windows explorer and then by selecting properties and the version tab. The version is then enlisted at the top as the fileversion. It has the typical format as 2.0.0.YYMMDD, or starting in 2007, the format 2.0.YY.MMDD

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 08-Nov-2007 12:18:26   

hiya,

ok, sorry, it's 1.0.20051.060719

yogi

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 08-Nov-2007 14:41:21   

I guess the ASP.NET application somehow is using/referencing an old build of the generated code. Sometimes ASP.NET keeps using old assemblies from the Temporary ASP.NET Files.

yogiberr
User
Posts: 432
Joined: 29-Jun-2005
# Posted on: 08-Nov-2007 15:09:44   

hiya,

ok, I removed the project ref to the dalProject.

I then rebuilt dalProject, then re-added the ref, it worked then.

Thanks for the help. If anyone knows of an easier way to ensure that I have the latest build, please share.

Problem solved for now anyway.

cheers,

yogi