Hello Dynan,
The tablename of PartnerLookup is a SQL alias.
Alias's are used frequently in all Database depenedent applications.
In your administrators guide there is a complete description of all
the tables Gentran NT uses and for what purpose.
Keith
--- In [EMAIL PROTECTED], Dnyan Bhar <[EMAIL PROTECTED]> wrote:
> 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/
