sort

[Robo0502]

Hi guys I have a problem with sorting the data on CF_main form. Sorting according Issue, PSD vs RSD or order qty is working perfectly. The problem is with PN Desc. For some reason it is working only when I sort the data in the beginning alphabetically and then it is not cooperating. dont know why.

could you help me with that? I attached the db. thank you

 

[namliam]

Odd, not even the Report table can be sorted on the Product Description column

My first thought was it would be a lookup column, but that isnt true... Really odd...

Removing the "sort on load" helps, but doesnt fix it either....

I would consider dropping the table and creating it a new...

Just FYI: Naming convention

 

[Robo0502]

you are right. even in the report table is the same problem. I have found out that problem is when a column name consists 2 or more words and one of them is "Description"...sounds weird but after I renamed the column everything works fine.

thank you

 

[namliam]

Must have somethign to do with DESC for some reason... bug ?

Though overall using spaces in names is a bad idea.

 

[CJ_London]

Desc is a reserved word so if you did not put square brackets around [PN Desc] this would definitely be the problem. As Namliam states, using spaces is not a good idea, square brackets often solve the problem, but not always - this may be one of those cases