Skip to navigation
How to execute multiple sql commands with pervasive database
07.12.13
Reply
Anonymous
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
Reply
Anonymous
Information Epoch 1741955144
A language that doesn't affect the way you think is not worth knowing.
Home
Notebook
Contact us