FOROS PROFESIONALES
WINDEV
,
WEBDEV
y
WINDEV Mobile
Inicio
|
Mensajes recientes
|
Conéctese...
|
Desconectar
|
Español
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
Conéctese…
Jiva
#1
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 = "
+
s
UserID
,
"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!
Informar
0
0
→ Volver a WEBDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versiones precedentes)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Búsqueda Tipo
Sólo temas
Todos los mensajes
Periodo Buscar
Cualquier fecha
Última hora
Última 24 horas
Última semana
Último mes
Último año
Cancelar
Vista previa del mensaje
Añadiendo una imagen
Importar una imagen desde una URL
Enviar una imagen desde un archivo de su disco
Arrastrar un archivo o click en "Examinar..."
o
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto