Problem sincronization with database (MySQL) and grid

Developers Databases
#1

Hi,

I need to insert a new field in a table, and I create a new field in FIELDS and sincronize the form with the database perfectly, but I need to use this new field in the grid for group the registers by month using GROUPBY but the field doesn?t appear in GROUPBY section in the grid, how can I see the field to use the GROUPBY?

Thanks,

Eduardo C?zares

#2

Re: Problem sincronization with database (MySQL) and grid

Add the field to the grid SQL manually. Then add the field to the app in ‘Selected Fields’. It should be then be visible.

Regards,
Scott.

#3

Re: Problem sincronization with database (MySQL) and grid

Hello Sir,

Like Scott Martin said, you need to insert this field in your SQL, then in Selected Fields add this field to show in your app.