FBSQL_INSERT_ID(3) 1 FBSQL_INSERT_ID(3)fbsql_insert_id - Get the id generated from the previous INSERT operationSYNOPSIS
int fbsql_insert_id ([resource $link_identifier])
DESCRIPTION
Gets the id generated from the previous INSERT operation which created a DEFAULT UNIQUE value.
Note
The value of the FrontBase SQL function fbsql_insert_id(3) always contains the most recently generated DEFAULT UNIQUE value, and is
not reset between queries.
PARAMETERS
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns the ID generated from the previous INSERT query, or 0 if the previous query does not generate an DEFAULT UNIQUE value.
If you need to save the value for later, be sure to call this function immediately after the query that generates the value.
SEE ALSO fbsql_affected_rows(3).
PHP Documentation Group FBSQL_INSERT_ID(3)
Check Out this Related Man Page
FBSQL_CLOSE(3) 1 FBSQL_CLOSE(3)fbsql_close - Close FrontBase connectionSYNOPSIS
bool fbsql_close ([resource $link_identifier])
DESCRIPTION
Closes the connection to the FrontBase server that's associated with the specified link identifier.
Using fbsql_close(3) isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.
PARAMETERS
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
fbsql_close(3) example
<?php
$link = fbsql_connect("localhost", "_SYSTEM", "secret")
or die("Could not connect");
echo "Connected successfully";
fbsql_close($link);
?>
SEE ALSO fbsql_connect(3), fbsql_pconnect(3).
PHP Documentation Group FBSQL_CLOSE(3)
Hi,
I sometimes bulk upload data in oracle. The problem is that I sometimes get an INSERT statemnt like this:
INSERT INTO ALL_USER_HOTSPOT_DETAILS (USR_LOGIN,USR_LASTNAME,USR_FIRSTNAME,USR_EMAIL,
PROPERTYNR)
VALUES ('SABRDAG','D'AGOS','SABRINA','sabrina_d'agos@sheraton.com',70)
I... (4 Replies)
insert_FileConfig="INSERT INTO FILECONFIG ( FILE_TYPE, FILE_DESC, FILE_SCHDL_TYPE, FILE_SCHDL, FILE_SCHDL_TIME, RESULTS ) \
VALUES action_list "
i have to replace "action_list" with the contents of a variable but when i am using
echo $insert_FileConfig | sed... (6 Replies)
Hai,
I have strings as follows.
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0030166' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0029845' (INDEX (UNIQUE)
9 INDEX MODE: ANALYZED (RANGE SCAN) OF ... (2 Replies)
Discussion started by: sagarbsa
2 Replies
4. Forum Support Area for Unregistered Users & Account Problems
Hello,
I have 1000 of sql queries and i need to push column value in query. e.g.
SET INSERT_ID=1
INSERT INTO test (id,name) VALUES ('a');
SET INSERT_ID=2
INSERT INTO test (id,name) VALUES ('b');
SET INSERT_ID=3
INSERT INTO test (id,name) VALUES ('c');
SET INSERT_ID=4
INSERT INTO test... (12 Replies)
Hi All ,
I have tried many times am getting syntax error on 'UNION'
can anybody tell me ...
INSERT INTO table1
(
Type
, num_items
, num_letters
, total_value
)
(select
type='1',
num_items,
num_letters=count(*),
total_value=sum(letter_value)
from
table2
where
num_items = 1 (1 Reply)
Hi all,
recently I found that $_SERVER does not deliver the complete url with query anymore on my server.
http://www.example.org/search.php?stichwort=wiki
echo $_SERVER;
/search.phpHowever $GLOBALS works in this case.
http://www.example.org/search.php?stichwort=wiki
echo $GLOBALS;... (1 Reply)
Hi guys,
I need a help with a query. Basically i want to know the difference between (0+01)* and ((0+01)*)* . It seems whatever string can be generated by the first RE can also be generated by second and they should essentially be same. Am i missing something? (1 Reply)