inverting records

Questions, tips and tricks and techniques for scripting in Servoy

inverting records

Postby Ron » Thu Jun 05, 2003 12:53 pm

Total amount of recs is 91.
The found set is 11.
Now I want to get the 80 records not found.
I added the invert-function, but this results in 10 records.
This is my find-method:

controller.find()
country="Germany"
controller.search()

WHAT NEXT?

Please help me out.
Ron
 
Posts: 315
Joined: Fri May 23, 2003 12:30 am
Location: Netherlands

Postby edward » Thu Jun 05, 2003 1:25 pm

forms.addresses.controller.find()
forms.addresses.country="Germany"
forms.addresses.controller.search()
forms.addresses.controller.invertRecords()

Works fine for me... finds all the non-Germany addresses.... what happens when you run the method?
Edward Callaghan
Servoy
edward
 
Posts: 142
Joined: Wed Apr 23, 2003 9:35 pm
Location: London, UK

Postby Ron » Thu Jun 05, 2003 4:25 pm

I am glad we share the same sense of humor Edward. : :D
Unfortunately it still doesn't work.
I did put your syntax but it still gives 10 germans.
I only substituted adresses by customers, since that's the name of my form.
Funny thing is that without the last line (as before) the 11 germans our found.
So I tried to do it manually...
First looking for the germans, OK: 11 of 92 and then
select/invert records... it gave 10 (again!)
It looks like the invert function does not work properly in my v.1.01.
What do you think, time for the 1.1-build?
When will it be available for download, or am I going to fast now?

Regards,

Ronald
Ron
 
Posts: 315
Joined: Fri May 23, 2003 12:30 am
Location: Netherlands

Postby edward » Thu Jun 05, 2003 4:30 pm

Hey Ron..
GOOD NEWS MATE: 1.1 is available now!

NOTE: This is a PRE-RELEASE, DO NOT USE IN PRODUCTION

Before you install it make a backup of your current Servoy directory and databases.

If you only use Firebird all you need to do is copy your entire Servoy folder and you will have a full backup of your previous installation.

Once you have made a full backup you can choose to upgrade your current installation by installing Servoy into the same directory or to perform a fresh install by either un-installing the previous version or by installing Servoy in a new directory.

M-

This new version also contains updated documentation and an updated version of the CRM example solution. If you perform an upgrade then your CRM solution will not be upgraded (this to avoid overwriting changes you might have made to it). You can import the solution through the repository dialog; it is located in the solutions/example directory.

M-

NOTE: Note: fmp plug-in is not longer shipped, but you can download it here (http://http://downloads.servoy.com/beta/fmp.jar) if you have dependencies on it (all its functions are now possible with the new utils node). To install it simply place it in the plugins directory.

M-

Servoy 1.1rc2 is a very exciting release with numerous new features and fixes of issues in 1.01. Amongst others:

-You can now execute your own SQL and retrieve results in various ways

-Support for images in fields

-Improved html rendering

-color coding in method editor

-support for sliding fields and smart break, sliding fields can also grow from one line to multiple pages

M-

You can find more details and instructions for download on the Servoy Forum:
http://forum.servoy.com/viewtopic.php?t=176


Hope this helps Ron...
Edward Callaghan
Servoy
edward
 
Posts: 142
Joined: Wed Apr 23, 2003 9:35 pm
Location: London, UK

Postby Ron » Thu Jun 05, 2003 5:50 pm

:D :D It certainly did!!
Thanks Ed.
I worked with it yesterday but haven't been able to take it along
But again I must say, this is realy cool!
It's gonna be late this night, that's for sure!

Ron
Ron
 
Posts: 315
Joined: Fri May 23, 2003 12:30 am
Location: Netherlands

Postby edward » Thu Jun 05, 2003 5:53 pm

Excellent news! Keep us posted on your progress!
Edward Callaghan
Servoy
edward
 
Posts: 142
Joined: Wed Apr 23, 2003 9:35 pm
Location: London, UK


Return to Methods

Who is online

Users browsing this forum: No registered users and 14 guests

cron