Book a Demo

Author Topic: use of  sql queries save  into 'Queries' 'package'  (Read 4635 times)

ddb

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
use of  sql queries save  into 'Queries' 'package'
« on: July 10, 2015, 06:20:09 am »
v 12 (newest)
when using database builder, there is a possibility to compose and run a sql command in sql scratch pad window and save it  (like save to file) or to save it to 'Queries' 'package' of the project.
That works great!
But I find no way to extract it back from 'Queries' 'package' of the project and use save sql quesry again?
'Open' option works only to open sql queries saved to file.

Help, anyone? Thank you!

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: use of  sql queries save  into 'Queries' 'pack
« Reply #1 on: July 10, 2015, 07:34:14 am »
Look for the SQL Query object's SQL tagged value. Open the tagged Value Window or open the SQL Query object properties | Tags tab.

ddb

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: use of  sql queries save  into 'Queries' 'pack
« Reply #2 on: July 11, 2015, 01:23:33 am »
thanks, gne!
that helps to find the information, i.e. saved sql query text..

But looks rather complicated to extract, copy and paste back to sql scratch to be performed, isn't it?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: use of  sql queries save  into 'Queries' 'pack
« Reply #3 on: July 11, 2015, 02:36:19 am »
I haven't explored but sounds like the usual EA way (remember that song from Frank Sinatra "I did it EAAAA way").

q.

ddb

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
    • View Profile
Re: use of  sql queries save  into 'Queries' 'pack
« Reply #4 on: July 11, 2015, 06:04:51 am »
 :) !!!