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 1756137395
Multiple programs can be composed together to perform more complex functions.
Home
Notebook
Contact us