Recent content by hilbrink

The situation is that we have an application that runs on different database servers such as Oracle, SQL Server, Interbase. In order to communicate with these databases we use SQL. First standard SQL and translate this to the SQL dialect that is needed. Our standard SQL includes the cast...

I'm using 8.0.6

What is wrong with the following: select cast(sysdate as varchar2(20)) from dual; Te error message i get is: select cast(sysdate as varchar2(20)) from dual * ORA-00905: missing keyword ?? please help (What i try to do is to cast several things (the above is just an...

i believe there is no such thing.... :-(

When exporting, the default values for certain parameters are operating-system specific. Specifically, the BUFFER parameter defaults to a value of 4K under Windows NT and the RECORDLENGTH parameter defaults to 2K. I don't know what these parameter defaults are for Solaris. But perhaps this has...

You can compare some databases at: http://www.mysql.com/information/crash-me.php maybe that can help you giving insight in the possibilities of the different databases.

What error(s) do you get?

Do you get an error message? (-:

Is the parameter a string? Looks like an integer to me, perhaps you should try using: query1.params[0].asInteger := 001; Hope this helps ::-)

What exactly are you trying to accomplish in the where-clause? And what do you mean with "clauses from the same dimension"? The WHERE clause is a filter that defines the conditions each row in the source tables must meet to qualify for the SELECT. Example: SELECT ...... FROM...

Hello, Can anybody tell me how to execute a procedure that you pass as a parameter? I have: type DBproc = procedure(); procedure DBUpdateProcedure(a_procedure: DBproc); begin {statements} a_procedure; end; procedure proc_a(); begin {statements} end; Then I would like to execute...

Have you considered using the datatype BLOB (binary large object)?

perhaps there is procedure thant constantly updates that table or some other process that does something with the table and never ands... check for infinite loops

Try to make use of the uniqueidentifier datatype and NEWID function: create table test( ID uniqueidentifier NOT NULL default NEWID(), ...

Have you tried export/import?