Randy Blair asked 10 years ago
I have many fields/columns that have spaces. The program breaks when in form mode and submit is pressed. It will try to put underlines in the field name and then it errors out because there is no field with that name.
I don't have an option to rename the fields, so is there a fix for this?
Abu Ghufran answered 10 years ago
The latest build make grids display those fields.
Limitation is the add/update/delete operations will not be functional.
Emailed you an update.
Randy Blair answered 10 years ago
That is not acceptable. The add/update/delete operations have to be functional.
Forms no longer pop up. This is a catastrophic loss for my application, and if it can't be fixed, I will need my money back, please.
Abu Ghufran answered 10 years ago
Thread resolved on email. Updating ticket just to log solution and help others.
You will need to alias the spaced fields with '-' and set query in select_command. e.g.
$g->select_command = "SELECT `i d` as `i-d`, `client id` AS `client-id`, `inv date` AS `inv-date` FROM invheader";
Rest functionality (add/update/del/search) will be handled by library.
Updated build may be required.
