(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › XResultSet  commands
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic XResultSet  commands (Read 876 times)
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
XResultSet  commands
Jun 29th, 2008 at 10:45pm
Print Post Print Post  
I am not clear on the capabilities of the commands. I have an application which contains several databases including one for all credits issued and one for all invoices and another for statements. Currently I copy all open credits and all open invoices into the statement db in order to run statements. Can I or should I use the XResultSet commands to eliminate the copy steps and the statement db?
Suggestions greatly appreciated.

Harley
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: XResultSet  commands
Reply #1 - Jun 30th, 2008 at 3:26pm
Print Post Print Post  
XResultSet can certainly do this without needing a temporary processing database. From where are you getting your opening balances? (If you are showing an opening balance.)
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Re: XResultSet  commands
Reply #2 - Jun 30th, 2008 at 4:20pm
Print Post Print Post  
The opening balances are not an issue. Only those credits and invoices that have a balance due or credits that haven't been applied to an invoice or refunded by check. I assume I can use @XResultSetSearch to get the records from each database in the application and then XResultSetSort each of them by customer number. Is that correct?

Harley
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: XResultSet  commands
Reply #3 - Jun 30th, 2008 at 4:40pm
Print Post Print Post  
pineberry wrote on Jun 30th, 2008 at 4:20pm:
The opening balances are not an issue. Only those credits and invoices that have a balance due or credits that haven't been applied to an invoice or refunded by check. I assume I can use @XResultSetSearch to get the records from each database in the application and then XResultSetSort each of them by customer number. Is that correct?

Harley


Yep. It gets even easier if your credits and invoices are in the same database.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: XResultSet  commands
Reply #4 - Jun 30th, 2008 at 9:20pm
Print Post Print Post  
Hello Erika!

you try request to clarify us over the possibilities of the XResult Commands further.
Since I am certainly that we need these commands and must use their full potential.

I would like to know:
Howe can i use the Xresutl commands wenn I add new orders in PatientOrder.DB.
Since the address of the patients and/or lastname can change, we would like - without to leave the order-form  -
overwrite or update one field or entitle the total record. So we can online refresh the Patient Form-data.

Thanks.
« Last Edit: Jun 30th, 2008 at 10:51pm by Amor »  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: XResultSet  commands
Reply #5 - Jun 30th, 2008 at 11:51pm
Print Post Print Post  
Quote:
I would like to know:
Howe can i use the Xresutl commands wenn I add new orders in PatientOrder.DB.
Since the address of the patients and/or lastname can change, we would like - without to leave the order-form  -
overwrite or update one field or entitle the total record. So we can online refresh the Patient Form-data.

Grab the sample database from my Online Information Session on this. It includes an example of doing this in one of the buttons on the Menu form.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge