test

-----Original Message-----
From: Jerrie Cate [mailto:jerriecate@JUNO.COM]
Sent: Thursday, January 25, 2001 3:43 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

I get that, too, and it drives me nuts! When I link forms for reports I
use the generic Oracle ODBC instead of the Remedy ODBC and it works fine.
The only problem with that is the requirement for date conversions if you
wish to search on a date range with parameters. And, the field names are
in alphabetical order. Not a large problem if you get the results you
seek.

Jerrie Cate
Jerrie_Cate@pgn.com
Portland General Electric
503-464-8232

On Thu, 25 Jan 2001 09:05:55 -0500 Joanne Mansur
writes:
> **
>
> The Remedy ODBC driver does not support multiple db and links.
> You need to load a different ODBC driver, or create a join form and
> report off that.
> HTH
> Joanne
>
> >>> "Yost, Shane" 01/24/01 04:59PM >>>
> **
>
> Hey there fellow listers, I have a Crystal 7 question.
> I am compiling a report that is joining 2 tables with in Remedy, and
> matching up 2 fields and pulling the appropriate fields for the
> report.
> There are no errors while compiling this, but when I try to run the
> report
> at the end of designing it, it comes back with the following error.
>
> "ODBC error: column found in multiple tables"
>
> How do I fix this problem?
> The fields that I am matching together are identical except for the
> name of
> them.
> I get this error on the 4.0.3 and the 4.5.1 ODBC driver.
> The permissions for the ODBC logon is Admin.
>
> Thank you,
>
> Shane Yost
> Applications Engineer
> CA ISO
> 916-351-2352
>
>
>
>
>
>
>
>

Hi there,

How is it possible to run a macro with variables when one of the fields of
the forms is an integer field? How can I make a prompt for this kind of
fields?

Does anyone have any idea?

Regards,

Efi

Hi, Efi
There's no difference with character type fields. If you want to ask for an
integer field when running the macro, just define a variable enclosed with
"$" when recording the macro, the same as you would do for a character
field.

Ciao,
Björn.

-----Mensaje original-----
De: Mici Efterpi [mailto:emici@INTRASOFT.GR]
Enviado el: martes 30 de enero de 2001 17.24
Para: ARSLIST@LISTSERV.VISTAIT.COM
Asunto:


**

Hi there,

How is it possible to run a macro with variables when one of the fields of
the forms is an integer field? How can I make a prompt for this kind of
fields?

Does anyone have any idea?

Regards,

Efi

I would think you can prompt for the integer field the same as you would for
a text field. While recording the macro simply type into the integer field
$Enter Value$. Then when you run the macro it should prompt you for the
integer value.

Marco Rasile
e-Solution Developer
mrasile@burntsand.com

Burntsand Inc.
304 The East Mall, Suite 500
Toronto ON M9B 6E4
Ph. (416) 234-3893
Fx. (416) 234-3900

www.burntsand.com


-----Original Message-----
From: Mici Efterpi [mailto:emici@INTRASOFT.GR]
Sent: Tuesday, January 30, 2001 11:24 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Hi there,

How is it possible to run a macro with variables when one of the fields of
the forms is an integer field? How can I make a prompt for this kind of
fields?

Does anyone have any idea?

Regards,

Efi

Efi,
Yes, use the Query bar to state your Query when recording the macro. For
example 'Integer-field-name' > $value$.
When the search is performed it will prompt for the value. If incorporating
into an active link map value to the appropriate field in the form.

Larry Salisbury
Acxiom Corporation
Woodland Hills, CA
voice: 818-715-5679
fax: 818-715-5218

-----Original Message-----
From: Mici Efterpi [SMTP:emici@INTRASOFT.GR]
Sent: Tuesday, January 30, 2001 08:24
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:

**

Hi there,

How is it possible to run a macro with variables when one of the fields of
the forms is an integer field? How can I make a prompt for this kind of
fields?

Does anyone have any idea?

Regards,

Efi

Not quite correct - you can only type a value in the query bar, not using
QBE on the form, and for an integer you should not wrap the parameter in
quotes. Often the easiest way is to edit the macro in a text editor to
change, for example,
536871197=1 to 536871197=$IntegerValue$

HTH

David Sanders
Remedy Consultant
=================
IT Masters

tel +44 1895 909500
mobile +44 7785 280510
email dsanders@itmasters.com
web http://www.itmasters.com


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Bjorn Calabuig
Sent: 30 January 2001 16:35
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Hi, Efi
There's no difference with character type fields. If you want to ask for an
integer field when running the macro, just define a variable enclosed with
"$" when recording the macro, the same as you would do for a character
field.

Ciao,
Björn.

-----Mensaje original-----
De: Mici Efterpi [mailto:emici@INTRASOFT.GR]
Enviado el: martes 30 de enero de 2001 17.24
Para: ARSLIST@LISTSERV.VISTAIT.COM
Asunto:


**

Hi there,

How is it possible to run a macro with variables when one of the fields of
the forms is an integer field? How can I make a prompt for this kind of
fields?

Does anyone have any idea?

Regards,

Efi

You have reason, David
My english isn't very good...what I wanted to say is that, if you want to
use an integer field to parametrize it in a macro, for example a field
called Priority, when recording the macro, you should write $Priority$ (for
example) without double quotes (the same as for character fields) on the
field and then, when you push on search, the macro will prompt you to
introduce a nummeric value. Once saved the macro, when you execute it, the
macro will ask you for this field, that's all. Perhaps I'm wrong but it
works to me.

Björn.

-----Mensaje original-----
De: David Sanders [mailto:dsanders@ITMASTERS.COM]
Enviado el: martes 30 de enero de 2001 18.18
Para: ARSLIST@LISTSERV.VISTAIT.COM
Asunto:


**

Not quite correct - you can only type a value in the query bar, not using
QBE on the form, and for an integer you should not wrap the parameter in
quotes. Often the easiest way is to edit the macro in a text editor to
change, for example,
536871197=1 to 536871197=$IntegerValue$

HTH

David Sanders
Remedy Consultant
=================
IT Masters

tel +44 1895 909500
mobile +44 7785 280510
email dsanders@itmasters.com
web http://www.itmasters.com


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Bjorn Calabuig
Sent: 30 January 2001 16:35
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Hi, Efi
There's no difference with character type fields. If you want to ask for an
integer field when running the macro, just define a variable enclosed with
"$" when recording the macro, the same as you would do for a character
field.

Ciao,
Björn.

-----Mensaje original-----
De: Mici Efterpi [mailto:emici@INTRASOFT.GR]
Enviado el: martes 30 de enero de 2001 17.24
Para: ARSLIST@LISTSERV.VISTAIT.COM
Asunto:


**

Hi there,

How is it possible to run a macro with variables when one of the fields of
the forms is an integer field? How can I make a prompt for this kind of
fields?

Does anyone have any idea?

Regards,

Efi

Bjorn is correct, you can enter a parameter into an integer field during the recording of a macro. This is the only time a non-numeric can be entered there.

John.


John Bibby
Consultant
Remedy Administration and Development
Application Support
Ericsson ITServices

*: 1085 Fax: 1398
email: john.bibby@etl.ericsson.se


-----Original Message-----
From: Bjorn Calabuig [mailto:bcalabuig@CTC.ES]
Sent: 30 January 2001 17:54
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

You have reason, David
My english isn't very good...what I wanted to say is that, if you want to
use an integer field to parametrize it in a macro, for example a field
called Priority, when recording the macro, you should write $Priority$ (for
example) without double quotes (the same as for character fields) on the
field and then, when you push on search, the macro will prompt you to
introduce a nummeric value. Once saved the macro, when you execute it, the
macro will ask you for this field, that's all. Perhaps I'm wrong but it
works to me.

Björn.

-----Mensaje original-----
De: David Sanders [mailto:dsanders@ITMASTERS.COM]
Enviado el: martes 30 de enero de 2001 18.18
Para: ARSLIST@LISTSERV.VISTAIT.COM
Asunto:


**

Not quite correct - you can only type a value in the query bar, not using
QBE on the form, and for an integer you should not wrap the parameter in
quotes. Often the easiest way is to edit the macro in a text editor to
change, for example,
536871197=1 to 536871197=$IntegerValue$

HTH

David Sanders
Remedy Consultant
=================
IT Masters

tel +44 1895 909500
mobile +44 7785 280510
email dsanders@itmasters.com
web http://www.itmasters.com


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Bjorn Calabuig
Sent: 30 January 2001 16:35
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject:


**

Hi, Efi
There's no difference with character type fields. If you want to ask for an
integer field when running the macro, just define a variable enclosed with
"$" when recording the macro, the same as you would do for a character
field.

Ciao,
Björn.

-----Mensaje original-----
De: Mici Efterpi [mailto:emici@INTRASOFT.GR]
Enviado el: martes 30 de enero de 2001 17.24
Para: ARSLIST@LISTSERV.VISTAIT.COM
Asunto:


**

Hi there,

How is it possible to run a macro with variables when one of the fields of
the forms is an integer field? How can I make a prompt for this kind of
fields?

Does anyone have any idea?

Regards,

Efi