Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Listing files in a store.
Thu, Jul 22 2010 6:47 AMPermanent Link

David McCauslan

Is it possible to retrieve the names of the files in a store using the select statement?
Thu, Jul 22 2010 7:44 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

David


Yes, its a two part operation

1. Select the store wanted using

SET FILES STORE TO storename (no quotes)

2. Get the list of files with

SELECT * FROM Files

I dug it out of EDBManager. took a few minutes cos its so beautifully OO'd

There may be a way to do it with a single statement, but if so I don't know it Smiley

Roy Lambert [Team Elevate]
Thu, Jul 22 2010 11:21 AMPermanent Link

David McCauslan

Thanks Roy exactly what I was looking for.

David

Yes, its a two part operation

1. Select the store wanted using

SET FILES STORE TO storename (no quotes)

2. Get the list of files with

SELECT * FROM Files

I dug it out of EDBManager. took a few minutes cos its so beautifully OO'd

There may be a way to do it with a single statement, but if so I don't know it Smiley

Roy Lambert [Team Elevate]
Image