Gossamer Forum
Home : General : Databases and SQL :

counter in interbase

Quote Reply
counter in interbase
Why wont interbase not accept this ... its working just fine with mysql??

public int tæller()
{
int ialt=0;
try
{
ResultSet row = db.select( "SELECT count(*) AS Amount FROM Gaest" );

ialt = row.getInt("Amount");
}
catch( SQLException cs )
{
System.out.println( cs );
}
return ialt;
}

Quote Reply
Re: [aslan] counter in interbase In reply to
Unforunately, each SQL database storage application (e.g., Oracle, MySQL, miniSQL, Postgres, SQL Server, and Sybase) all use unique SQL programming languages...example: SQL Server uses TSQL (transact SQL).

One thing that I learned during a database modelling and design course I took awhile back is that there is NO standardization within SQL based storage applications. Each uses its own instrinsic source of SQL.

So, therefore, the reason that the SQL statement you've doesn't work in one SQL database storage app and works in another is because of the reason I outlined above.

Therefore, you need to read up on what functions are accepted in interbase versuses other database apps.
========================================
Buh Bye!

Cheers,
Me