Is it posible to have and manipulate with no datasource based grid columns (lookup fields for example, or calculated fields).

I have a grid, with hiden foreign-key ID field, and two lookup fields: non datasource CODE (updateable) field of FK table, and NAME field of the same FK table. I'm changing the FK ID hiden field through CODE filed and I have to have it set by the post-pre-query (somehow) of the data source query process. The Formspider don't have updateable query and the updatable VIEW is not posible due to outern join to the FK. In fact, it's selfconnectin table (organization units) with parent-child-subchild structure

asked 09 Jun '14, 04:34

ddjuric's gravatar image

accept rate: 0%

edited 09 Jun '14, 05:09

Hi Dusan,

If I understand you correctly, what you are trying to achieve should be possible. I would create a Database View and write Instead of Update, Insert, Delete Triggers for the View to make it updateable. This way you can handle all the necessary DML in these triggers.

Hope this helps,

Kind Regards,


answered 09 Jun '14, 05:51

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Thx, it works for now

(09 Jun '14, 08:52) ddjuric
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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



Asked: 09 Jun '14, 04:34

Seen: 2,067 times

Last updated: 09 Jun '14, 08:52

© Copyright Gerger 2017