Hi,
In Gentran 4.0 on Windows, how do we access the system tables from Gentran
Database (lookup table). I am using the following statement to access the
lookup table: -
--------------------------------
string[22]temp_var1;
integer a;
select Text1 into temp_var1 from Partnerlookup where Tablename =
"HeaderPA"
and Item = "ID1";
a = atoi(temp_var1);
a = a + 1;
If a > 99999998 Then Begin a = 1; End
ntoa(a,temp_var1);
#HeaderId = "SFYICPA" + temp_var1;
update Partnerlookup set Text1 = temp_var1 where Tablename = "HeaderPA"
and
Item = "ID1";
-------------------
I want to know why do use "PartnerLookup" as the table name when actually there
is no table in the database with the same name.....If Gentran uses such lingo
where in the tables are accessed not with the actual name then can you give us
the details regarding how to access different tables in the database using this
Gentran lingo and whether we have some documentation for this subject. There is
a Database Guide in Gentran but it only gives a description of the tables in
the database and a brief description of the fields.
---------------------------------
Do you Yahoo!?
The all-new My Yahoo! � Get yours free!
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/OIFolB/TM
--------------------------------------------------------------------~->
.
Please use the following Message Identifiers as your subject prefix: <SALES>,
<JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC>
Access the list online at: http://groups.yahoo.com/group/EDI-L
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/EDI-L/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
