PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WEBDEV 2024 → Update column value within GPU_User_Group (Custom User Groupware)
Update column value within GPU_User_Group (Custom User Groupware)
Iniciado por Jiva, 15,ago. 2015 07:10 - No hay respuesta
Publicado el 15,agosto 2015 - 07:10
Hi there,

Only recently got my hands on WebDev20 and working on my first project.

For my project I needed to use 'Custom User Groupware' in order to modify the user registration form. The main modification I needed to make was to add a dropdown list from which the user can select which group they join.

The problem is I can't figure out how to update the 'GPU_User_Group' data file so that the value for 'IDGroup' reflects their dropdown selection.

I have tried using the 'SQLConnect' function to connect to the 'WDGPU' analysis and then use the 'SQLExec' function to update the 'GPU_User_Group' table/columns using a query such as:

SQLExec("UPDATE GPU_User_Group SET IDGroup = "+SelectedGroup+" WHERE GPU_User_Group.UserID = "+sUserID, "UPDATEGROUP")


However the table does not get updated. When I test out the same process using one of the tables within the project's own analysis - it does work - so it seems to be something related with the attempt to connect/modify an external data file.

Any help on this would be greatly appreciated!