compile error when using % character as column name

[lauerj]

The vb code powering one of my forms is giving me a compile error due to my use of the '%' character in the following statement:

fsubQtrDemand.Controls("textnp" + strTag).Value = rst!%_hr_peak

However '%_hr_peak' is the name of the column that I need to read from...is there a easy syntax change I need to make in order to get the code to compile? Any other solutions?

 

[danvlas]

fsubQtrDemand.Controls("textnp" + strTag).Value = rst.Fields("%_hr_peak&quot

But why on earth are you using special characters in field names?????





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[lauerj]

It's an application I inherited and was hired to fix!

 

[lauerj]

Alright, I was able to solve my problem by using an alias in my SQL query (returning the %_hr_peak field AS PercentHourPeak). Binding the expression inside [] usually works as well but was not in this case I think because it was a calculated expression.

A number of fields in this db do not make sense. Does it matter if there are spaces in the table names or field names?

 

[danvlas]

No, it doesn't matter. However, in such cases you need to bracket the name: [Field Name]

It's highly recommendable to avoid spaces and special characters, but since you've inherited the application I don't think you can strip them...

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html