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?
The latest build make grids display those fields.
Limitation is the add/update/delete operations will not be functional.
Emailed you an update.
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.
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.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!