sql underscore

[kokenge]

Would be nice if RB could access DataBase fields with a underscore (_).
Many existing databases use that feature to separate words.
I run into this often.

For example.. If you have a customer table called cust with fields such as:
cust_num
cust_name
addr_1
addr_2
zip_code


Instead of a query like
SELECT * FROM cust
When you extract the row as in:
cust.num = #row cust_num()
RB generates an error

You must name each field and give it an alias in the sql query like:
SELECT
cust_num as custNum
cust_name as custName
addr_1 as addr1
addr_2 as addr2

Doing alias don't seem to complicated. However I have some sql commands that are nearly a page long. when doing a lot of joins and sub-selects, the sql commands tend to get very confusing with all the alias fields.

Have a great day..
Dan

[StefanPendl]

The underscore is reserved for Windows API constants in LB.
RB and LB5 share the same code base, so they share the same naming conventions.

I suppose, that RB will never support Windows API, so this restriction could be removed depending on how deep it is coded into the code base.
May be leaving it in and adding a check to the parser, to differ between LB5 and RB would be an easier task.