Tom
After the CHOOSE
SET VAR vKidPhrase = ('(' + .vKidlist + ')')
Then in INSERT:: WHERE Personid IN &vKidPhrase
David Blocker
----- Original Message -----
From: "Tom Grimshaw" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 02, 2002 9:30 PM
Subject: CHCKBOX Is this right?
> After this:
>
> SET VAR vKidList TEXT = NULL
> CHOOSE vKidList +
> FROM #VALUES +
> FOR (LJS(t2.Surname,22) & LJS(t2.Salutatn,22) & +
> LJS(CTXT(t2.DOB),12)),t2.PersonID +
> FROM AsocPers t1,Persons t2 +
> WHERE t2.PersonID = t1.Assoc_PersonID +
> AND t1.PersonID = .vPersonID +
> ORDER BY t2.Surname,t2.Salutatn +
> AT 7,45 +
> CHKBOX +
> TITLE 'Linked Kids' +
> CAPTION .vModuleName +
> LINES .vKidCount +
> FORMATTED
>
> This:
>
> INSERT INTO TempPersonNewBatch +
> (Surname,Salutatn,ParentGuardian,DOB, +
> HireEnqID,PersonID,Sex,CheckValue, +
> PersNumb,PoGPersonID) +
> SELECT +
> Surname,Salutatn,'Y',DOB, +
> .vHireEnqID,PersonID,Sex,'Y', +
> .vUserID,.vPersonID +
> FROM Persons +
> WHERE PersonID IN (.vKidList)
>
> returns the error message:
>
> Column SYS_COMM must be compared to INTEGER values (2042)
>
> vKidList is set to 32075,32074
>
> Please someone, put me out of my misery, what am I missing here?
>
>
> Warmest regards,
>
>
> Tom Grimshaw
> coy: Just For You Software
> tel: 612 9552 3311
> fax: 612 9566 2164
> mobile: 0414 675 903
>
> post: PO Box 470 Glebe NSW 2037 Australia
> street: 3/66 Wentworth Park Rd Glebe NSW 2037
>
> email: [EMAIL PROTECTED]
> web: www.just4usoftware.com.au
>
> "... the control of impulse -- is the first principle of civilization."--
> Will Durant,
> Pulitzer Prize winning philosopher, writer and historian
>
> the most needed product in the world can be found at
> www.thewaytohappiness.org
>
> This email and any files transmitted with it are confidential to the
> intended recipient and may be privileged. If you have received this email
> inadvertently or you are not the intended recipient, you may not
> disseminate, distribute, copy or in any way rely on it. Further, you
should
> notify the sender immediately and delete the email from your computer.
> Whilst we have taken precautions to alert us to the presence of computer
> viruses, we cannot guarantee that this email and any files transmitted
with
> it are free from such viruses.
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
