How to execute multiple sql commands with pervasive database07.12.13

depends on what version you can use sharp # or semicolon ; example: UPDATE "60" SET "13" = Lower("13") # UPDATE "60" SET "13" = REPLACE("13", ' ', '_') # UPDATE "60" SET "13" = REPLACE("13", '#', '_') # UPDATE "60" SET "13" = REPLACE("13", '(', '_') # UPDATE "60" SET "13" = REPLACE("13", ')', '_') # UPDATE "60" SET "13" = REPLACE("13", '__', '') # UPDATE "60" SET "13" = REPLACE("13", '.jpg_', '.jpg') # UPDATE "60" SET "13" = REPLACE("13", '_.jpg', '.jpg') UPDATE "60" SET "13" = REPLACE("13", '..jpg', '.jpg') # in the control center in the outline box you can right mouse click and execute all queries. 07.12.13

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024