Hi
I would like to copy a datarow completly amd change the ID.
Since there are many rows i am looking for a way without the complete SQL.
In SQL i would do it like this:
INSERT INTO `MEMBER`( `ID`,`C_NO`, `U_NO`, `GIDEON_NO`, `AUX_NO`, `TITLE_G`, `SALUT`, `FN_G`, `FN_G_SEC`, `TITLE_A`, `FN_A`, `FN_A_SEC`, `F_NAME`, `STR`, `POBOX`, `PLZ`, `CITY`, `POS_LAT`, `POS_LNG`, `FIRMA`, `JOB`, `TELB`, `TELP`, `TELM_G`, `TELM_A`, `FAXP`, `FAXB`, `C_C`, `C_C_CITY`, `B_DAY_G`, `EMAIL_G`, `CERT_G`, `LTM_G`, `G_ED`, `CHAIRMEN_G`, `CABINET_G`, `CABINET_G_S`, `NAT_C_G`, `NAT_C_G_S`, `CS_S_T`, `CS_S_T_DAT`, `CS_LANG`, `CS_S_T_AUX`, `CS_S_T_DAT_AUX`, `CS_LANG_AUX`, `NMDM_G`, `NMDM_A`, `PAB_G`, `PAB_A`, `B_DAY_A`, `EMAIL_A`, `CERT_A`, `LTM_A`, `A_ED`, `CHAIRMEN_A`, `CABINET_A`, `CABINET_A_S`, `NAT_C_A`, `NAT_C_A_S`, `NOTE`, `CRSP`, `INFO`, `OPT`, `L_UPDATE`, `STAT_UPDATE`, `STAT_DEL`, `RPL$LOCAL` )
SELECT '{F61166D5-7A2C-4528-9694-0209F712D1C8}',`C_NO`, `U_NO`, `GIDEON_NO`, `AUX_NO`, `TITLE_G`, `SALUT`, `FN_G`, `FN_G_SEC`, `TITLE_A`, `FN_A`, `FN_A_SEC`, `F_NAME`, `STR`, `POBOX`, `PLZ`, `CITY`, `POS_LAT`, `POS_LNG`, `FIRMA`, `JOB`, `TELB`, `TELP`, `TELM_G`, `TELM_A`, `FAXP`, `FAXB`, `C_C`, `C_C_CITY`, `B_DAY_G`, `EMAIL_G`, `CERT_G`, `LTM_G`, `G_ED`, `CHAIRMEN_G`, `CABINET_G`, `CABINET_G_S`, `NAT_C_G`, `NAT_C_G_S`, `CS_S_T`, `CS_S_T_DAT`, `CS_LANG`, `CS_S_T_AUX`, `CS_S_T_DAT_AUX`, `CS_LANG_AUX`, `NMDM_G`, `NMDM_A`, `PAB_G`, `PAB_A`, `B_DAY_A`, `EMAIL_A`, `CERT_A`, `LTM_A`, `A_ED`, `CHAIRMEN_A`, `CABINET_A`, `CABINET_A_S`, `NAT_C_A`, `NAT_C_A_S`, `NOTE`, `CRSP`, `INFO`, `OPT`, `L_UPDATE`, `STAT_UPDATE`, `STAT_DEL`, `RPL$LOCAL`
FROM `MEMBER`
WHERE `ID` LIKE '{63FB46AF-4158-4585-8913-A676B10A3AF9}'