Question regarding datasets.

I've got a datasource set up where the definition is set to "query" and initially there is nothing in the datasource. Query similar to below :-

select NULL TASK_ID,
   NULL TASK_VERS,
   NULL AMEND_NO,
   NULL ISSUE_NO,
   NULL ISSUE_TEXT,
   NULL MI,
   NULL CAT_CODE,
   NULL DELETED,
   NULL DATECREATED,
   NULL DATEDELETED from DUAL where 1 = 2

The process is this, user generates an .xls file in another application and then uploads this to our FS app and we use api_datasource.importfromfile to import the .xls file into the datasource above. This works fine, our user then scrolls through the grid and selects a number of rows to import into our database. When the user closes the app the data in the "tmp" datasource is jsut discarded, next time he loads the app the datasource is obviously empty.

Now my question is this, behind the scenes in the formspider schema the datasource is linked to a real table that FS creates, in my case its called "DSI_62367", being a table I can select from it using "select * from DSI_62367" now when I do that I see all the previous data thats been loaded, when the app is closed this table does not appear to be cleared down?

One of our DBA's has queried this as some of the files the users load can be quite large (10k rows plus) and they can do this a number of times a day, he is concered regarding the space issues when the app goes live and the number of users increases.

Should this be being cleared down automatically, is there an api I can call to clear it down? We don't want to retain any data in this datasource.

Cheers Simon

asked 15 Jun '16, 04:01

apacheuk's gravatar image

apacheuk
1391223
accept rate: 0%


Hi Simon,

As you mentioned, the DSI tables should be cleared down when the application is closed, but it seems there is a problem regarding this issue, we will investigate this problem.

In the meantime, as a workaround, you can use api_datasource.clear API to clear your datasource just after your import operation.

Best Regards,
Ibrahim

link

answered 16 Jun '16, 07:20

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×64
×3

Asked: 15 Jun '16, 04:01

Seen: 3,818 times

Last updated: 16 Jun '16, 07:20


© Copyright Gerger 2017