Boyd,
Creating Form Variables?
I have had no problems creating more than one at a time
(except when I screw up).
Or are you talking;
SET VARIABLE v1Int INTEGER = NULL
SET VARIABLE v1Txt TEXT = NULL
These you have to set one at a time.
You can clear multiple variables but these are done one at a time.
You can also use
SELECT column1,column2,column3 INTO +
vcolumn1 INDIC ivcolumn1, +
vcolumn2 INDIC ivcolumn2, +
vcolumn3 INDIC ivcolumn3 +
FROM mytable +
WHERE mywhereclause
but it is a good idea to declare these variables first.
Jan
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, November 17, 2008 7:35 AM
Subject: [RBASE-L] - Re: Variable
> Thanks Jan.
> Also, When creating variables,
> I can only create one at a time,
> then I have to close out and re-open.
> Is there another way or method?
> Thank you,
> Boyd
>
> ---- jan johansen <[EMAIL PROTECTED]> wrote:
>> Boyd,
>> As to whether making SupplierID a variable is correct is kind of up to
>> you.
>> As you say, it works, so it must be right.
>> As to keeping the variables I would say a good rule of thumb is to
>> remove
>> any unused variables in your form. It may sound good to keep them now
>> but 3 years down the road when something goes wrong and you look at
>> the
>> form
>> again, you see all
>> these variables and think, "they must be there for a reason" and then
>> spend
>> a lot of time trying to figure out why and discover they weren't
>> needed
>> in
>> the first place.
>>
>> Good luck.
>>
>> Jan
>>
>>
>>
>> -----Original Message-----
>> From: <[EMAIL PROTECTED]>
>> To: [email protected] (RBASE-L Mailing List)
>> Date: Mon, 17 Nov 2008 14:59:17 +0000
>> Subject: [RBASE-L] - Variable
>>
>>
>> I am using RRBYW14 with V8,
>> I copied the Customer Management form to create Supplier Managment
>> form.
>> I changed the form EEP to reflect that table,In EEp and After start
>> EEP.
>> I had to make that supplierID a variable.Is this the correct approach?
>> It works.
>> Also, do I keep all customer variables in this new supplier form,
>> or do I delete them from this supplerform?
>> Thank you in advance.
>> Boyd
>
>
>