[Arsperl-users] unsubscribe

[Firas K. \(fkhasawn\) <fkh...@ci...>]

=20
unsubscribe
-----Original Message-----
From: ars...@ar...
[mailto:ars...@ar...] On Behalf Of Bowman, Brent A
Sent: Thursday, March 09, 2006 11:01 AM
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 =3D ars_GetListField($c,$schema,0,1);

and=20

	%field_hash=3Dars_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

 =20






-------------------------------------------------------
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=3Dk&kid=110944&bid$1720&dat=121642
_______________________________________________
Arsperl-users mailing list
Ars...@ar...
https://lists.sourceforge.net/lists/listinfo/arsperl-users