RE: [Arsperl-users] Database fields vs ars fields

[Stapff, T. <thi...@ma...>]

Are you sure it is not a display only field?

Regards,
Thilo


-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] 
Sent: Thursday, March 09, 2006 5:01 PM
To: ars...@ar...
Subject: [Arsperl-users] Database fields vs ars fields


Hello all,

I've got questions concering the fields in a form versus how they are stored
in the database.  I've found some inconsistancies.

When using the ars_perl commands:

	@fieldidlst = ars_GetListField($c,$schema,0,1);

and 

	%field_hash=ars_GetFieldTable($c,$schema);

I can get a good list of the fields in a form.

When comparing this list to the view and table in Oracle, I have different
results.

Lets take the example that I'm working with: We are using the SAM (Software
Asset Management) Remedy product. for it's AST:Asset form, I am trying to
pull back the field:

'Application ID' which has a database name of 'Application GUID' or
'Application_GUID' in SQL.  It's database ID is '400081600'

This field is in the form, but it is not in the Oracle table "AST_ASSET" 

It also does not appear in the table designaetd in the arschema lookup table
(T2022) which (I beleive) would be 'C400081600'.

When loking in the Remedy Admin tool, the field looks like any other field,
but for some reason, it is not stored in the same place with the other
fields.

Why is this different and where can I find this field to get it's data in
Oracle?


Thanks,

Brent

  






-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users