Author Topic: Modify Package Flags  (Read 4633 times)

Tehila1

  • EA User
  • **
  • Posts: 256
  • Karma: +0/-0
    • View Profile
Modify Package Flags
« on: June 01, 2014, 06:54:02 pm »
Hello,

I would like to modify the semi-colon separated list of package flags.
Is there a way to do so via API or I must run an update SQL query?

Thanks.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Modify Package Flags
« Reply #1 on: June 01, 2014, 10:09:45 pm »
I guess you have to fallback to SQL in that case. IIRC some of those parameters are set as "side effect" but to modify them at your wish there is no other way than SQL.

q.
« Last Edit: June 01, 2014, 10:11:04 pm by qwerty »

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Modify Package Flags
« Reply #2 on: June 02, 2014, 09:05:36 am »
The property Flags can be written to via the automation interface so there's no need to use SQL directly.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Modify Package Flags
« Reply #3 on: June 02, 2014, 03:33:02 pm »
Simon is right. I have to update the xref in my book.

BTW Simon: can you tell me where the columns s_Generation, s_GUID and s_Lineage (in t_package) come from? I found them in a recent model but could not figure out how they came in there.

q.
« Last Edit: June 02, 2014, 04:18:42 pm by qwerty »

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Modify Package Flags
« Reply #4 on: June 02, 2014, 05:12:22 pm »
I believe it's replication, most likely JET. You'll may also find different columns in the master vs the replicas.
« Last Edit: June 02, 2014, 05:15:10 pm by simonm »

Tehila1

  • EA User
  • **
  • Posts: 256
  • Karma: +0/-0
    • View Profile
Re: Modify Package Flags
« Reply #5 on: June 02, 2014, 06:04:25 pm »
Quote
The property Flags can be written to via the automation interface so there's no need to use SQL directly.

How can I do it?
Thanks

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: Modify Package Flags
« Reply #6 on: June 02, 2014, 08:01:35 pm »
EaPackage.Flags

See the update of my Inside book.

q.
« Last Edit: June 02, 2014, 08:03:55 pm by qwerty »

Tehila1

  • EA User
  • **
  • Posts: 256
  • Karma: +0/-0
    • View Profile
Re: Modify Package Flags
« Reply #7 on: June 10, 2014, 04:49:52 pm »
Thanks, it works fine.