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 1760419384
Looking for the ninety percent solution.
Home
Notebook
Contact us