load record without foundset

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

load record without foundset

Postby info » Mon Mar 12, 2012 6:58 pm

Hi,

I want to load a query from DB without use a foundset of form.
How can I do it and use all data?

Thanks for help
info
 
Posts: 37
Joined: Fri Feb 03, 2012 4:38 pm

Re: load record with foundset in another form

Postby jasantana » Mon Mar 12, 2012 7:00 pm

Could you please give us some more information on your needs
Best regards,
Juan Antonio Santana Medina
jasantana@galsaninformatica.com
EAGER BEAVER 2011
EAGER BEAVER 2012
Servoy 6.0.5 - Servoy 6.1 - Servoy 7.3 - PostgreSQL 9- Visual Foxpro 9
User avatar
jasantana
 
Posts: 487
Joined: Tue Aug 10, 2010 11:40 am
Location: Las Palmas - Gran Canaria - España

Re: load record without foundset

Postby info » Mon Mar 12, 2012 7:11 pm

I have "form1" where this form is connected to "table1" and I need to make a query to "table2" for verify a value when i click a button in "form1".
Can I load some values from "table2" without create another form connect to "table2"?
Because isn't efficent create a form for every table.
info
 
Posts: 37
Joined: Fri Feb 03, 2012 4:38 pm

Re: load record without foundset

Postby ptalbot » Mon Mar 12, 2012 7:26 pm

Have a look at databaseManager.getFoundSet or databaseManager.getDataSetByQuery
Patrick Talbot
Freelance - Open Source - Servoy Valued Professional
http://www.servoy-stuff.net
https://www.servoyforge.net
--------------------------------------------
Servoy 5.2.16 / 6.0.9 / 6.1.6 / 7.3.1
All OSes / Java 5 & 6 & 7
User avatar
ptalbot
 
Posts: 1623
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC

Re: load record without foundset

Postby info » Tue Mar 13, 2012 4:31 pm

ptalbot wrote:Have a look at databaseManager.getFoundSet or databaseManager.getDataSetByQuery


thanks! is perfect!
info
 
Posts: 37
Joined: Fri Feb 03, 2012 4:38 pm


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 2 guests