Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command
Thank very much for your help. :o) That's what I need. Ge0rge --- Alexey Trunyov <[EMAIL PROTECTED]> wrote: > George Georgeus wrote: > > Hello, > > I do not know how to get the list of tables in an > > Interbase databse. When I tried to use the sql > command > > "SHOW TABLE;" in the php function "ibase_query();" > I > > got "Dynamic SQL Error SQL error code = -104 Token > > unknown - line 1,...". Select commands work well > but > > this not. "SHOW TABLE" is a regular Interbase SQL > > command. I've tried this command with the command > line > > Interbase client and it works well. > > Does anybody know where is the problem? > > Thanks Ge0rge > > SHOW TABLE and other SHOW* are not DSQL statements, > they > are just isql commands. > You may simulate this behaviour making the following > request: > select RDB$RELATION_NAME > from RDB$RELATIONS > where RDB$FLAGS = 1 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command
George Georgeus wrote: Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command "SHOW TABLE;" in the php function "ibase_query();" I got "Dynamic SQL Error SQL error code = -104 Token unknown - line 1,...". Select commands work well but this not. "SHOW TABLE" is a regular Interbase SQL command. I've tried this command with the command line Interbase client and it works well. Does anybody know where is the problem? Thanks Ge0rge SHOW TABLE and other SHOW* are not DSQL statements, they are just isql commands. You may simulate this behaviour making the following request: select RDB$RELATION_NAME from RDB$RELATIONS where RDB$FLAGS = 1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Interbase and PHP- SHOW TABLE sql command
I haven't used Interbase but could it be "show tables;". Just a thought... On Fri, 10 Oct 2003 09:34:49 +0100 (BST) George Georgeus <[EMAIL PROTECTED]> wrote: > Hello, > I do not know how to get the list of tables in an > Interbase databse. When I tried to use the sql command > "SHOW TABLE;" in the php function "ibase_query();" I > got "Dynamic SQL Error SQL error code = -104 Token > unknown - line 1,...". Select commands work well but > this not. "SHOW TABLE" is a regular Interbase SQL > command. I've tried this command with the command line > Interbase client and it works well. > Does anybody know where is the problem? > Thanks Ge0rge > > _ > ___ Want to chat instantly with your online friends? Get the FREE > Yahoo! Messenger http://mail.messenger.yahoo.co.uk > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase and PHP- SHOW TABLE sql command
Hello, I do not know how to get the list of tables in an Interbase databse. When I tried to use the sql command "SHOW TABLE;" in the php function "ibase_query();" I got "Dynamic SQL Error SQL error code = -104 Token unknown - line 1,...". Select commands work well but this not. "SHOW TABLE" is a regular Interbase SQL command. I've tried this command with the command line Interbase client and it works well. Does anybody know where is the problem? Thanks Ge0rge Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase and PHP locking (was: Interbase locking)
Hello everybody,
Some days ago I've posted a question about interbase locking. I've solved
the problem after searching at interbase developers network and php manuals.
Let me drop some line about my experiences...
Deadlock is when two (or more) transactions want update or delete a field
in the same table at the same time.
For cause a deadlock in Interbase do the following:
$tr_id1 = ibase_trans();
$tr_id2 = ibase_trans();
$result = ibase_query($tr_id1, "UPDATE TEST SET FIELD_A=FIELD_C");
echo "First result: $result";
ibase_commit($tr_id1);
$result = ibase_query($tr_id2, "UPDATE TEST SET FIELD_A=FIELD_C");
echo "Second result: $result";
If you run this you can see that the second result will be false and you'll
get
an error about interbase deadlock. Thats all right about interbase his do
its best when doing this. This error must be handled by the application.
So simple complete the code above with some check and rollback, like this:
$tr_id1 = ibase_trans();
$tr_id2 = ibase_trans();
$result = ibase_query($tr_id1, "UPDATE TEST SET FIELD_A=FIELD_C");
echo "First result: $result";
ibase_commit($tr_id1);
$result = 0;
while (!$result) {
$result = @ibase_query($tr_id2, "UPDATE TEST SET FIELD_A=FIELD_C");
echo "Second result: $result";
if (!$result) {
ibase_rollback($tr_id2);
$tr_id2 = ibase_trans();
}
}
ibase_commit($tr_id2);
This will works nicely, and you will see that the first query will fail but
the second
query (in another one transaction!) will be correct. The complete solution
is when you
write a function for the queries to runs in a transaction and its check.
Regards,
Tibor
--
Integranet Internet Service Provider Co. - www.integranet.hu
GnuPG fingerprint: 189C B343 71A8 C25F 7456 F46F D522 C34C ED7F A574
Koleszár Tibor, Director and Senior System Engineer, Debian Developer
[EMAIL PROTECTED], [EMAIL PROTECTED], http://www.oldw.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Interbase and php on win2k...
Hello :c) I cant make this work together... I have set up php (it works) I have set up ib (it works) but when i try to query ib using php i get : Fatal error: Call to undefined function: ibase_connect() in c:\inetpub\wwwroot\ib.php on line 10 I have set my extension_dir to (where the dll reside) extension_dir = C:\Servers\PHP\extensions and uncomment my dll: extension=php_interbase.dll Any one know what the broblem could be??? Thanks Christian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Interbase and php
Hi, I use Interbase 6.01 in a Linux system and i want use php for my server side language for accessing the Interbase database. When i start to use php for accessing database i seen that i can't move my row pointer (cursor) into a quey after i use ibase_query() function. Only traverse one row at a time. I can't repositioning to the first row, for example. How i can point to the first row of a query in php with Interbase without requery the data ? Thank. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Interbase and PHP support.
Od: "Mike" <[EMAIL PROTECTED]> Temat: Re: [PHP-DB] Interbase and PHP support. > > The BLOB functionality in the PHP interface is unstable. > > The process running the blob function crashes when trying to insert a > > blob ID into a table. > > That is a pretty large flakiness. > > There was one quite critical bug related to this that I fixed on July 9th > and it appeared in 4.0.2. If you are using that version, please file a bug > report with an example. BLOB functionality in this module isn't well > tested, and without some help/testing from users, could remain flaky > forever. I think that it has been finally adressed in 4.04 with php_ibase.dll version 1.48 - i had similar problems. Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase and PHP support.
On Thu, 5 Oct 2000, Johan Hanson wrote: > On Wed, 04 Oct 2000, Giovanni Tummarello wrote: > > Hello all, > > i am about to start a large project that has some heavy requirements and are > > evaluating the use of Interbase. > > The BLOB functionality in the PHP interface is unstable. > The process running the blob function crashes when trying to insert a > blob ID into a table. > That is a pretty large flakiness. There was one quite critical bug related to this that I fixed on July 9th and it appeared in 4.0.2. If you are using that version, please file a bug report with an example. BLOB functionality in this module isn't well tested, and without some help/testing from users, could remain flaky forever. -- Jouni Ahto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Interbase and PHP support.
On Thu, 5 Oct 2000, Johan Hanson wrote: > On Wed, 04 Oct 2000, Giovanni Tummarello wrote: > > Hello all, > > i am about to start a large project that has some heavy requirements and are > > evaluating the use of Interbase. > > The BLOB functionality in the PHP interface is unstable. > The process running the blob function crashes when trying to insert a > blob ID into a table. > That is a pretty large flakiness. There was one quite critical bug related to this that I fixed on July 9th and it appeared in 4.0.2. If you are using that version, please file a bug report with an example. BLOB functionality in this module isn't well tested, and without some help/testing from users, could remain flaky forever. -- Jouni Ahto -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
