I’m terrible new with querys and tried to find an example everywhere, but couldn’t find what I needed.
I want to load (and view) particular records with a query.
This is what I try to make (but doesn’t work):
globals.gRecordtype = ‘klan’;
currentcontroller.loadRecords(Select klanten.naam, klanten.telefoon FROM klanten WHERE klanten.recordtype == globals.gRecordtype);
forms.klanten.controller.show();
Somebody??
currentcontroller.loadRecords(Select klanten.naam, klanten.telefoon FROM klanten WHERE klanten.recordtype == globals.gRecordtype);
wrong function
use:
getDataSetByQuery()
there are tons of references to this function in the forums.
Thank you wgknowles! I’ll go from here!
Freecolours, it looks like you are new to Servoy (That’s no shame, trust me, you will enjoy every day you are working with it!)
Please try to look into the manuals, or try to look into the CRM-demo, how querys are working, or else you got stuck very early.
It would be disappointing, if that happens and if you loose your joy, of developing in Servoy.
The manual and the CRM-demo have some fantastic sample-codes.
Try them and you will see!
Good luck!
Yes, I’m very new in developing with Servoy, but I know I’ve to start somewhere. I bought the ‘advanced programming guide for filemaker developers’ book and that helped me quit alot allready. I made a little solution in half the time that I had to work on in Filemaker Pro. So I’m very enthousiast about Servoy and expect a lot from it. .
Other thing -that I stil can’t figure out- is the external client connection to the repository database. The client can connect to the application server and download the 2mb clientfile, but they cannot connect to the repository server. Maybe you know what I need to do?
Servoy Client is pretty much automated, with 0 configuration required.
Since he was able to get the client file, that means your server is up and running.. I would check into any possible firewalling that may stop a 2 way connection from being established