T24: Virtual Tables

1,915 views
Skip to first unread message

Mayaihii

unread,
Oct 17, 2008, 5:34:07 AM10/17/08
to jBASE
Hi All,

How can i know if virtual tables exist in t24 and how can i extract a
list of all of them?

Thanks & Regard

Maya

ADENIYI KAREEM

unread,
Oct 17, 2008, 10:45:16 AM10/17/08
to jB...@googlegroups.com
Well on T24 ... we can different table type... H, L W T etc...

so... if u need to know the table type check at the PGM.FILE ... you will see the table type...
--
'Niyi Kareem
IT Consultant
P.O.Box 1006
Satellite Town,
Lagos,Nigeria
+2348023382844

Ashok Pandey

unread,
Oct 17, 2008, 12:33:03 PM10/17/08
to jB...@googlegroups.com
I think those talbes are not the virtual tables. I think after R07 release there is a table 'EB.LOOKUP' to create virtual table.
 
ASH

--
Cheers
Ashok Pandey

Saravanan Thangavelu

unread,
Oct 20, 2008, 5:54:26 AM10/20/08
to jB...@googlegroups.com
Hi,
 
From R07 Virtual table replaces the Vetting value that u define for a field,
 
Say for example if you need vetting value Yes or No for a FIELD2 in LOCAL.TABLE then
 
the table EB.LOOKUP should have a record like say TABLE.NAME*YES and TABLE.NAME*NO
 
then in field definition before FILED2 call the rotuine EB.LOOKUP.LIST with the EB.LOOKUP table ID as the arugument.
 
EX:  VIR.TABLE = "TABLE.NAME" ; CALL EB.LOOKUP.LIST("VIR.TABLE")
 
Z += 1 ; F(Z) = "FIELD2" ; N(Z) = "35" ; T(Z) = "VIR.TABLE"

--
Regards,
saravanan.T

Pawel (privately)

unread,
Oct 20, 2008, 5:22:56 PM10/20/08
to jBASE
Hello,

Do not forget about EB.TABLE.DEFINITION (available at least on T24R06), which will let you forget about templates and templates maintenance.

Basically you define everything in EB.TABLE.PROCEDURES and it works (almost) as if right template was used.
Kind regards
Pawel
----------------------------------------------------
Dołącz do Wirtualnych! Ja już mam swój profil.
Kliknij -> http://klik.wp.pl/?adr=http://corto.www.wp.pl/as/info.html&sid=524
Reply all
Reply to author
Forward
0 new messages