|
Post by kokenge on Oct 4, 2009 10:08:26 GMT -5
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
|
|
|
Post by StefanPendl on Oct 5, 2009 2:33:44 GMT -5
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.
|
|