Need to run an SQL UPDATE against .EAP

[mhdhallak]

Hi

I need to run an UPDATE statement against my model to update the file path of elements' attachments.

I have my UPDATE statement tested and ready to execute but I don't know how to execute it against my model (.EAP file).

Code: [Select]

UPDATE t_objectfiles SET FileName = 'S:\' + MID(FileName,13) WHERE MID(FileName, 1,1) = 'D'


Where can I execute this statement? I tried the Run Patch command under the Tools menu but it's not working there.

[thomaskilian]

Hmm. Depending on your DB it would be SQL+ or the MS Enterprise Manager or another Query tool. There's also a place in the advanced search of EA where you can execute a SQL (Advanced/New Search/SQL Editor).

[sargasso]

 

There's also a place in the advanced search of EA where you can execute a SQL (Advanced/New Search/SQL Editor).

Why didn't someone tell me about this before!!!


thanks TK!

bruce

 Where's the Help!!!

[AshK]

Hmm. Depending on your DB it would be SQL+ or the MS Enterprise Manager or another Query tool. There's also a place in the advanced search of EA where you can execute a SQL (Advanced/New Search/SQL Editor).

This feature only allows select queries.

[KP]

I have my UPDATE statement tested and ready to execute but I don't know how to execute it against my model (.EAP file).

An EAP file is an MS Access database with the file extension changed, so you can simply open it in MS Access and perform your update in there.

Of course all the usual caveats apply: you modify the database at your own risk.