Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Baanboard at LinkedIn


Poll
What actions do you take to ensure compliance with the sanction/embargo lists published by the EU and the US?
don't know what you are talking about
55%
we are scanning customers, suppliers and employees using own programs on a regular basis
12%
each delivery/purchase adress is checked immediately with own programs
2%
we are using third party software for this purpose
10%
we simply don't bother
20%
Total votes: 49

Reference Content

 
db.bind()
By patvdv at 26 Feb 2008 - 21:57


db.bind()

Syntax

long db.bind( string
table_name(9) [, ref string buffer(.) [, long comp_nr]]
)

Description

This creates a pointer to a specified table. It returns a table ID that you use in other database calls to identify the table. The pointer is to a table with a particular company number and record buffer. You can create additional pointers to the same table by calling the function with a different company number and/or record buffer.

Arguments

table_name

The table name.

buffer

This optional argument specifies the record buffer to be used for the table. If you omit this argument, or if you specify an empty string, the default record buffer is used (that is, rcd.tppmmmxxx).

comp_nr

This optional argument specifies a company number for the table. The default company is the company of the user. If you include this argument, you must also include the buffer argument. So, if you want to specify a company other than the default company but want to use the default record buffer, specify the default buffer or an empty string in the buffer argument.

Note

When you create more than one pointer to a table, you must use a different record buffer for each one.

Return values

0

Error.

>0

Success; pointer is returned.

Context

Bshell function.

Example

 long tcmcs001_id

if (switch.to.company(200) > 0) then
tcmcs001_id = db.bind("ttcmcs001")
db.first(ttcmcs001_id)
endif
...
db.first(ttcmcs001)

Related topics


0
No votes yet


All times are GMT +2. The time now is 00:22.


©2001-2008 - Baanboard.com - Baanforums.com