-------- Original Message --------
Subject: Re: [dabo-users] Displaying data from multiple tables into a
single grid
Date: Wed, 24 Apr 2013 07:09:06 -0700
From: John Fabiani <[email protected]>
Reply-To: [email protected]
To: Sabarish Sridhar <[email protected]>
On 04/24/2013 06:26 AM, Sabarish Sridhar wrote:
The entire database is read only. The user cant change any data. I
merely display the data that the user requests using the grid. If he
double clicks on a particular record it just shows more read only info.
Great, then use a view. Use a function to pass the parameters and
return the DataSet from the view. BTW you can create a function (store
procedure?) in the database or create a method (in the code) that does
the same thing.
Views are great for readonly data. You can do anything you can do with
SQL in the view and return the data as needed.
I'm assuming you have permissions to add a view.
If by chance you do not have permissions - just setup a method to do the
work:
def get_the_data(self, option1, option2):
my_local_cursor = self.getTempCursor()
my_local_cursor.execute("some unique SQL statement using the options")
if my_local_cursor.RowCount> 1:
return my_local_cursor.getDataSet()
else:
dabo.ui.stop(self = parent, message = "Error Will Robinson")
Johnf
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
