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 1746752698
When you must fail, fail noisily and as soon as possible.
Home
Notebook
Contact us