1. Helge Tjelta
  2. Valentina Database ADK
  3. Monday, June 08 2015, 02:02 PM
  4.  Subscribe via email
Hi, is a sql select always performed against a database, or can I do a new selection inside the returned cursor.

Problem is: I have a search field, doing query to my db as you type, and this text is used in my query to the DB, this is then populated in a listbox. Now I want to do some statistics on this selection..

My statistics is sales per month grouped as month, but now with this new selection. So how can I do a new select inside a cursor.... or is it a select from DB in a new select DB in ().
Comment
There are no comments made yet.
Beatrix Willius Accepted Answer
AFAIK this is not possible. You can populate a table from you query and then do another select on this table.

However, what you want is a feature that I love from Access. Instead of making complex queries I build query upon query for a simple reporting tool. Is there a feature request???
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Jochen Peters Accepted Answer
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Ruslan Zasukhin Accepted Answer
Hi Helge,

did you solve original task?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories