rado
Posts: 221
|
| Posted: 11/07/2008, 1:51 PM |
|
When I create record grid everything worked just fine, however when I changed the type of one of the filed from text-box to list box, I'm not able to do any insert or delete. When I try to insert I got error :
"Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' unit_types (unit_number, unit_sqf, unit_floor_number, unit_number_of_rooms, uni' at line 1"
When I try to delete record I got:
"Database Error: Table 'rr_db.units, unit_types' doesn't exist".
These tables exist 100% and I'm not sure where could be the problem.
Again update of already created records works just fine.
Thanks for help
Rado
|
 |
|
Gena
Posts: 591
|
| Posted: 11/07/2008, 2:06 PM |
|
First of all - don't mix together two different things: "record grid"  It is not possible to have record grid in CCS. Grid - is a list, Record - is a form to change/add/delete one record.
About you problem - try just to delete your problem field from the Record, regenerate page and check if it works. After add this field again and set correct parameters.
_________________
Gena |
|
|
|
rado
Posts: 221
|
| Posted: 11/07/2008, 2:14 PM |
|
Thanks Gena,
Sorry for wrong interpretation.
I just delete my problem field, re-generated the page and it still same problem.
Rado
|
|
|
|
melvyn
Posts: 333
|
| Posted: 11/07/2008, 2:31 PM |
|
Quote Gena:
First of all - don't mix together two different things: "record grid" It is not possible to have record grid in CCS. Grid - is a list, Record - is a form to change/add/delete one record.
When somebody says "Record Grid" I understand the reference to "Editable Grid" which, in its basics, is grid of editable records.
Just to clarify
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
Gena
Posts: 591
|
| Posted: 11/07/2008, 2:34 PM |
|
So it means that not this field was a problem.
Do you use standard (not Custom) Insert/Update/Delete properties? Check all Record properties (like Conection, Data source etc, look at VQB - if all is OK there), check all fields and its properties on the record.
_________________
Gena |
|
|
|
Gena
Posts: 591
|
| Posted: 11/07/2008, 2:36 PM |
|
also are you talking about Record? not Editable grid?
_________________
Gena |
|
|
|
rado
Posts: 221
|
| Posted: 11/07/2008, 2:57 PM |
|
Thank you for help. I couldn't find where is the problem. I run grid record wizard again and now everything works just fine.
Thanks again.
Rado
|
|
|
|
melvyn
Posts: 333
|
| Posted: 11/07/2008, 3:24 PM |
|
Hello rado,
I know you're newbie in CCS and don't have any ideas of your background with programming.
A must have for every programmer is to be mathematically exact. In programming, as in life, everything count, everything, "var" isn't "bar" neither "Var". A programmer must be exact. Always.
Having said that, there isn't any "grid record wizard". If you see you toolbox, then you can see:
Grid Builder
Record Builder
Grid and Record Builder
Report Builder
Editable Grid Builder
....
If you use the exact name, everybody can understand. Double-check them always.
Have fun,
_________________
Melvyn Perez
Puro Codigo
http://purocodigo.com |
|
|
|
rado
Posts: 221
|
| Posted: 11/07/2008, 3:41 PM |
|
Thanks, I will make sure to be precise next time.
Rado
|
|
|
|
|
 |
|
|
|
